MySQL Bugs: #8637: ADO with MyODBC 3.51.11-1 and MySQL 4.1.10

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

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

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

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.

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.