DM8 ODBC

DM8 ODBC

unixODBC-2.3.0.tar.gz
tar -zxvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0/
./configure
make
make install
安装完后，odbcinst –j 来查看安装位置等信息,如:
[root@n1781 unixODBC-2.3.0]# odbcinst -j
unixODBC 2.3.0
DRIVERS…: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES…: /usr/local/etc/ODBCDataSources
USER DATA SOURCES…: /root/.odbc.ini
SQLULEN Size…: 8
SQLLEN Size…: 8
SQLSETPOSIROW Size.: 8
vi /usr/local/etc/odbcinst.ini
配置 odbcinst.ini，作用就是注册DM7的ODBC驱动,该驱动名称为DM8，内容如下：

[DM8]
Description = dm odbc
Driver = /home/dmdba/dmdbms/bin/libdodbc.so

vi /usr/local/etc/odbc.ini
配置 odbc.ini，作用就是创建系统DSN，名称为dm，调用名为DM7的ODBC驱动，内容如下：
[dm8]
Description = dm8
Driver = DM8
SERVER =127.0.0.1
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236

[ISQL]ERROR: Could not SQLConnect

[root@n1781 unixODBC-2.3.0]# isql -v dm8
[01000][unixODBC][Driver Manager]Can’t open lib ‘/home/dmdba/dmdbms/bin/libdodbc.so’ : file not found
[ISQL]ERROR: Could not SQLConnect

ldd /home/dmdba/dmdbms/bin/libdodbc.so

export LD_LIBRARY_PATH="$L{D}_{L}IBRAR{Y}_{P}ATH:/home/dmdba/dmdbms/bin"exportD{M}_{H}OME="/home/dmdba/dmdbms"exportPATH=$PATH:$D{M}_{H}OME/bin:$DM_HOME/tool