I installed (with RPM's) MySQL server 4.0.20 on my FC2 along with the MySQL Client and MySQL Administrator and MyODBC. The Adminitsrator lets me sign in, recognizes the sever and I can view my database (the tables and fields). So far, so good.
When I try to add the DB to OpenOffice as a new MySQL daabase, OOo opens the unixODBC dialog box, I press "Organize" (the button that lets you add and define a server), and unixODBC returns an error stating that it can't find the file libodbcinst.so
- or that maybe it's corrupted.
I checked into it, and libodbcinst.so is installed in /usr/lib
as it apparently should be.
I have a similar setup in my WinXP partition, and everything works fine.
What am I doing wrong?