Re: SQL Net question...

Vijay Damodaran wrote:
>
> I have a database application running on a server in
> subnet A in Dallas. Can a person in subnet B in England
> access the database via SQL*Net?
>
> We have developed an application using Developer 2000 which
> must be deployed at both sites. We have the following
> options:
>
> 1. Deploy the GUI on client machines in England
> which will access the database in Dallas via
> SQL*Net. Is this possible?
>
> 2. Create a similar database server in England and
> have enable replication between the 2 databases.
> But, somebody in England says that do replication
> is 6 times more costly (I do not know what she
> means by this - money or time or n/w traffic). Is
> this true?
>
> We feel that using option 1 would make the application very
> slow. But the costs may make option 2 prohibitive.
>
> any input would be greatly appreciated.
>
> Thanks,
>
> VJ.
>
> --
> Vijay Damodaran
> vijayd_at_nortel.com
> Work: (972) 685-8150

Vijay,

This isn't a SQL*Net issue, rather a TCP/IP issue. The SQL*Net V2 Protocol Adapter conducts a dialog via an API with the underlying protocol stack with a complete isolation of functionality between the two layers.

If you can obtain and maintain TCP/IP connectivity, SQL*Net will work.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.