Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Connect from sqlplus on Unix to SQL Server On Nt

Re: Connect from sqlplus on Unix to SQL Server On Nt

From: <cdoganay_at_my-deja.com>
Date: 2000/04/27
Message-ID: <8ea8bf$pic$1@nnrp1.deja.com>#1/1

Thanks for the reply. Is there any ODBC driver for UNIX?

Thanks..
In article <39083624.C7C8EB3_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> I'm no expert on SQL Server. But I doubt that you can do what you are
> asking. When you define a service name in TNSNAMES, then you are
> defining the characteristics to connect from an Oracle product to an
> Oracle database. This connection goes through Oracle's SQL*Net or Net8
> network substrate. So I doubt (but I could be wrong) that you can use
> SQL*Net or Net8 to connect to SQL Server. You can do this through ODBC
> though.
>
> HTH,
> Brian
>
> cdoganay_at_my-deja.com wrote:
> >
> > Hi, what are the ways to retrieve data (Some tables) from a
 Microsoft
> > SQL Server on NT to an Oracle Server Running on Unix. Can I define
 sql
> > Net aliases to SQL Server?
> >
> > Thanks for your kind help in advance..
> >
> > Cemal
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Apr 27 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US