配置ODBC驱动

配置ODBC驱动

–1.LINUX环境中配置ODBC,要安装gcc包。

rpm -aq|grep gcc
tar -zxvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0

–2.配置ODBC(root)

./configure --enable-gui=no--3.编译ODBC
make
make install

–4.查看ODBC版本

odbc_config --version
--5.查看ODBC配置文件路径
odbc_config --odbcini
odbcinst -j

–6.配置ODBC.INI

[dm7]
Desription = DM ODBC DSND
Driver = DM7 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236

–7.配置odbcinst.ini

[DM7 ODBC DRIVER]
Description = ODBC DRIVER FOR DM7
DRIVER = /dm7/bin/libdodbc.so

–8.测试ODBC

su - dmdba
isql dm7