[prev in list] [next in list] [prev in thread] [next in thread] 

List:       redhat-list
Subject:    Re: MySQL Problem , Please Help
From:       administrator <administrator () integrated-group ! com>
Date:       2003-08-31 11:43:25
[Download RAW message or body]

I cant find /usr/lib/libmyodbc.ini

[root@localhost /]# ls -alh /usr/lib/libmyodbc.so
ls: /usr/lib/libmyodbc.so: No such file or directory
[root@localhost /]# find . -name libmyodbc.so
[root@localhost /]#

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:administrator@integrated-group.com]
>>Sent: Thursday, August 28, 2003 10:48 AM
>>To: redhat-list@redhat.com
>>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 :
>>
>>[root@localhost 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:redhat-list-request@redhat.com?subject=unsubscribe
>>https://www.redhat.com/mailman/listinfo/redhat-list
>>
>>    
>>
>
>
>  
>



-- 
redhat-list mailing list
unsubscribe mailto:redhat-list-request@redhat.com?subject=unsubscribe
https://www.redhat.com/mailman/listinfo/redhat-list
[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic