oracle如何使用odbc连接dm7

小编给大家分享一下oracle如何使用odbc连接dm7，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！

1        在oracle服务器创建dm的数据源

1.1   先安装unixODBC-2.3.0

  上传软件包到服务器，运行以下命令：

tar zxf   unixODBC-2.3.0.tar.gz

cd   unixODBC-2.3.0

./configure  --with-iconv-char-enc=GB18030  --enable-iconv=yes

make &&   make install

1.2   配置unixODBC

cd   /usr/local/etc

vim odbc.ini

[DM7]

Description   = DM ODBC DSN

Driver       = DM7 ODBC DRIVER

SERVER      = 192.168.1.33

UID         = SYSDBA

PWD        = SYSDBA

TCP_PORT   = 5236

vim  odbcinst.ini

[DM7 ODBC   DRIVER]

Description   = ODBC DRIVER FOR DM7

Driver        = /dmdbms/bin/libdodbc.so

threading     = 0

1.3   测试oracle服务器能连接dm数据源

isql -v DM7   SYSDBA  SYSDBA

2        配置HS

file   $ORACLE_HOME/bin/dg4odbc

ELF 64-bit LSB   executable, x86-64

cd  /oracle/app/oracle/product/11.2.0/hs/admin

vim initDM7.ora

HS_FDS_CONNECT_INFO   = DM7

HS_FDS_TRACE_LEVEL   = debug

set   ODBCINI=/usr/local/etc/odbc.ini

HS_FDS_SHAREABLE_NAME   = /usr/local/lib/libodbc.so

3        oracle配置静态监听

cd   $ORACLE_HOME/network/admin

vim   listener.ora

SID_LIST_LISTENER   =

   (SID_LIST =

       (SID_DESC =

      (SID_NAME = DM7)

(ORACLE_HOME =   /oracle/app/oracle/product/11.2.0)

      (PROGRAM = dg4odbc)

    )

  )

4        配置Oracle的tnsnames.ora

vim   tnsnames.ora

DM7 =

  (DESCRIPTION =

    (ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST =   127.0.0.1)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = DM7)

    )

    (HS=OK)

  )

lsnrctl status

5        创建dblink和测试

sqlplus   "/as sysdba"

SQL> create public database link    dmlink  connect to   "SYSDBA" identified by SYSDBA using DM7;

SQL> select   name,status$ from v$instance@dmlink;

看完了这篇文章，相信你对“oracle如何使用odbc连接dm7”有了一定的了解，如果想了解更多相关知识，欢迎关注行业资讯频道，感谢各位的阅读！