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

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!
========================================