Query Report on XP and Oracle 9

[JunL]

I'm getting this error: 'ORA-12154: TNS: could not resolve service name' on XP Oracle 9.

I've confirmed that the tnsnames.ora file is correct. Same program with same tnsnames.ora file is working fine on a Windows 8 and Oracle 11g.

I noticed that on the Query Report log on screen, the databases that are listed in the drop down are different from the ones in the tnsnames.ora file.

 

[Marco Kalter]

Could it be that you are using an Oracle10g or earlier client (you mentioned version 9) from a directory with parentheses like C:\Program Files (x86)\...

If so, update to an Oracle11g or 12c client or reinstall Query Reporter in a directory without parentheses. You would be running into Oracle Bug 3807408.

 

[JunL]

I installed Oracle 11g and it fixed the problem. Thank you