Re: ODBC NT server client takes 30 minutes to connect o Oracle 7.3.2 server when on isolated network???
Date: Mon, 18 Jun 2001 11:11:31 +0200
Message-ID: <9gkgkp$sp9$1_at_ctb-nnrp2.saix.net>
"Marky Mark" <DontSpamMe_at_Nospam.org> wrote
> With their hub OFF the network, it takes an ungodly amounts
> of time to make an initial ODBC connection from the NT4 stand
> alone server to the Oracle database. 25-30 minutes.
Shooting in the dark.. maybe the networking is attempting to DNS resolves on the IP's to obtain the hostnames? With the hub no longer on the network, the DNS resolve will fail.. after taking a long time to time out. And as I recall, these calls are blocking ones. So it means that the complete process grinds to a halt while waiting for the DNS resolve to complete (and timeout).
BTW, if this setup works WITH the hub on the network and does not when hub is NOT on the network, it is very unlikely that Oracle or ODBC itself is to blame. Instead, all 5 fingers seem to point to a network config problem to me.
regards,
Billy
Received on Mon Jun 18 2001 - 11:11:31 CEST