Delphi 7 & Oracle XE giving ORA 12154

[CalvinR]

I cannot connect at all to my OracleXE instance running on my pc from in delphi 7 using DOA. I can only connect to non-local databases.

I can connect to the DB using SQLPlus, as well as SQL Developer.

This is the only machine that is currently having this problem other dev boxes can connect no problem.

 

[Marco Kalter]

Is your Direct Oracle Access application using the same Oracle Home as the SQL*Plus instance that can connect to your local database?

 

[CalvinR]

How do I specify my oracle home in my DOA application?

This is a legacy system that i've been given control off and so I'm new to DOA.

 

[Marco Kalter]

After receiving the ORA-12154 exception you can add the following call:

ShowDOAInfo(nil);

This will show the Oracle Home information. Please check if this corresponds to the SQL*Plus environment you used previously.