Connect to Oracle stored procedure from SQL Server stored procedure...and vice versa.

I have a requirement to execute an Oracle procedure from within an SQL Server procedure and vice versa.

How do I do that? Articles, code samples, etc?

Oops, the actual requirement is just to query Oracle tables from SQL Server and to query SQL Server tables from Oracle.

Setting up a linked server in SQL Server accomplishes the first and is well documented in Books Online.

The second involves using Oracle Heterogenous Services or Transparent Gateway. I have not found very good documentation about how to use those.

Configuring Active Directory as a Linked Server.

Hi, in a server running sql server 2000 sp3, as a new requirement for an
application. They need to have the active Directory configured as a
Linked Server.
Do somebody know the pros and cons of configuring this.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***Hi,
its their SQL Server ,SQL server can be integrated with Active Directory ,
please read *Active Directory* in BOL.
here are some articles FYI :
msdn.microsoft.com/library/en-us/architec/8_ar_cs_1gku.asp
msdn.microsoft.com/.../adsi/adsi/ creating_a_heterogeneous_join_between_sq
l_s
erver_and_active_directory.asp
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"MariaGuzman" wrote:

> Hi, in a server running sql server 2000 sp3, as a new requirement for an
> application. They need to have the active Directory configured as a
> Linked Server.
> Do somebody know the pros and cons of configuring this.
> Thanks a lot for your help.
> *** Sent via Developersdex http://www.codecomments.com ***
>