You have to use the Oracle Transparent Gateway software from Oracle to
connect from Oracle to SQL.

Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Behl Pankaj
[mailto:mssqldba-ezmlmshield-x54488941.[Email address protected]
Sent: Wednesday, June 29, 2005 4:57 PM
To: LazyDBA Discussion
Subject: Connecting from oracle to sqlserver

Can anybody point me to a useful resource for instructions on how to
establish a connection from oracle to sqlserver? I know that mostly
folks prefer to go the other way.

Thanks in advance for any help.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

Confidentiality Note: The information contained in this message, and any
attachments, may contain confidential and/or privileged material. It is intended
solely for the person or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and delete
the material from any computer.


MS Sql Server LazyDBA home page