The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

odbc sql logging

we use odbc connectivity to our database

i want to profile what is going on and do some optimisations
i was wondering if anyone knows of an odbc proxy or something that would log the sql being sent to the database and perhaps a timestamp for the results

or if there are other alternatives for sybase sql anywhere

thanks

alex
bumperbox
Thursday, June 19, 2008
 
 
Unless I'm misunderstanding your request, it's been in windows since at least Windows 95.

I'm on an XP machine:

Control Panel | Data Sources (ODBC)
ODBC Data Source Administrator | Tracing Tab

"Start Tracing Now"
Sgt.Sausage
Friday, June 20, 2008
 
 
Hi,

It has been ages since I did some ODBC work on Windows. You will find that there's an option to log the ODBC calls in the subsystem itself.

On windows 2008/2003/XP: Go into ODBC Data Source and select the tracing tab and voila you have ODBC calls logged to a file.

Regards

Ajay
Ajay Soni Send private email
Friday, June 20, 2008
 
 
that was too easy
and all my searching on google never found it

thanks guys

alex
bumperbox
Friday, June 20, 2008
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz