1。安装unixODBC
下载unixODBC,编译并安装
2。配置 odbcins.ini
vim /etc/odbcinst.ini
[DM]
Description=DM ODBC
Driver=/home/dmdba/dmdbms/bin/libdodbc.so
/home/dmdba/dmdbms/是达梦数据库的安装路径
3。配置odbc.ini测试
vim /etc/odbc.ini
[dm]
Description=DM
DRIVER=DM
SERVER=127.0.0.1
DATABASE=DATA
UID=USER
PWD=123456
TCP_PORT=5236
DRIVER=DM是odbcinst.ini中的[DM](ODBC连接时的驱动名称)
4。c++连接字符串
sprintf(connstr, "DRIVER=%s;SERVER=%s;UID=%s;PWD=%s;TCP_PORT=%d;DATABASE=%s"
, szdriver, szhost, szuser, szpwd, nport, szname);
5。测试
6。环境变量
达梦的环境变量需要加上/usr/lib64,否则会cannot open /home/dmdba/dmdbms/bin/libdodbc.so
vim /etc/profile
export LD_LIBRARY_PATH=/usr/lib64:/home/dmdba/dmdbms/bin:$LD_LIBRARY_PATH