使用达梦数据库开发需要配置ODBC环境,在这里记录一下配置操作步骤:
1配置需要安装gcc、glibc
yum install -y gcc
yum install -y glibc
2用root账户执行配置
上传文件unixODBC-2.3.0.tar.gz到服务器
解压缩:
[root@kylin-server06 soft]# tar -xvf unixODBC-2.3.0.tar.gz
进入解压生成的目录
[root@kylin-server06 soft]# cd unixODBC-2.3.0/
[root@kylin-server06 unixODBC-2.3.0]# ./configure
[root@kylin-server06 unixODBC-2.3.0]# make
[root@kylin-server06 unixODBC-2.3.0]# make install
make install完成后检查:
[root@kylin-server06 unixODBC-2.3.0]#
[root@kylin-server06 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
3配置文件:
/usr/local/etc/odbcinst.ini
/usr/local/etc/odbc.ini
[root@kylin-server06 unixODBC-2.3.0]# vi /usr/local/etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
DRIVER=/app/dmdbms/bin/libdodbc.so
*此处写当前主机的$DM_HOME/bin目录位置
[root@kylin-server06 unixODBC-2.3.0]# vi /usr/local/etc/odbc.ini
[dm8]
Description = DM ODBC DSND
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD =your_sysdba_password #DM8SYSDBA账户的密码
TCP_PORT = 5236 #DM8实例的监听端口
测试连接
用dmdba 账户
执行isql dm8
[root@kylin-server06 bin]# su - dmdba
Last login: Wed Sep 9 08:57:30 CST 2020 on pts/0
[kylin-server06][dmdba][/home/dmdba]$isql dm8
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
终端打印出上面的画面,就说明ODBC配置成功了。