说明:测试环境下探索配置,并不能保证配置规范和绝对有效性。
另,转载请注明出处。
1、操作系统安装rpm包 (相关包上传或镜像挂载不做说明)
rpm -ivh unixODBC-2.3.1-11.el7.x86_64.rpm
rpm -ivh unixODBC-devel-2.3.1-11.el7.x86_64.rpm
核实
[dmdba@localhost ~]$ odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /home/dmdba/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
2、编辑驱动配置文件
su - root
cd /etc/
vi odbcinst.ini
追加如下
[DM8 ODBC DRIVER]
Description= ODBC DRIVER FOR DM8
Driver = /dm8/bin/libdodbc.so
3、设置DSN连接字符串dm
su - root
vi /etc/odbc.ini
[dm]
Description= DM ODBC DSN
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = oracledameng
TCP_PORT = 5236
4、连接测试
su -dmdba
idql dm
[dmdba@localhost ~]$ isql dm
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
谢谢