Re: ODBC Connection errors op laptop
Date: Sun, 03 Feb 2002 04:08:31 GMT
Message-ID: <3J278.9316$Ri2.26766_at_rwcrnsc54>
"Andy" <avc4u_at_hotmail.com> wrote in message
news:afe07366.0201230329.6e3100c5_at_posting.google.com...
> christianboivin1_at_hotmail.com (Chris) wrote in message
news:<da20daf0.0201221308.5b0b7e06_at_posting.google.com>...
> > If i understand correctly what you mean ... ,
> > is if you disconnect from the lan
> > you can't connect to the db,
> > hummmm ... normal if your DB is on the lan.
> >
> > hth
> > Chris
> More precise: the server itself located on the laptop.
>
> Andy
Yep - I've seen it before, especially in the case where the laptop is in a
docking station; multiple NICs and multiple IP addresses. I'm guessing your
loopback connection is using an IP assigned to the NIC in the docking
station, or possibly when you unplug from the LAN, your NIC goes offline and
you can't connect.
Try setting environment ORACLE_SID={your SID} and don't use a connect
string. If you must connect via the listener, set another TNS alias for
local connect to use 127.0.0.1 (shooting from weak memory here - test it
out).
Received on Sun Feb 03 2002 - 05:08:31 CET