Shulou(Shulou.com)05/31 Report--

Editor to share with you how oracle uses odbc to connect to dm7. I hope you will get something after reading this article. Let's discuss it together.

1. Install unixODBC-2.3.0 in oracle server to create dm data source 1.1

Upload the package to the server and run the following command:

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 configure 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 Test that the oracle server can connect to dm data sources

Isql-v DM7 SYSDBA SYSDBA

2 configure 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 configuration static snooping

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 configure tnsnames.ora for Oracle

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 create dblink and test

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

After reading this article, I believe you have a certain understanding of "how oracle uses odbc to connect dm7". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.