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