odp.net tracing

Question

How can i enable tracing in a odp.net client from the connection string? Just adding the parameters traceFileName, TraceLevel and TraceOption ?

Answer 1

You can't. You'll need a registry or XML fix.

But you can emit ALTER SESSION SET SQL_TRACE=true right after logon, either in your application or in AFTER LOGON trigger.

ODP.NET does exactly the same: it looks into registry and executes this statement.

Answer 2

After some researching, I've found that ODP.net can be configured via web.config olny in version 11 and above. For previos versiones of ODP.Net, the only way is using the windows registry