Re: Delphi 7, MySQL and ADO

Hi,

"A.Afonso" <aafonso@xxxxxxxxx> escribió en el mensaje
news:42569c8c@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi all,
>
> Is that combination (Delphi 7, MySQl and ADO) possible (reliable)?.

It can work and not badly, yes.

> 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'll 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
guillemvicens@xxxxxxxxxxxxxxxxxx
www.clubgreenoasis.com


.

Relevant Pages

  • RE: Database Lookup Functoid Connection String
    ... A OLE DB provider is a COM component which implement a number of COM ... And connection string is a way to initialize a OLE DB provider. ... accessed by the BizTalk server account, ...
    (microsoft.public.biztalk.general)
  • Re: ODBC Drivers error 80040e31
    ... I've changed the connection string and am connecting with OLE DB provider now...we'll see if it makes any difference... ... Aaron Bertrand ...
    (microsoft.public.sqlserver.server)
  • Re: ODBC or OLE DB
    ... There is also a managed MySQL Data provider that works very well. ... It is not difficult to write a badly performing OLE DB ... provider that is slower than its ODBC counterpart. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MySQL via OLE DB
    ... I have looked up the help file for other options in the connection string, but it did not work in any way. ... I am using Delphi i2005 Win32 to access a MySQL 5.0.12 Database. ... Some googling pointed me to http://dev.mysql.com/downloads/ but there is no OLE DB provider for use with ADO. ...
    (borland.public.delphi.database.ado)
  • DBPROP_INIT_PROMPT implementation
    ... goto EXIT; ... "Format of the initialization string does not conform to the OLE DB ... It works fine if I pass connection string removing last property, ... OUR provider returns DBPROMPT_NOPROMPT ...
    (microsoft.public.data.oledb)