Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Connect from sqlplus on Unix to SQL Server On Nt
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