This content has been marked as final. Show 4 replies
Whats the error message you are getting
It could be due to version compatibility i am not very sure
In the ODBC are you mentioning the right TNSNAMES.ora
the TNS service tab is populated with the value of tnsnames.ora from the default Oracle Home ..IF you have 2 oracle home make sure that you have entries in both the tnsnames.ora file
Are you having the entry for target database in tnsnames.ora under ORACLEXE?
It seems to be a matter of which folder appears first in the PATH. Since you have recently installed Oracle XE, it is very much possible that ORACLEXE folder is appearing first in the path and being used by your application.
Thanks for the advice, frankly your advice did work well.
What I did was went to the Oracle8i's TNSNAMES.ORA and copied entries which I need and then pasted it into OracleXe's tnsnames.ora file (manually need to replace/add certain words). Finally things began to work well...
Thanks Again all...
Edited by: Hifni Shahzard on Sep 24, 2008 1:03 PM