can I change TNSNAMES.ORA and not reboot

From: Shawn Lee <shawnlee_at_cris.com>
Date: 1997/10/07
Message-ID: <01bcd329$2fbd8280$2cb0bacd@shawnlees730>#1/1

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