Board index » delphi » Delphi 7, MySQL and ADO

Delphi 7, MySQL and ADO


2005-04-08 11:01:07 PM
delphi175
Hi all,
Is that combination (Delphi 7, MySQl and ADO) possible (reliable)?. If so.
What's the way?.
Thanks in advance,
A.Afonso.
 
 

Re:Delphi 7, MySQL and ADO

Hi,
"A.Afonso" <XXXX@XXXXX.COM>escribi?en el mensaje
Quote
Hi all,

Is that combination (Delphi 7, MySQl and ADO) possible (reliable)?.
It can work and not badly, yes.
Quote
If so. What's the way?.
Theoretically you should use a specific OLE DB provider for MySQL, so that
ADO could be used to access it. The problem lies in the fact that the OLE DB
provider from www.MySQL.com is from year 2001 and does not work correctly.
In fact, it causes a lot of strange problems (own experience...), so if you
want to use MySQL with ADO you will have to do it through the ODBC, which adds
an extra layer but is AFAIK the only way (if someone knows a good OLE DB
provider for MySQL please tell me)
To be more concrete, when you create your connection string, you should
select the ODBC connection. Check www.connectionstrings.com to see which one
fits your app better.
--
Best regards :)
Guillem Vicens
Dep. informática Green Service SA
XXXX@XXXXX.COM
www.clubgreenoasis.com