odbc库的使用

 

linux平台配置odbc连接dm7达梦数据库

 tar -zxvf unixODBC-2.3.0.tar.gz

cd unixODBC-2.3.0

 ./configure

make 

make install

 

其中configure的默认选项如下
#./configure --prefix=/usr/local/unixODBC-2.3.1 --includedir=/usr/include --libdir=/usr/lib -bindir=/usr/bin --sysconfdir=/etc

 

odbcinst -j
unixODBC 2.3.0
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/aerotop/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

  

编辑下面两个 配置文件

vim /etc/odbc.ini
[dm]
Description = DM ODBC DSN
Driver = DM7 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = dameng123
TCP_PORT = 5236

 

vim /etc/odbcinst.ini
[DM7 ODBC DRIVER]
Description = ODBC DRIVER FOR DM7
Driver = /dm7/bin/libdodbc.so

 

配置环境变量

export ODBCSYSINI="/home/mitch"
export ODBCINSTINI=".odbcinst.ini"
export ODBCINI="/home/mitch/.odbc.ini"


查看连接dm，-v可以查看详细信息
isql -v dm

 

找不到库的问题

isql -v dm
[01000][unixODBC][Driver Manager]Can't open lib '/dm7/bin/libdodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

 

echo $DM_HOME

source ~/.bash_profile

ldd /dm7/bin/libdodbc.so

没有libodbcinst.so的问题

isql -v dm
error in load libodbcinst.so!!: 没有那个文件或目录
段错误 (核心已转储)

cp /data/home/aerotop/unixODBC-2.3.0/odbcinst/.libs/libodbcinst.so /dm7/bin/