Error connecting to MySQL DB

[msimanga]

Hi,

I am attempting to connect to a database on MySQL. I have downloaded the driver, placed the .jar file in my extension and in WEB-INF/lib folder.

Funnily enough yesterday the same servlet ran efficiently and caused no. Today the error below

Error.java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

[dfarnham]

Your problem sounds like an environment configuration issue.

Your error output indicates that your application is attempting to use Microsoft's ODBC driver to connect to MySQL, which will always fail like this.

Your application needs to be configured to bind to the MySQL driver, using MySQL-specific database connection strings information.

BTW, kudos on you choice of database engine.

Hope this helps.


Damon