Debugging an Oracle connection

Giganews Newsgroups
Subject: Debugging an Oracle connection
Posted by:  Marian_Aldenhövel
Date: Mon, 31 Oct 2005


Is there a way to log what information Oracle client components are passed
when a connection-attempt is made?

The background to this question is that I am building an application in
Borland Delphi 5 using ODAC as access components. I can connect at designtime
but at runtime the program gives me an ORA-12154 error. "TNS: could not
resolve    service name". But the information used _should_ be the same as when
I connect at designtime and it is accepted then.

So I would like to check from the other end to verify what my application
is trying to do.

Oracle is 9.2 on Windows.

Ciao, MM