MyODBC fails when trying to add a DSN to MySQL
I am running Mandrake 9.1. I installed MySQL Server 4.1.9 successfully and can access it via MySQLCC, create databases, populate tables, run queries, etc. I then installed the MySQL ODBC driver, MyODBC, and got the following error during the installation:
[root@gateway /]# rpm -i /home/neil/Download/MyODBC-3.51.10-1.i586.rpm
[myodbcinst.c][INFO] Driver registered. Usage count is 1. Location "/etc"
[myodbcinst.c][ERROR] Could not load driver setup library (/usr/lib/libmyodbc3S.so). Error is /usr/lib/libmyodbc3S.so: undefined symbol: _ZNK9QCheckBox9hitButtonERK6QPoint
The driver does show up in ODBC manager (gODBCConfig) as 'MySQL ODBC 3.51 Driver', with the driver's location as /usr/lib/libmyodbc3.so and the setup location as /usr/lib/libmyodbc3S.so. If I add an ODBC connection to MySQL as a System DSN it appears correctly in the ODBC manager, but when I try to configure the connection to point to a database I get the error "Could not construct a property list for (MySQL)". (I also have PostgreSQL installed and its driver installs correctly and can be configured without error.)
I have installed MyODBC from the Mandrake disks, encountered the error, uninstalled, downloaded the MySQL ODBC driver from a different location, reinstalled and gotten the same error. The named file indeed exists in that location. Is there a specific issue with Mandrake 9.1, some dependency I overlooked, or did I do something mindnumbingly stupid when I set up either MySQL or MyODBC?