2. ASPRunnerPro General questions
  3. ODBC driver dialog
This topic is locked

ODBC driver dialog

 		7/29/2005 06:42:49
ASPRunnerPro General questions
J
 Jack author

When I try to configure the ODBC driver dialog as a data source I receive the following message:
"SQL Error State:HY000, Native Error Code:0, ODBC Error: [MySQL][ODBC 3.51 Driver] Could not find driver {MySQL ODBC 3.51 Driver} in system information"
What does this mean?
Thanks,

Jack
P
 		pmhager 7/29/2005

I agree same problem no matter what database type I am using. I have Pradox, Exel etc. installed on my machine why is it asking for ODBC drivers? How do I install them?
Sergey Kornilov admin 7/31/2005

Jack,
this problem happens with some versions of MySQL ODBC driver. Try to create ODBC DSN pointing yo your database and connect using this DSN.
To pmhager:
make sure your system equipped with the following:
Microsoft ADO Version 2.8

Microsoft Jet 4.0 Service Pack 8 (SP8)
500310 10/30/2005

I faced the same problem and solved it by creating the DSN from the ODBC data source manager. Does this mean we cannot create DSN less connections to MySQL?
H
 		hoshantm 10/30/2005

I faced the same problem and solved it by creating the DSN from the ODBC data source manager. Does this mean we cannot create DSN less connections to MySQL?
Sergey Kornilov admin 10/31/2005

Some MySQL ODBC drivers will give you this error. To fix this error you need to install MySQL ODBC driver 3.51.06. Here is the step-by-step guide:

  1. Remove previous MySQL ODBC drivers installation via Control panel->Add remove programs. Make sure that there are no myodbc. files in c:\windows\sustem32 directory (sometimes they are not deleted by uninstall program.
  2. Download and install MySQL ODBC drivers 3.51.06: http://www.asprunner.com/files/MyODBC-3.51.06.exe
    After that you will be able to connect to MySQL database using ODBC driver dialog.