What is ODBC Logging?

ODBC logging records all HTTP activity to a user-defined database instead of to text files. The dataSource attribute must specify the System Data Source Name (DSN) for the database where the table specified by the tableName attribute is located.

How do I find the server log?

View server logs

In the left pane of the Console, expand Diagnostics and select Log Files.
In the Log Files table, select the radio button next to the server instance log file you want to view.
Click View.
Select the radio button next to the log record you want to view.
Click View.

How do I test ODBC connection?

How to Test ODBC System’s DSN

Click the Windows “Start” button and then click “Control Panel.” Click “System and Security.” Click “Administrative Tools” in the list of utilities.
Click the DSN you want to test.
Click the “Test Connection” button.

How does ODBC logging help in data retrieval?

When you use ODBC logging, your server’s activity is stored in a database, which should greatly improve data retrieval. This expands the possibilities for using a wide variety of database clients when data mining your server’s activity.

Where do I set the logging attribute in ODBC?

Setting the ODBC logging attributes in the element. Specifically, the following attributes must be configured: The dataSource attribute must specify the System Data Source Name (DSN) for the database where the table specified by the tableName attribute is located.

How to configure ODBC logging in IIS?

In the Web Server (IIS) pane, scroll to the Role Services section, and then click Add Role Services. On the Select Role Services page of the Add Role Services Wizard, select ODBC Logging, and then click Next. On the Confirm Installation Selections page, click Install.

Where do I find ODBC logging in Windows 7?

Windows Vista or Windows 7 On the taskbar, click Start, and then click Control Panel. In Control Panel, click Programs and Features, and then click Turn Windows Features on or off. Expand Internet Information Services, then select ODBC Logging, and then click OK.

https://www.youtube.com/watch?v=tUiaK5fRH7k