我的 达梦 odbc 配置

root用户登录

cd /opt
tar zxf unixODBC-2.3.0.tar.gz

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

make && make install
时间比较长，3分钟

odbc_config --version


[root@bjdb ~]# 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

[root@bjdb ~]# cat /usr/local/etc/odbc.ini
[dm9]
driver= DM8 ODBC DRIVER
server=localhost
uid=SYSDBA
pwd=SYSDBA
tcp_port=5236

[root@bjdb ~]# cat /usr/local/etc/odbcinst.ini
[DM8 ODBC DRIVER]
DRIVER=/home/dmdba/dmdbms/bin/libdodbc.so

[root@bjdb ~]# su - dmdba
Last login: Mon Sep 19 07:17:14 PDT 2022 on pts/1

[dmdba@bjdb ~]$ isql dm9
+---------------------------------------+
| |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select instance_name,host_name from v$instance;
+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+
| INSTANCE_NAME | HOST_NAME |
+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+
| DM8 | bjdb |
+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 1
1 rows fetched
SQL> quit;

必须quit