I've been forced by my ISP to moved from an MS Access database to MySQL. The ISP ported my Access db to MySQL on their server. I've been trying to set it up for my use on localhost. I have the database created and working in MySQL Workbench. I created a MySQL ODBC dsn that tests good in Microsoft ODBC Administrator.
Initially, I renamed my Access dsn and applied the original name to the MySQL dsn. When I hit a script with a query, I got: "Specified driver could not be loaded due to system error 182"
Then I thought to open CF Administrator to check the datasource there. I deleted the record for the (working) MS Access dsn and created one for MySQL. CF Admin indicates that my "data source updated successfully." I'm using the MySQL (4/5) driver. However, when I open a script with a query, I get the error in my debugger: "Could not create connection to database server. Attempted reconnect 3 times. Giving up."
Any thoughts on how I make this DSN work for my application on localhost?
I had to ask the question, in hopes that I could engage someone more knowledgeable who could help me get up and running. In the meantime, I solved the problem. by removing the username and password parameters in my query scripts. I was initially confused that the script debugger was referring to a user I had not associated with the database. Then I remembered I had used that user name in my scripts.
Everything is now working fine. I hope this may help someone else who gets into a sticky wicket of authentication.