jump to navigation

Koneksi Oracle ke SQL Server menggunakan Oracles Heterogeneous Services (OHS) October 23, 2008

Posted by masrony in Oracle.
Tags: , ,
5 comments

Step 1
siapkan sistem DSN SQL Server (dengan nama SQLKU) pada Windows ODBC Data Source

Step 2
Buat Heterogeneous Services Initialization File contoh file ada di alamat berikut :
—————-
$ORACLE_HOME/hs/admin/inithsodbc.ora
# This is a sample agent init file that contains the HS parameters that are needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO =
HS_FDS_TRACE_LEVEL =
#
# Environment variables required for the non-Oracle system
#
#set =
diganti menjadi
$ORACLE_HOME/hs/admin/initsqlku.ora
# This is a sample agent init file that contains the HS parameters that are needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = SQLKUDSN
HS_FDS_TRACE_LEVEL = OFF
—————-
(more…)

Advertisements

My New Journey of Life October 5, 2008

Posted by masrony in Life.
Tags: , ,
7 comments