ODBC is a very popular database access mechanism though it is considered old compared to others such as OLEDB, etc. Data Direct (Progress) has released a light weight version of snoop some time back. It allows us to connect to local port on your computer for logging ODBC activity. You need to run snoop tool as a command line for redirecting from local port connection to host where a database is running.
Shown below is an illustration for connecting to a database (Oracle as an example) from my laptop with local port of 9999 (you may use other available port on your laptop instead).
Steps:
1) Download snoop from Data Direct. Choose a local port and a local directory where log files can be written to.
2) Create a ODBC DSN and run the snoop command as given below:
java Snoop 10.5.XY.ABC 1521 -snoopport 9999 -traceFilePrefix c:\temp\snoop.log
3) You will notice corresponding logs depending on your database activity through ODBC connection.
Tech dat! 