Fog Creek Software
Discussion Board

Tracing ODBC Calls...

.... without going INSANE!

I am working with Oracle 9i (trying to anyway) and I need to trace the ODBC calls from my VFP8 application.

Using the default ODBC tracing mechanism is sssllllllllooooooooowwwwwwwww, so when I am doing it for SQL and VFP databases I just turn it on just before the point at which I need to trace. But Oracle needs to have it turned on from before you make the connection otherwise it doesn't work. The issue is that to login to my app with ODBC tracing turned on takes about 25 minutes.

So I am wondering, does Oracle have a program (or is there a 3rd party program) like the SQL 2000 Profiler application? Or does anybody know if the ODBC SDK 2.0 is still available because I heard that it contains a program called "ODBC Spy"?

By the way, I tried using "Trace Data Viewer" under the "Diagnostics" folder in Oracle, but it said "no trace formatted data available".

Chris Ormerod
Thursday, April 1, 2004

You can trace on the Oracle side. Look for "Oracle SQL trace" in Google.

Friday, April 2, 2004

*  Recent Topics

*  Fog Creek Home