oracle如何使用odbc连接dm7

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

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

isql -v DM7   SYSDBA  SYSDBA

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

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)

    )

  )

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

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;