As a disclaimer, I've never used ODBC with MySQL on RH, but I
stepped through what you described and, with some adjustments,
was able to successfully attach to a database with "isql".

First:
/usr/lib/libmyodbc.so is on my system and came with the MyODBC
package.

my /etc/odbcinst.ini was already set up and looked like this:

[myodbc]
Description     = MySQL Driver
Driver  = /usr/lib/libmyodbc.so
Setup           = /usr/lib/libmyodbcmyS.so.1
FileUsage       = 1
CPTimeout       =
CPReuse =

I set up an entry in my /etc/odbc.ini (which I later realized
that "isql" wasn't using, so I copied /etc/odbc.ini to ~/.odbc.ini)
that looks like (using the "menagerie" example database):

[menagerie]
Description     = menagerie
Driver  = myodbc (this is how it was labeled in /etc/odbcinst.ini)
Server  = localhost
Database        = menagerie
Port            = 3306
Socket  =
Option  =
Stmt            =

This config worked for me.

-Steve

> -----Original Message-----
> From: administrator [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 28, 2003 10:48 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL Problem , Please Help
> 
> 
> Hello
> I wanna use ODBC with MySQL over Redhat 9 , So i was following the
> OpenOffice.org 1.0, ODBC, and MySQL 'How-to'
> http://pbs.linux.net.pl/ksiazki/OOoMySQL.pdf
> 
> 
> As They stated , I should Add these Entries to
> /etc/odbcinst.ini
> Using The GUI utility ODBCconfig
> 
> But i didnt find
> 
> Driver         = /usr/lib.libmyodbc.so
> or
> Setup        = /usr/lib/libodbcmyS.so
> 
> Instead i used :
> Driver          = /usr/local/lib/libmyodbc3.so
> Setup           = /usr/lib/libodbcmyS.so.1
> 
> So My /etc/odbcinst.ini :
> 
> [MySQL]
> Description     = ODBC driver for MySQL
> Driver          = /usr/local/lib/libmyodbc3.so
> Setup           = /usr/lib/libodbcmyS.so.1
> FileUsage       = 1
> CPTimeout       =
> CPReuse         =
> 
> And then There is /etc/odbc.ini
> 
> [IGSohba]
> Description             = IgSohba
> Driver                  = MySQL
> Server                  = localhost
> Database                = igsohba
> Port                    = 3306
> Socket                  =
> Option                  =
> Stmt                    =
> 
> * When i was adding from the GUI tool , the DB entry is a 
> drop down menu 
> , and there was test and mysql , but not my
> DB i created which is igsohba , but i added it manually anyway .
> 
> 
> it is also mentioned that to test this :
> 
> [EMAIL PROTECTED] root]# isql IGSohba
> Segmentation fault
> 
> So my questions are :
> 1) Are the libs i added in /etc/odbcinst.ini correct .
> 
> 2) is there a missing package .
> 
> 3) where did i go wrong ?
> 
> Thanks In advance .
> good day
> 
> 
> -- 
> redhat-list mailing list
> unsubscribe mailto:[EMAIL PROTECTED]
> https://www.redhat.com/mailman/listinfo/redhat-list
> 


-- 
redhat-list mailing list
unsubscribe mailto:[EMAIL PROTECTED]
https://www.redhat.com/mailman/listinfo/redhat-list

Reply via email to