达梦数据库 ODBC 配置

1、检查gcc 包

rpm -aq|grep gcc
-----------------------------------------------------------
[root@localhost tmp]# rpm -aq|grep gcc
libgcc-7.3.0-20190804.35.p02.ky10.x86_64
gcc-7.3.0-20190804.35.p02.ky10.x86_64
-----------------------------------------------------------

2、解压安装包

tar -xzvf unixODBC-2.3.0.tar.gz

3、配置ODBC

cd unixODBC-2.3.0
./configure --enable-gui=no

4、编译安装ODBC

make && make install

5、查看odbc 版本

odbc_config --version

6、查看odbc 配置文件路径

odbcinst -j
-----------------------------------------------------------
[root@localhost 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
-----------------------------------------------------------

7、配置odbc.ini 和odbcinst.ini

cat > /usr/local/etc/odbc.ini << EOF
[dm8]
Description = DM ODBC DSND
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5237
EOF

cat > /usr/local/etc/odbcinst.ini << EOF
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /dm8/bin/libdodbc.so
EOF

8、测试连接(切换 dmdba 用户)

isql dm8
select * from v$database;
-----------------------------------------------------------
[dmdba@localhost bak]$ isql dm8
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from v$database;
-----------------------------------------------------------

---