Re: Querying an SQL Server database from Oracle 7

From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/08/17
Message-ID: <4v3371$hio_at_client2.news.psi.net>#1/1


In article <4v1sir$l78_at_msunews.cl.msu.edu>,

   az1400_at_esalsun10.ent.msu.edu (Amos H. Ziegler) wrote:
>Greetings:
>
> I am in the process of trying to determine if it is possible to
>connect an SQL Server database and an Orcale 7 via SQL-Net. I need to be
>able to query an SQL Server database from an Oracle installation. Does
>anyone know if this is possible.

yes, you can use an ODBC driver. Oracle supplies a set which includes sqlserver adapters. the sqlnet connect string looks like user/pass_at_odbc:service

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.
Received on Sat Aug 17 1996 - 00:00:00 CEST

Original text of this message