Using ODBC tracing information to troubleshoot connections to Microsoft SQL Server data sources

If you experience problems connecting to the data source, you can obtain ODBC tracing information to analyze and resolve the problems.

Symptom

However, activating a trace does impact system performance. You should turn off tracing after you have resolved the connectivity problems.

If you are unable to connect to the data source with the Microsoft^® SQL Server wrapper, running a trace might help you diagnose the problem

Cause

The cause of the problem might be an error in the wrapper configuration.

Diagnosing the problem

To diagnose the problem on a federated server running Windows^®:

1. Click start à SettingsàControl Panel             

2.     In the Control Panel, open the Administrative Tools folder.

3.     Click Data Sources (ODBC) to open the ODBC Data Source Administrator window

4.     Click the Tracing tab

5.     Click Start Tracing Now to start the trace utility

Resolving the problem

Check the trace log file for problems.
On Windows, open the ODBC Data Source Administrator and click the Tracing tab. The path to the trace log file is shown in the Log File Path field.