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: can I change TNSNAMES.ORA and not reboot

Re: can I change TNSNAMES.ORA and not reboot

From: theone <theone_at_thecompany.com>
Date: 1997/10/07
Message-ID: <01bcd32c$a89833a0$4b02280a@host.telepac.pt>#1/1

> Please copy responses to my email.
> Thanks,

Please do not...

So others my learn from everybody problems...

-- 
------------------------------------------
        theone
ps: no tengo email
------------------------------------------


Shawn Lee <shawnlee_at_cris.com> escreveu no artigo
<01bcd329$2fbd8280$2cb0bacd_at_shawnlees730>...

> VB4, Access95, SQL*NET, Oracle 7.3, Oracle ODBC
>
> We use attached tables in an access jet .mdb to hit the oracle db. We
want
> to be able to switch which oracle dB we are hitting from the VB4 client
(to
> switch between development and production). I thought we could just
change
> the IP address in the TNSNAMES.ORA for the connect string that we built
our
> attached tables with, but the switch doesn't happen until the next time
the
> client is rebooted if he has already accessed one of the attached tables.

> Is SQLNet/oracle ODBC caching the contents of the TNSNAMES.ORA? Is there
a
> way to flush it? Other suggestions?
>
> Please copy responses to my email.
> Thanks,
> --
> Shawn
> --
> shawnlee_at_cris.com
> http://www.cris.com/~shawnlee/ Borg Pursuit Screen Saver for Windoz
>
>
>
Received on Tue Oct 07 1997 - 00:00:00 CDT

Original text of this message

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