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

ODBC driver dialog

 		7/29/2005 6:42:49 AM
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?
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?
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.