I have oracle client 9i, and 10g installed on my system
I am trying to connect to oracle 8i using SQLPlus on 9i. It works fine. I know that oracle 10g client does not support 8i database. Hence I use 9i client to connect to 8i server
When I try connect to oracle 8i server from outside applications (for eg mapguide's mapauthor) it always sees oracle 10g's home and tries to find out all tns names in its tnsnames.ora i.e. 10g's tnsnames.ora. Hence it cannot find tnsnames defined to connect to version 8?
How can I make all applications outside oracle to use oracle 9i as client and not 10g as default client?