My sql server is residing on a local network and i need to access an oracle server on a remote server. This remote server is on a different network but can be connected using telnet. So how do i go about doing this? Is there any books that i can refer to? Thanks.

-- Anonymous, January 19, 2000

Answers

Gilbert,

First, I have to admit that I don't have a remote Oracle server to try this on, but I think you will specify the IP address and port number (make sure the port is open) in the "Data Source" field of the "Linked Server Properties - New Linked Server" dialog box. You get to this dialog box from the SQL 7.0 Enterprise Manager by right clicking the Linked Servers icon under the Security folder and selecting "New Linked Server...".

Hope this helps,

Eric

-- Anonymous, January 19, 2000