Need Help with SQL 7 Distributed Queries

Article View: att.database.research

Article #9

Back to att.database.research Previous Next

From: 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

Technical Details

Message-ID: <EClx2.1164$_B2.27870@newsfeed.slurp.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 113ba7,3244bb26063e6f38,start
X-Google-Attributes: gid113ba7,public
From: "Swangers" <swang@nb.net>
Subject: Need Help with SQL 7 Distributed Queries
Date: 1999/02/13
Message-ID: <EClx2.1164$_B2.27870@newsfeed.slurp.net>
X-Deja-AN: 444071078
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Trace: newsfeed.slurp.net 918939172 209.161.72.243 (Sat, 13 Feb 1999 14:52:52 CDT)
Organization: Swangers Inc.
NNTP-Posting-Date: Sat, 13 Feb 1999 14:52:52 CDT
Newsgroups: att.database.research