达梦ODBC安装
ODBC 的安装:
解压安装包:
tar -xvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0
执行configure
./configure
make
make install
编辑配置文件odbc.ini、odbcinst.ini
文件位置:/usr/local/etc/
内容如下:
[root@localhost etc]# cat odbc.ini
[DM8]
Description = DM ODBC DSN
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = 123456789
TCP_PORT = 5236
[root@localhost etc]# cat odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /home/dmdba/dmdbms/bin/libdodbc.so
[root@localhost etc]#
验证:
使用可以连接dm数据库的用户验证,一般未dmdba
[root@localhost etc]# su - dmdba
上一次登录:一 12月 28 23:13:11 CST 2020pts/1 上
[dmdba@localhost ~]$ isql dm8(dm8为cat odbc.ini配置文件中首行的节点名称:[DM8])
±--------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
±--------------------------------------+
SQL>
ORACLE ODBC安装
1)解压unixodbc源码
tar -zxvf unixODBC-2.3.2.tar.gz
2)进入unixodbc源码目录,编译源码
cd unixodbc-2.3.2
export CC=gcc
./configure --enable-drivers=no --with-iconv-char-enc=GB18030 --enable-gui=no --enable-iconv=yes
make
make install
当服务器系统为UNIX/LINUX 64bits时,在./configure之前需执行
export CFLAGS=“-maix64 -DBUILD_REAL_64_BIT_MODE”
export OBJECT_MODE=64
3)配置UNIXODBC
将操作系统当前目录切换到“/usr/local/etc”目录,修改 odbc.ini 和odbcinst.ini 参数。
odbc.ini 参数内容如下所示:
[ORACLE]
Description = ORACLE ODBC DSN
Driver = Oracle in OraDb11g_home1
SERVER = 127.0.0.1
UserID=dmhs
Password=123456
Servername = ORCL
PORT = 1521
odbcinst.ini参数内容如下所示:
[Oracle in OraDb11g_home1]
Description = ODBC DRIVER FOR ORACLE
Driver =/u01/app/oracle/product/11.2.0.4/db_1/lib/libsqora.so.11.1
Threading = 0
https://eco.dameng.com