Bug #8637 ADO with MyODBC 3.51.11-1 and MySQL 4.1.10
Submitted: 21 Feb 2005 8:30 Modified: 22 Feb 2005 1:40
Reporter: JUNG Guillaume Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51.11-1 OS:Windows (Windows 2000)
Assigned to: CPU Architecture:Any

[21 Feb 2005 8:30] JUNG Guillaume
Description:
MyODBC works when connecting with Access to the MySQL 4.1.10 database but not with a dsn connection on my IIS webserver. Is the MySQL 4.1 not fully supported ?

How to repeat:
Code :
DSN = "Driver={MySQL ODBC 3.51 Driver}; Server=x.x.x.x; Database=test; Uid=toto; Pwd=totopass; Option=35"

set conn = server.CreateObject("ADODB.Connection")
conn.open DSN_Login

Error :
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
/web_dc/scripts/prefered.asp, line 78
[22 Feb 2005 1:40] Jorge del Conde
I was unable to reproduce this bug:

On error resume next

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=test; Uid=root; Option=35"

if err = 0 then
Response.Write "Database test Successfull!1!"
else
Response.Write "Database test Failed!!"
Response.Write "<BR> Error Number: " & err.Number
Response.Write "<BR> Error Source: " & err.Source
Response.Write "<BR> Error Description: " & err.Description
end if 

Conn.Close
[22 Feb 2005 8:57] JUNG Guillaume
I use the new password format of MySQL 4.1.1. The MySQL server is not on the same machine as the webserver.

I copyed your code and reproduced the error.

Database test Failed!!
Error Number: -2147467259
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client

I install and reinstall MDAC 2.8 and MyODBC 3.51.11-1.
[12 Aug 2006 4:50] Ajay Pal
Hi please use following string.

strConnect = "Driver={MySQL}; Server=*.*.*.*; Database=toto; User=userid; Password=password;"

Make changes on UID TO USER AND PWD TO PASSWORD.

I hope it will work.