Hi, I have further info to that listed below.
As stated below, I followed the same instructions to set this up in Gentoo as I did in Fedora Core. However, this morning, I was doing a google search to see if I could find more information. The document that I followed has had a revision and now to create an ODBC connection to a MySQL database, you need 2 things: 1) MyODBC, which I have installed, and 2) MySQL-shared The documentation that this was taken from was using an rpm based system for the example, and ergo, the MySQL-shared referenced was an rpm package. I've tried googling for 'mysql-shared and gentoo', but I can't figure out what Gentoo package this might refer to. Does anyone know? Regards, Colleen C. Beamer wrote: >Hello all, > >I am trying to set up an ODBC connection to a MySQL database. I have >done this before when I used Fedora Core, but when I tried to do it >today on my Gentoo system, I got an error message when I tested the >connection. > >I have both UnixODBC and myodbc installed. > >The instructions that I previously followed to set this up in Fedora >were as follows: > >create 2 files - odbcinst.ini and odbc.ini These files were supposed to >be in /etc. In Fedora Core, there were templates to use, but I had to >completely create the files in Gentoo. > >In the odbcinst.ini file, the line for the driver when I did this in >Fedora Core was: >Driver = /usr/lib/libmyodbc.so > >In Gentoo, there is no libmyodbc.so. There is, however, a libmyodbc3.so >which is a symlink to libmyodbc3-3.51.11.so > >Therefore, I used /usr/lib/libmyodbc3.so as the driver. > >In the odbc.ini file, the proper name of the database was listed. > >After creating the odbcinst.ini and odbc.ini files,, I ran 'isql >MySQL-home home' which was supposed to test the connectivity to the >database and I got the error [ISQL]ERROR: Could not SQLConnect > >When I did a google search for the error message, I came across a >post where it was asked what the output of isql -v was. I ran >this on my system and got the following message: > >[IM010][unixODBC][Driver Manager]Data source name too long > >I've posted to the UnixODBC support list, but my reason for posting here >is to ask if anyone knows whether the instructions that I used to set >this up should have been done differently in Gentoo. And for what it's >worth, although the database was created when I used Fedora Core and >then, copied into the appropriate place in Gentoo, the database works >fine when I use it from within MySQL. > >Regards, > >Colleen > > > -- gentoo-user@gentoo.org mailing list