Problem with connection to MySQL


#1

I am running MySQL 5.1.68 with OptoDataLink R9.3b. I am connecting to my database with the Data Source Name with a DSN created using MySQL ODBC 3.51 Driver. When I click on the “Test” button it tells me “Connection Successful!”, but when I actually run the data link, I get the following error: “MySQL: Object reference not set to an instance of an object”

Can anyone let me know if they have a solution to this?

Thanks.


#2

This might be an ODBC driver problem. MySQL’s 3.51 driver isn’t meant to support databases newer than 4.1.1, so I’d suggest upgrading the driver to 5.1.

The tests done in “test connection” are pretty basic queries that don’t rely on sending/receiving any database entries. There’s some overlap between the drivers, so I imagine it’s possible that the tests (checking for existence, basically) could pass, while actual data transfer could fail.