img kingsky23

Accessing SapDB via unixODBC

发表于2004/9/29 11:19:00  867人阅读

分类: linux

Accessing SapDB via unixODBC

Setup the unixODBC working:
  1. Deinstall/Remove the RPM File via rpm, due the SuSE RPMs are somewhat buggy for SuSE 8.0 and less. The 8.1 distribution is not tested by mine. I suggest to use the unixODBC 2.2.3. You will have to configure (./configure --prefix=/usr --sysconfdir=/etc) worked for me in SuSE 7.x, 8.0 and Debian 3.0/woody for my tests.
    Within the SuSE Version there is the nessessary "Setup" Library already included.
  2. Now you need a /etc/odbcinst.ini File:
    This is a sample, working /etc/odbcinst.ini:
    Description     = SapDB
    Driver          = /usr/sapdb/depend/lib/libsqlod.so
    Setup           = /usr/lib/libsapdbS.so.1.0.0
    FileUsage       = 1
    CPTimeout       =
    CPReuse         =
    You may create this using the "ODBCconfig" tool from the unixODBC Package.
  3. In general you need the Setup-Driver File for the SapDB. Have a look onto this screenshot:
  4. SapDB has got some difficulties with the Linux FSSTD2.
    There is recommended to have an ancient /usr/spool.
    Create this with a link to /var/spool like that:
    1. cd /usr
    2. ln -s /var/spool
  5. This is a sample /etc/odbc.ini:
    Description     = SapDB
    Driver          = SapDB
    ServerNode      = datbase.server.org
    ServerDB        = DATABASE
  6. You will have to link /etc/odbc.ini into the /usr/spool/sql/ini dir.
    1. cd /usr/spool/sql/ini
    2. ln -s /etc/odbc.ini .
0 0


取 消