How To Generate OLEDB Tracing

A data traffic trace can help reveal the communication pattern and details between a client and database server.

ODBC connections are most commonly configured through Windows, which means that the connection can be traced through Windows. For more detais on ODBC tracing, please see How To Generate an ODBC Trace with ODBC Data Source Administrator.

OLE DB based tracing is based on the the database driver provider. The tracing is done differently depending on the database system. Please see below for reference to tracing of most common databases;

Microsoft SQL Server: http://msdn.microsoft.com/en-us/library/ms971550.aspx
Oracle Database: http://www.emigar.com/wiki/index.php/Oracle_client_trace
IBM Database: http://www-01.ibm.com/support/docview.wss?uid=nas8N1013283