Oracle heterogeneous services using generic connectivity

[jmannix]

We are running Oracle 8.1.7 on a UNIX machine and would like to connect to MS SQL Server 2000 on a MS box. While reviewing Oracle's documentation we can't conclusively determine if we need additional software or not. Again we want to use generic connectivity with Oracle's heterogeneous service. Do we need some sort of separate ODBC driver? Has anyone successfully configured this? Does anyone have a good source for detail instructions?

Thanks in advance!

 

[dbtoo2001]

http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/advcfg.htm#474076

1. On the SQLServer server, Install the Gateway Services from the CD (requires a separate license from Oracle.)
a. Enter the sqlserver server name
b. Enter the sqlserver database
2. Ensure that the listener is setup with the correct named listener and the program name.
Ex. LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1526))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle\ora81)
(PROGRAM = tg4msql)
)
)
3. On the oracle server, Ensure that the tnsnames.ora entry pointing to the gateway is correct and that (HS=OK) is in there! (Heterogeneous Services – gateway.)
Ex.: TG4MSQL.WORLD =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = xxxxx)
(PORT = 1526)
)
(CONNECT_DATA = (SID = tg4msql)
)
(HS=OK))
4. Create a dblink to the gateway using the userid and password for the sqlserver database you are accessing.
5. On sqlserver, grant permissions on the views, tables, etc, to the userid.