ODBC for MYSQL not working?

[tonten]

I've been trying to test out my asp script, however, I keep getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client

/index.asp, line 169


I turned ODBC on in my control panel and configured a DSN. I'm using Classic ASP and I am attempting to connect to a third party MYSQL server. Here is my script:

____________________________________________________


'Create ADO objects
Dim objCon, rsUser

'Open connection to mysql db
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.CursorLocation = 3
objCon.Open = "Driver={MySQL ODBC 3.51 Driver};Server=99.999.999.99;Option=3306;Stmt=SET NAMES 'utf8';Database=musicland;UID=UID;PWD=PWD;"

 

[tonten]

Well I figured out the problem with help from jodohosts support (who were really helpful and great)

I'm using sql 5.0 for my database and jodohosts is still using the 4.0 versions. The mySQL ODBC connector they have is not compatible with version 5 mysql.

There is a workaround where you use an set old password fix to try and make mysql 5.0 compatible with an old ODBC connector. However, after doing that there will still be alot of different errors/statements that needs to be changed.