Capturing TDS

From SQLBWiki

Right click on a server and choose "Set as Capture Server" allows to consider the SQLBrowser process as a pseudo SQL Server which will carry forward each request to the server set up as the "Capture Server". To use the capture feature you need to follow these steps:

• On the client that you which to capture, create a ini entry or an ODBC entry pointing to the host where sqlbrowser runs, default port is 8723 (see preferences). e.g.:

 [SQLBROWSER]
 master=NLWNSCK,PORTABLE,8723
 query=NLWNSCK,PORTABLE,8723

• Launch SQLBrowser and define the capture server through the contextual menu of the server nodes
• Connect to this server. (don't worry about the user name, the gateway will use the original login name used in the client, however, a connection to the server is needed)
• Launch the client by connecting to the SQLBrowser datasource
• The "Capture Window" should show. If this window is closed, you can open it in the Window menu
• The capture traces are saved in temporary files in the output directory. Clicking on the file name opens the file in the Notepad