[达梦数据库]达梦数据库通过ODBC访问ORACLE

1 环境介绍

ip	端口	数据库版本	操作系统
192.168.1.11	5236	DM8	LINUX RH6
192.168.1.12	1521	Oracle	LINUX RH6

2 安装unixodbc

[root@DM8 ~]# yum install -y unixODBC unixODBC-devel

[root@DM8 ~]# rpm -qa | grep ODBC
unixODBC-devel-2.2.14-12.el6_3.x86_64
unixODBC-2.2.14-12.el6_3.x86_64

3 查看unixODBC

[root@DM8 ~]# odbcinst -j
unixODBC 2.2.14
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

4 下载安装rpm软件包

oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-odbc-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm
包下载地址：http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

rpm –ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
rpm –ivh oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
rpm –ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

#5 配置odbc.ini

[ORACLE]
Description = ORACLE ODBC DSN
Driver = /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
Database = orcl
ServerName = 192.168.1.12:1521/orcl
UserName = SYSTEM
Password = ORACLE
Port = 1521

6 连接测试

[root@DM8 lib]# isql ORACLE SYSTEM ORACLE -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+

7 创建链接

create link orcl_odbc connect 'ODBC' with "SYSTEM" identified by "ORACLE" using 'ORACLE';