This is on a windows 2003 server if that makes a difference.
I'm connecting to a mysql db using
And in phpmyadmin it tells me that old_passwords is set to on.Code:Set conn = Server.CreateObject("ADODB.Connection") conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"_ & "SERVER=localhost;"_ & " DATABASE=tssc;"_ & "UID=****;PWD=****; OPTION=3" conn.Open
But I get the error -
[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client
I've spent ages trying to find what causes this, and the only cause I can find is the old_passwords variable, but thats set correctly?


LinkBack URL
About LinkBacks
Reply With Quote


