2. ASPRunner.NET General questions
  3. [SOLVED]  1st timer - ODBC connect error
This topic is locked
[SOLVED]

 1st timer - ODBC connect error

 		9/17/2006 5:40:49 PM
ASPRunner.NET General questions
B
 bcridgway author

I open ASPRunner.NET, select ODBC driver from the Datasource type dialog, select the MySQL ODBC 3.51 Driver from the Available Drivers list, then I get this error:
SQL Error State:HY000, native error code: 0, ODBC Error: [MYSQL][ODBC 3.51 Driver] Could not find drive {MySQL ODBC 3.51 Driver} in system information.
Anyone have any ideas on this error? Thanks
Eugene 9/18/2006

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 MySQl ODBC driver dialog..
B
 		bcridgway author 9/18/2006

Thanks, that worked! But, now I have another error when I enter the MYSQL connection parameters I get the following error:
Client does not support authentication protocol requested by server; consider upgrading MySQL client

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 MySQl ODBC driver dialog..
Admin 9/18/2006

One more step:
To fix this problem you need to run the following in MySQL command line:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;
More info on this:

http://dev.mysql.com/doc/mysql/en/old-client.html
B
 		bcridgway author 9/19/2006

Thanks...how do I open a MySQL command prompt?

----------

One more step:

To fix this problem you need to run the following in MySQL command line:
mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host = 'some_host' AND User = 'some_user';

mysql> FLUSH PRIVILEGES;
More info on this:

http://dev.mysql.com/doc/mysql/en/old-client.html
Admin 9/19/2006

On your local box you need to proceed to Command Promt and run mysql command there.
If you need to fix this on the remote web server use phpMyAdmin to run SQL commands.
B
 		bcridgway author 9/19/2006

I appreciate your help...now I got this error:
'Access denied for user 'root'@'localhost' (using password: YES)'

On your local box you need to proceed to Command Promt and run mysql command there.

If you need to fix this on the remote web server use phpMyAdmin to run SQL commands.


Neermind [duh] .... it works! ThAnk you!

I appreciate your help...now I got this error:

'Access denied for user 'root'@'localhost' (using password: YES)'