Re: SQL*NET

From: SUVAS LAKSHMIKUTTYAMMA <lsuvas_at_worldnet.att.net>
Date: 1997/12/09
Message-ID: <66in2s$4b0@bgtnsc02.worldnet.att.net>#1/1

CS <chagood_at_geocities.com> wrote in article <01bcffa0$d82e6260$829790cc_at_carla>...
> 1) What API interfaces exist to SQL Server from a remote NT platform
> machine? What does SQL*Net buy you?

         SQL*Net ,I believe is used for Oracle Database connections only.I dont think
it will support any other RDBMS.There are other Oracle products for that.

> 2) Will it work to use SQL*Net and an ODBC interface from a remote NT
> workstation and access an SQL Server database?

                            See answer to (1)                              



> 3)	What communications mechanisms does SQL*Net support?  Can you direct

 it
> to use shared memory orTCP/IP sockets to interact? Are there any
> differences in the interface if running the same task on the local
 machine
> vs. on a remote machine?

                  It supports a varied variety of network protocols
including.
                  You can  selectively install particular protocol
adapters(eg: TCP/IP adapters) 
                  There is no difference in local/remote connections though
performance might
                   vary


> 4)	Is there a C interface to SQL*Net that allows insert and update calls

 to
> use binary values for fields? From a remote machine?
> In Oracle, yes.You have to use OCI (Oracle call
 interface) for that.
>
>
> Hope this helps.
Received on Tue Dec 09 1997 - 00:00:00 CST