I can't seemed to connect to MySQL... I'm getting this error:
Code : 80004005
Error Description : SQLState: S Native Error Code: 1251 [TCX][MyODBC]Client does not support authentication protocol requested by server; consider upgrading MySQL client
it means your host doesn't know what they are doing , send them this link http://dev.mysql.com/doc/refman/5.0/en/old-client.html they either need to upgrade their client or set the database to use old style passwords
I finally got the connection the MySQL db. Turned out that they use DSNless connection and the current DSN connection string on the config file doesn't work either. It's using this (newer?) version of DSNless set up and the string connection looks like this: strConnString = "Driver={Mysql}; Server=localhost; Database=database_name; UID=username; PWD=password" You might want to add that string to the DSNless as one of the connection string for DSNless.
Topic Locked
Posted - 27 October 2006 : 01:16:31
, send them this link 