Re: SQLNet , ODBC, and PPP......yes or no?

From: Jeff T. Richard <jrichard_at_accescomm.net>
Date: 1997/03/21
Message-ID: <01bc361a$ec9b94c0$366abdcc@tlspdc.egainc.com>#1/1

I have used ODBC and SQL*Net Client (16-bit version) over a PPP connection (W95 into WNT Server via RAS). The tool I was using was Crystal Report v5.0 to build reports. The only issue I see is that the correct WINS or DNS name servers had to be defined for the specific PPP connection.

Jeff.

-- 
Jeff T. Richard
E. Gilbert Associates, Inc.
713-666-0202
JRICHARD_at_ACCESSCOMM.NET


RYoung <ryoung_at_summer.dbsol.com> wrote in article
<01bc35ab$fc8cd8e0$6a428ad0_at_pc060.groupZ.net>...


> Has anyone tried using Access with ODBC &  Oracle SQLNet TCP/IP  over

 PPP?


> When I try it I get a connect failure. Yet if I use normal 'Oracle' tools

> (SQLPlus and similar) over SQLNET TCP/IP with  PPP w/out ODBC I can get

> across fine. 

> 

> Access --> ODBC-->SQLNet TCP/IP--> PPP--> remote Oracle database (FAILS)

> Oracle tools-->SQLNet TCP/IP-->PPP-->remote Oracle database (SUCCESS)

> 

> Is there a time out parameter that can be set in the registry that has an

> affect, or does ODBC just not work over the PPP connection?

> -- 

> Robert Young

> rcyoung_at_summer.dbsol.com

> "Standard disclaimer for employee views..."

>

Received on Fri Mar 21 1997 - 00:00:00 CST