Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problems with SQL*NET over WAN. Advice needed!

Re: Problems with SQL*NET over WAN. Advice needed!

From: Darryl Snover <dsnover_at_fast.net>
Date: 1998/09/03
Message-ID: <dsnover-0309982111580001@darryl.dsnover.fast.net>#1/1

One thing you might want to check is the type of WAN connection. I had a similar experience when using an ISDN Wan connection, and it ultimatly turned out to be the ISDN firmware needed updating.

In article <6sggql$1av$1_at_nnrp1.dejanews.com>, andy_dixon_at_my-dejanews.com wrote:

> We are using SQL*NET 2.3.3.0.0 to connect across our WAN to an Oracle 7
> database. We are using RDO 2.0 in VB5.
>
> The problem is that the VB program simply hangs after the first query has
> returned data. I have tried Oracle ODBC driver 2.0.3.1.1 and Microsoft ODBC
> for Oracle driver 2.73.735600 and the symptoms are identical.
>
> Because the problem occurs with both drivers, I am beginning to suspect
> SQL*NET. Are there any known problems with this over WANs? I got it working
> fine when connected via a LAN. Are there any tricks I need to employ in VB?
>
> I need to use RDO and not Oracle Objects as we need asynchronous connections
> (due to delays over WAN), and so that the software is not tied to one
> database server type.
>
> If anyone can help I would be forever in your debt!
>
> Cheers,
>
> Andrew Dixon
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Sep 03 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US