ADO and ODBC

From: Holger Flick (rammbaer.xyz_at_xyz.gmx.de)
Date: 03/21/05 

Date: Mon, 21 Mar 2005 11:05:30 +0100

Hi people,

I use ADO to access MySQL using the ODBC driver.

Yes, it's not the way to go, but dbExpress is outdated and work with the
newest mysqllib.dll. I tried for hours...

The final problems I have:

        - when I have a DATETIME in my table I cannot open the ADO table, it
throws an exception with the error 'ERR_FAIL'
        - VARCHARs of different lengths, which are all shorter than 100 are
added as TMemoFields (sometimes...)
        - VARCHARs are added automatically with wrong "size", so you have to
set them up manually...

Any hints? 

--
Holger

Relevant Pages

  • Re: ADO and ODBC
    ... >I use ADO to access MySQL using the ODBC driver. ... >Yes, it's not the way to go, but dbExpress is outdated and work with the ...
    (borland.public.delphi.database.ado)
  • Re: dbExpress als Alternative für FIBPlus?
    ... und Oracle 9i mit dbExpress gearbeitet und war durchaus angetan. ... habe zwar auch gute Erfahrungen mit ADO und ADO.Net für den Zugriff auf ... OLEDB-Treibern für den Zugriff auf FireBird mittels ADO gemacht hat, ... > das ein Vorteil?), die Dokumentation scheint gut zu sein, es gibt ...
    (de.comp.lang.delphi.datenbanken)
  • Re: Delphi books of intrest?
    ... I'll cover the Borland Database Engine, dbGo for ADO, dbExpress ... and the stand-alone TClientDataSet. ... Delphi, although ADO needs Delphi 5 or higher, dbExpress needs Delphi ...
    (borland.public.delphi.non-technical)
  • Re: ADO and ODBC
    ... > I use ADO to access MySQL using the ODBC driver. ... you could try with the Firebird database also. ... It's free open source based in Interbase. ...
    (borland.public.delphi.database.ado)
  • Re: ADO vs dbExpress
    ... dbExpress is the better choice for DB connectivity? ... We are currently using SQL 2005 and ADO seems like a logical choice, ...
    (borland.public.delphi.database.ado)