karakas
Posts: 6
|
| Posted: 12/11/2005, 3:00 PM |
|
Hello,
using the MySQL ODBC Connector version 5.x, I kept on getting the ominous
test connection failed because of provider initialization error
error. Testing the connection in the control panel dialog was saying "test successful", but trying it in CodeCharge was steadily producing the above error.
I gave up on using the 5.x connector for MySQL and resorted to the good old 3.51 one. I had to convert the password for the database to the older format by using
set password for 'XXX'@'YYY' = old_password('ZZZ');
(where XXX is the database user, YYY the database host and ZZZ the password of the database user), but after that the connection worked. Without changing passwords, I would get an error saying that the authentication protocol required by the server is not supported by the client - and this was my primary reason for upgrading the ODBC driver to 5.x (as I said, this did not work, so I had to revert to the older one and change the password format as described).
It seems that there are issues with the new ODBC connector of MySQL and CodeCharge (or at least the routines that CodeCharge uses to connect). Or may be it's just a bug of the connector, because I remember that even though the 5.x version said that the connection was successful, when I clicked in the dropdown list for the database field, I got gargabe characters instead of database names.
I hope all this helps somebody.
_________________
Regards
Chris Karakas
http://www.karakas-online.de |
 |
 |
|
