I have unixODBC loaded and running (I can run and see DataManager) and I have myODBC for MySQL loaded.

When I use teh DataManager to create a new DSN I have to rproivde the path to the driver (which I do) but it also asks me for a path to a setup library, which is says is usally called the same as the main driver library (for which database you're using) but it ends with an 'S'. I don't see this anywhere.

Has anyone used myODBC with MySQL and unixODBC?

Or should I try to use MySQL++ API?

Thanks in advance...

I know it's been a while since this thread has been created, but I stumbled across the same problem on Ubuntu and found a solution so maybe it can help others.

Contrary to Mandriva with which I'm a little bit more familiar, I couldn't find the MyODBC setup driver in any of the Ubuntu packages. So I went directly to the MyODBC Web site and picked up the latest Linux ODBC connector for MySQL:

http://dev.mysql.com/downloads/connector/odbc

and voilà! The generic .tar.gz Linux file contains all the needed files (both driver and setup), just copy them where you want them and use them with unixODBC. Hope this helps!

Thanks for the info. I did get it sorted out (but it was a long time ago and I can't remember what I did).

But thanks again for the good info.