Re: Connect to MySQL 4.1 via ADO (ODBC)

Guillem írta:
Bolla Sándor wrote:

Hi there, does anybody successfully connected to MySQL4.1.x with ADO
in D2005. I tried it more than ones, but after setting successfully
in the User DSN (test OK), in the Delphi IDE I get the error: (I
don't know exactly in English) 'Catastrophe error', maybe

Solution?

thx
Alex

Bolla and Graham,

I would suggest to check following:

- that the ADO version is the last one. IIRC it should be v2.8 SP1. You
can get an utility to check it from

http://msdn.microsoft.com/data/mdac/downloads/default.aspx


- In case you are developing/deploying on XP, there was an issue in
case of installing the Windows XP SP2 package. More info at

http://www.macropool.com/en/download/mdac_xp_sp2.html


- if you use ODBC, make sure that the MyODBC version is the last one.
You can get it from

http://dev.mysql.com/downloads/connector/odbc/3.51.html


- Also check the connection string. It can easily become a source of
problems if not well configured. More info at

http://www.connectionstrings.com/
http://dev.mysql.com/doc/refman/5.0/en/connection-parameters.html


Btw, in case you use ADO+ODBC I would also suggest to consider the
possibility of use some native access components since they will be
faster than the combination of 2 layers as ADO and ODBC. Jerry already
suggested a good one. Besides, ODBC is no longer developed by Microsoft
and already deprecated, and remains only for compatibility purposes.

Good luck to both
Thanks for the answer.

I will look for them, meanwhile the Problem is solved using only the User DSN without extra connection string.

Bye Alex
.

Relevant Pages

  • Re: ODBC
    ... You can use a connection string via SQLSTRINGCONNECT. ... Can I create an ODBC (user DSN and system DNS) from within my VFP8 ... FireBird database and some to SQL Server and some to Access. ...
    (microsoft.public.fox.vfp.forms)
  • Re: Refresh data from Remote View
    ... Can I use ADO with a connection string to Oracle, instead of ODBC and if so is the connection string all I would have to modify in my application? ... Since Vfp8 you can use the Cursor Adapter class to do so but that would mean even more redesign than parameterizing the existing views. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Which is the fastest database technology?
    ... > If you use ADO and ODBC it doesn't have to be SQL Server specific. ... > can set the connection string on first run and manage everything from ... Until the day you use some SQL that is specific to SQL Server dialect, ...
    (borland.public.delphi.non-technical)
  • Re: ODBC connection error 3151, Windows 7
    ... version of the ODBC Panel; ... Second, if you are creating an User DSN, try creating a System DSN instead. ... I'm using SQL server express 2008 as my server. ... When I'm trying to run the application, I'm getting ODBC connection error ...
    (microsoft.public.access.adp.sqlserver)
  • Link to ODBC source with different DSN names
    ... We all have the same ODBC driver that points to the same ... I may have a User DSN named CLI01 while my coworker might ... queries run fine. ... that points to the correct location? ...
    (microsoft.public.access.externaldata)