Toad World® Forums

Missing MySQL ODBC driver error

I am attempting to join 2 Toad Intelligence Central tables with an excel (97-2003 version) spreadsheet in a query. The query opens with no issues, but when I try to execute it, I encounter the following error: “Missing MySQL ODBC Driver: To execute a Cross-Query that uses a Toad Intelligence Central connection you will need to install a MySQL ODBC Driver on this client.”

I am able to execute the same query on the TIC server, so it doesn’t appear to be an issue with the TIC server.

When I look at the ODBC Data Source Administrator on my desktop (where the query fails), the drivers tab shows 2 MySQL drivers: MySQL ODBC 5.3 ANSI Driver and MySQL ODBC 5.3 Unicode Driver. I tried uninstalling the MySQL drivers and installing the latest MySQL drivers with the same error.

I have run this query before (a month or so ago) on my desktop with no issues. I am currently using TDP 4.0.0.396 and TIC 3.1.0.22 with no recent upgrades.

Any ideas?

I believe this should be asked in the Toad Intelligence Central forum located here:

http://www.toadworld.com/products/toad-intelligence-central/f/111

Thanks,
Eric Sheridan

I placed a copy on the TIC forum. How do I remove this one?