Home » RDBMS Server » Networking and Gateways » Link between Oracle and SQL server (ORACLE, Windows)
Link between Oracle and SQL server [message #403430] Fri, 15 May 2009 09:55 Go to next message
Messages: 133
Registered: May 2008
Senior Member


I was supposed to create a database link between oracle and SQL server. The steps i followed to create a link are as follows,

1. Setup the ODBC connection on the local Oracle database using the Windows ODBC Data Source Administrator

2. Test the ODBC drivers to ensure that connectivity is made to the SQL Server database.

3. Ensure that your global_names parameter is set to False.


(HS = OK)

5. After this listener has to be changed.

I don't what i have to add in LISTENER.ORA FILE for this TEST sid.

Already we have one listener named LISTENER running in the server. We have 4 databases in the server.

Please share your thoughts.


Re: Link between Oracle and SQL server [message #403435 is a reply to message #403430] Fri, 15 May 2009 10:22 Go to previous message
Messages: 24273
Registered: January 2009
Senior Member

[Updated on: Fri, 15 May 2009 10:28]

Report message to a moderator

Previous Topic: TNS-12618: TNS:versions are incompatible
Next Topic: Connection error
Goto Forum:

Current Time: Sat Nov 28 09:20:44 CST 2015

Total time taken to generate the page: 0.11033 seconds