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: | |
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
[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.