What is the Tracing tab for?
This tab specifies how the ODBC Driver Manager traces calls to ODBC functions. Tracing is performed by a trace DLL that captures calls between the Driver Manager and either the application or the driver, and then records them in a log file. The Driver Manager can:
• Trace calls continuously or for one connection only
• Perform tracing dynamically
• Allow tracing to be performed by a custom trace .dll file
The table below describes the controls on the Tracing tab.
Start Tracing Now/Stop Tracing Now (toggle)
Enables continuous dynamic tracing, whether or not a connection has been made, as long as the ODBC Data Source Administrator dialog box is displayed or until you click Stop Tracing Now.
Start Visual Studio Analyzer/Stop Visual Studio Analyzer (toggle)
Enables Visual Studio Analyzer, which remains enabled until you click Stop Visual Studio Analyzer. Visual Studio Analyzer is a tool that you can use for debugging and analyzing a distributed application. For more information about Visual Studio Analyzer, go to the MSDN Library on the Microsoft website.
Log File Path
Displays the path and file name where the tracing information will be stored. Use the default path and file name (\sql.log) or specify a new one.
Browse
Lets you select the path and file name for the log file by browsing folders.
Custom Trace DLL
Lets you select a .dll file other than Odbctrac.dll to perform tracing. Enter the path and file name of the custom .dll file, or click Select DLL to browse folders. The Odbctrac.dll file that is shipped with the Microsoft Data Access Components (MDAC) software development kit (SDK) can be replaced with a custom .dll file of your choice.
Select DLL
Lets you browse the folder structure for a custom trace .dll file. The path and file name of the chosen .dll file will appear in the Custom Trace DLL text box.
OK
Accepts changes to the Log file path and Custom Trace DLL settings and closes the ODBC Data Source Administrator dialog box.
Cancel
Closes the ODBC Data Source Administrator dialog box without accepting changes to settings.
Apply
Accepts changes to tracing settings and leaves the ODBC Data Source Administrator dialog box open.
Help
Displays this Help topic.