Re: Some Lateral thinking Required - Hard-Coded instance workaround

Hi John,

My assumption is they are using the OCI driver. If this is the case, then changing the tnsnames file will fix the issue, as it uses the tnanmes file for resolution. If they are using the thin driver, then it won't, as the connection string contains the host:port:sid, not an alias as OCI uses.

How did you do the synonyms? As ugly as this sounds, you should be able to use a database link with a snynoym. If you are connecting to the user in orany1 who owns the tables, you will probably have to drop all of the tables in orany1, create the database link and synonyms to orany2, and you should be OK...and then you should shoot your developers, or at least point them in the direction of JNDI or a simple properties file.

Regards,

Steve Received on Mon Apr 17 2006 - 10:53:41 CDT