Hi,
I need to link an Access DB on one server to a MySQL DB on another one (running under Fedora Core 4). I figured that the ODBC Connector provided by MySQL (http://dev.mysql.com/downloads/connector/odbc/5.1.html) could be a good solution... Am I right?
So, if I understood well, I need to install it on the server running MySQL. I'm following the installation instructions here :
http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-installation-binary-unix.html#connector-odbc-installation-binary-unix-tarball.
So, I download the rpm and I run "rpm -ivh mysql-connector-odbc-5.1.5-0.i386.rpm ". But I get this error :
error: Dependencies required:
libodbc.so.1 is necessary for mysql-connector-odbc-5.1.5-0.i386
libodbcinst.so.1 is necessary for mysql-connector-odbc-5.1.5-0.i386
I figured that odbc wasn't installed, but libodbc.so.1 was already present in /usr/local/lib/. To be sure, I created a link in /lib/ and /usr/lib/ with ln -s, but it doesn't change anything.
If I run updatedb libodbc.so.1 and then slocate libodbc.so.1, I get this :
/lib/libodbc.so.1
/usr/lib/libodbc.so.1
/usr/local/lib/libodbc.so.1.0.0
/usr/local/lib/libodbc.so.1
So the library is present but it looks like it isn't detected... Any idea?
Thank you.
Valentin