MS SQL Server, Linked server

Linked server

Linked server

Author	Message
AVegge #1 / 2	Linked server Is it possible to call an Oracle stored procedure from within a linked server? And if so, can I grab the results and work with it on the SQL Server???
Tue, 09 Dec 2003 05:07:47 GMT

Bill Le #2 / 2	Linked server yes. search BOL for "OLE DB provider for Oracle" or some such. it will tell you how to set up a linked server for Oracle for which you can call remote and distributed queries. hth Quote: > Is it possible to call an Oracle stored procedure from within a linked > server? And if so, can I grab the results and work with it on the SQL > Server???
Tue, 09 Dec 2003 08:34:33 GMT

Page 1 of 1

[ 2 post ]

Relevant Pages

1. Is It Possible: Linked Server to Linked Server?

2. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

3. -Linked Server--Richard Waymire Seminar--Cannot use Integrated Security with Linked Server with SQL7 and Win2k--

4. LINKED SERVERS : How to link MySQL server on SQL Sever 2000

5. Reliable link to Oracle server (linked, server, oracle)

6. How linked are linked servers ?

7. Problem linking to Sybase as linked server

8. urgent: link mysql db as a linked server

9. linked server, DTC, SQLOLEDB, Access, linked tables = HEADACHE!

10. Remote Server -- Changing from Remote Server to Linked Server

11. link server from Oracle to SQL server occurs blocking on SQL server

12. Linked Server - Server: Msg 7399 - It is already opened exclusively by another user

Powered by phpBB® Forum Software