Oracle ODBC connectivity - Explain how to trace ODBC calls. posted by
Babu Kunwar
Explain how to trace ODBC calls.
As I have configured this on the UNIX machine I don’t have any idea about
Windows. Here are the details of tracing the ODBC call on UNIX platform:
On Unix/Linux, you can turn on the ODBC trace by adding the following to
odbcinst.ini
[ODBC]
Trace=1
TraceFile=<pathname>/odbctrace.out
TraceDll=<Your_ODBC_Driver_Manager_lib_path>/odbctrac.so
InstallDir=<Your_ODBC_Driver_Manager_path>
Important NOTE:
-
That pathname must be an existing path with write permission by the user who
will start the ODBC application.
-
You must specify InstallDir when you are using ODBC driver manager for ODBC
trace.
More links
Types of users - a local user, an external user, or a global user
Explain how to create users through Sql Plus.
How to delete an Oracle applications user?............
|
