Need Help with SQL 7 Distributed Queries

Thread View: att.database.research

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Swangers Sat, 13 Feb 1999 00:00

Author: Swangers
Date: Sat, 13 Feb 1999 00:00

7 lines
983 bytes

I need to run a query in SQL 7 that will get some data from the SQL database
and some from the Oracle. I know I need the server_name.
catalog_name.Schema_name.Object_name in a select statement to do it . How do
I find out the Oracle schema name if I don't know it?  Also do I have to
link the SQL server to it self and use a four part name for the SQL server
also? Thanks to anyone who can help. Sue
swang@nb.net

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads