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;"
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;"