[EMAIL PROTECTED] /]# ls -alh /usr/lib/libmyodbc.so ls: /usr/lib/libmyodbc.so: No such file or directory [EMAIL PROTECTED] /]# find . -name libmyodbc.so [EMAIL PROTECTED] /]#
which unixODBC are you running ? I went here http://at.rpmfind.net/opsys/linux/RPM/redhat.com/dist/linux/9/en/os/i386/unixODBC-2.2.3-6.i386.html and they say the unixodbc package doesnt include linmyodbc.so , it gives
* unixODBC <http://at.rpmfind.net/opsys/linux/RPM/unixODBC.html> * libboundparam.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libboundparam.so.1.html> * libesoobS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libesoobS.so.1.html> * libgtrtst.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libgtrtst.so.1.html> * libnn.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libnn.so.1.html> * libodbc.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbc.so.1.html> * libodbccr.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbccr.so.1.html> * libodbcdrvcfg1S.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcdrvcfg1S.so.1.html> * libodbcdrvcfg2S.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcdrvcfg2S.so.1.html> * libodbcextras.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcextras.so.1.html> * libodbcinst.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcinst.so.1.html> * libodbcminiS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcminiS.so.1.html> * libodbcmyS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcmyS.so.1.html> * libodbcnnS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcnnS.so.1.html> * libodbcpsql.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcpsql.so.1.html> * libodbcpsql.so.2 <http://at.rpmfind.net/opsys/linux/RPM/libodbcpsql.so.2.html> * libodbcpsqlS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbcpsqlS.so.1.html> * libodbctxt.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbctxt.so.1.html> * libodbctxtS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libodbctxtS.so.1.html> * liboplodbcS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/liboplodbcS.so.1.html> * liboraodbcS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/liboraodbcS.so.1.html> * libsapdbS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libsapdbS.so.1.html> * libtdsS.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libtdsS.so.1.html> * libtemplate.so.1 <http://at.rpmfind.net/opsys/linux/RPM/libtemplate.so.1.html>
So is it the same as libodbc.so.1 ?
please give me version or more help , thanks alot
Rigler, Steve wrote:
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
