oracle 9.2.0.1.0 link to sqlserver 2000 tables

From: Hubert Mayr <huma1_at_gmx.net>
Date: Fri, 16 Jan 2004 09:52:56 +0100
Message-ID: <1074241553.202769@news.liwest.at>

Hi!

I have a sqlserver 2000 running. I also have a oracle 9.2 server with windows 2003 running.
I installed after oracle enterprise edition setup the oracle gateway services for sqlserver on my oracle server. Then I made some changes in the different oracle *.ora files. Then I restarted the oracle service OracleOraHome92TNSListener.

My question:

is that all I have to do on my oracle server? have I anything to do on my sqlserver 2000?
can my oracle server be at the same time my gateway to sqlserver 2000 or must that be an other computer - sqlserver?

Thanks Received on Fri Jan 16 2004 - 02:52:56 CST