Re: Easy way to distribute a new entry into the TNSNames File..

alison.harrington_at_jfcom.mil (Alley) wrote in news:1c3c61cb.0410150537.4413dd4b_at_posting.google.com:

> I found a posting that said to put a TNSNames file on the network
> where the VB app is with only the New DB entry (JIDB_ORACLE)..
> Ok, But I am not getting how this works.. How does my machine know to
> look there instead of the local TNSNames.. And if I run another app
> that uses the local TNSNames services will it know to look in the
> network one and if it does not find the service name to look in the
> local one??

The oracle client will only know about one tnsnames file or the other but not both. The best thing to do IMO is scrap using tnsnames altogether and switch to a network based solution such as Oracle Names or LDAP and configure your clients to use that. Then you have a single point of administration going forward.  

> I am researching if in my VB connection string I can give it a path
> for the TNSNames file, but I dont remember seeing anything like that..

AFAIK there is no way to do this in Windows. In unix you can set an environment variable called TNS_ADMIN to point to the directory that contains your tnsnames file, and in Windows you can set a registry entry with the same name to do the same thing. But if you change the registry for your program, you change it for all programs.

--
Chuck