ORA-12154

[jar1966]

I have an program that access an Oracle 8i database using DOA 3.4. It works fine when run at a client machine but if we try to run it from the server (W2000) it stops with the following error message:

ORA-12154 TNS: Could not resolve service name

Is there any limitation with DOA that prevents this application from running directly in the server? We tried other tools from the server and they connect fine (TOAD, etc). Does anybody has any ideas?

Thanks,
jar1966

 

[rmussman]

Did you install the ORACLE Net8 drivers on the server? or update the TNSnames.ora file on the server?

 

[jar1966]

Yes, I did. Actually, I found the problem. In my application I was getting the connect string from an *.ini file located in the same directory where the program was launched from. For some reason, in W2000 the code to determine the current directory did not work but it did work in W95/98. By replacing my code with the procedure GETCURDIR, it now works correctly and reads the ini file.

Thanks,
jar1966

 

[Nelson Ng]

Hi,

I've similar problem but I don't use ini file.
If I used TNSPing/sqlplus, it works fine.

Please help.

Regards,
Nelson.

 

[Marco Kalter]

Make sure that the tnsnames.ora from your Primary (!) Oracle Home is setup correctly.

If SQL*Plus works correctly and your Direct Oracle Access application causes an ORA-12154, then you have either misspelled the LogonDatabase, or SQL*Plus is running from a different Oracle Home than your application.

------------------
Marco Kalter
Allround Automations