[gentoo-user] ODBC Connection to MySQL database

[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@gentoo.org mailing list

[gentoo-user] Re: ODBC Connection to MySQL and necessary packages

[C. Beamer]

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