[gentoo-user] ODBC Connection to MySQL database

[C. Beamer]

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@g.o mailing list