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

Hi,

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.

4. TNSNAMES is

test= (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)
(HOST=localhost)
(PORT=1521)
)
(CONNECT_DATA = (SERVICE_NAME=TEST)
)
(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.

Seenu.


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
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.lmgtfy.com/?q=oracle+dblink+sqlserver

[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: Thu Mar 28 04:35:49 CDT 2024