dcsimg

How do I verify connectivity of the ODBC driver?

Products

Webtrends Analytics 8.x
Webtrends Analytics 9.x

Cause

You want to confirm the ODBC driver has proper connectivity.

Resolution

Follow the steps below to verify connectivity using the ODBC driver.

1. Open Fiddler. Fiddler is available as a free download from the following URL:

http://fiddlertool.com/

2. Ensure “Act as system proxy on startup” is checked under Tools > Fiddler Options…

3. At a command prompt, force winhttp (used by the ODBC driver) to use the same settings as wininet by typing the following:

proxycfg -u

Now watch the communications between the client machine and the Webtrends server. This works if you’re using the ODBC driver in Webtrends On Demand as well. To troubleshoot the data passed between the machines, make sure the ODBC driver is temporarily not using SSL. SSL is a default setting for Webtrends On Demand, and while it’s always better to have SSL enabled, until the issue has been resolved SSL should not be re-enabled.