ADO, Delphi 7, and Access 2000

From: Jerry Gagnon (Jerry_at_Gagnon.com)
Date: 09/15/04 

Date: Tue, 14 Sep 2004 22:10:53 -0400

I've asked a few questions on here regarding the three things in the
subject. I am only using Access until I get the hang of using MSDE (I know
SQLServer pretty well, just don't really know the ins and outs of MSDE yet).
Delphi 7's ADO implementation seems to be generally buggy from what I am
gathering. Is it more to do with Access or ADO in general? If I use
ADO/MSDE (or SQL Server) should I expect fewer problems than ADO/Access?

As much as I'd hate to, should I go back to using ODBC since I had fewer
problems with that? Or, at least, until the kinks are worked out of
Borland's ADO code? Is there a better solution than ADO or ODBC?

My needs are simple, really. I have a relatively generic database
application that could have as many as 5 users most of the time (possibly
more, but unlikely). Very low traffic per day is expected (a few hits an
hour, minor reporting, some exporting of data). I would hate to start off
on the wrong foot, so to speak, with the "wrong" tools. ADO is so much
nicer to work with than ODBC but I've been noticing the downside.

Anyway, input is greatly appreciated.

Relevant Pages

  • Re: ADO, Delphi 7, and Access 2000
    ... just don't really know the ins and outs of MSDE yet). ... Is it more to do with Access or ADO in general? ... Is there a better solution than ADO or ODBC? ... I have a relatively generic database ...
    (borland.public.delphi.database.ado)
  • Re: PasteAppend - Clipboard not responding
    ... hmmm (I hate that question:). ... ADO is probaly not the fixall, but in my experience I have had more ... reliability with ADO than with ODBC - less issues overall. ... it has something to do with the workstation that is triggering ...
    (comp.databases.ms-access)
  • Re: TADO vs. TQuery
    ... >> I have an application that uses ODBC to connect to MS SQL ... >> this benefit greatly if I changed to ADO? ... It will take a while to 'tune up' ADO objects to get BDE speed. ... Eventually we started using DOA (Direct ...
    (borland.public.delphi.database.ado)
  • Re: ADODB.Connection object not returning correct ConnectonString prop
    ... Opens the connection (successfully) ... I'm not positive but a guess is that ADO is using the MSDASQL Provider to ... provide OLE DB support for ODBC. ... ODBC Driver. ...
    (microsoft.public.data.ado)
  • Re: Problem updating a record containing a negative Value
    ... If it is the same in ADO or ADO.NET then this is definitely a bug in ODBC ... driver from the vendor. ...
    (microsoft.public.data.ado)