Re: Desperate plea for Help: failed ODBC requests

Using the ODBC applet in control panel, you will be able to switch on trace on the client side. This will tell you exactly which statements are going to the server and which ODBC calls are being made. You can trace the sqlnet traffic from the client side edit <ORACLE_HOME [ORANT on NT and ORAWIN95 on win95]>\network\admin\sqlnet.ora
make sure the following lines are in the file trace_level_client = 16
trace_unique_client = true
By default this will generate a sqlnet??.trc file, which usually ends up in the <ORACLE_HOME>\bin directory. There is a setting in sqlnet.ora to change the location, from the top of my head I don't remember it.
Good luck,

Sybrand Bakker, Oracle DBA

On Fri, 04 Dec 1998 21:50:05 GMT, dcho_at_mail.arco.com wrote:

>I am in charge of implementing an off-the-shelf ODBC front-end program with
>Oracle as the backend database. The program intermittenly fails to execute
>certain tasks and now I might be sandwiched between two vendors neither of
>whom is willing to take serious responsibility (how typical).
>
>The vendor of the ODBC front-end program claims that the problem is
>environmental and that the server either "drops or ignores the requests due to
>packet failures." And although I haven't apporoached Oracle about it, I doubt
>that they will lift a finger to help me troubleshoot the server's ODBC
>connectivity issues with an obsecure front-end program from an obsecure vendor
>(please email me if you want to know more about the program).
>
>As a starter, I have one question: Does the server maintain a log of ODBC
>requests from clients? If so, where can I find it (Note that I am not an
>Oracle expert, so please be gentle in your response)
>
>I now find myself at the end of the rope. This vendor does not provide
>technical support for Oracle, so they tend to place all blame on the backend
>database whenever elusive problems arise. Your help will be greatly
>appreciate it.
>
>From Very Frustrated
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Sybrand Bakker, Oracle DBA Received on Sat Dec 05 1998 - 07:03:14 CST