Re: Any experience of SLIP/PPP SQL*NET connections ?

In article <3p0iib$oqn_at_sirio.cineca.it>, Eric Dolce <dlcao3k1_at_bologna.nettuno.it> wrote:
>In article <3nr89r$61d_at_mn5.swip.net>, michael.astrom_at_mailbox.swipnet.se
>says...
>>
>>Has anybody any experience of connecting Client's with SQL*NET TCP/IP
>>through SLIP/PPP(modem) connections, I've heard that it should be a
>>bulletin on this around (Hard to find).

You simply need the SQL*Net drivers for TCP/IP and then instead of loading you particular TCP/IP protocol stack load the PPP drivers instead. When running PPP, your SQL*Net driver will think it's sitting on top of TCP/IP. That's really all there is to it.

Which ever vendor's PPP, TCP/IP drivers you use, your SQL*Net drivers should match.

Hope this helps.

BTW: It does work, albeit quite slow. Watch the result set size returned by your SQL queries to keep them relatively small and you should be alright.

Mike

-- 
Michael P. Sullivan                                           PP-ASMEL/IA
Distributed Technology Associates, Ltd.                    Skylane N52792
E-Mail: msullivan_at_ACM.org  or  mps_at_panix.com          Phone: 800-395-7090
  * UNIX Systems and Database Consulting, Architecture and Management *