Home » RDBMS Server » Networking and Gateways » Heterogeneous Connectivity Issues
Heterogeneous Connectivity Issues [message #231476] Tue, 17 April 2007 04:18 Go to next message
Messages: 25
Registered: March 2005
Location: Pakistan
Junior Member

i want to make a connection from oracle to sql server.
i have changes inithsodbc.ora file and also add a listener in listener.ora file and tnsname in tnsnames.ora file.
from command prompt i start the listener.its working, then i ping the tns ,its also working fine, then i create a database link...
but when i query a table from sql server its give me the following error:

ERROR at line 1:
ORA-02068: following severe error from TEST
ORA-03135: connection lost contact

can anybody resolve my issue. oracle and sql server r on different machines, machines r connected through netwrok...
Re: Heterogeneous Connectivity Issues [message #231526 is a reply to message #231476] Tue, 17 April 2007 07:16 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Check the timeout parameters in sqlnet.ora.
Previous Topic: TNS-12560 and ORA-01041
Next Topic: Remote Access of Database through live IP by using DSL.
Goto Forum:

Current Time: Sun Jul 23 20:00:43 CDT 2017

Total time taken to generate the page: 0.06345 seconds