Microsoft KB Archive/931202

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


The requirements for using the ODBC logging feature in Internet Information Services

Article ID: 931202

Article Last Modified on 2/22/2007



APPLIES TO

  • Microsoft Internet Information Services 7.0
  • Microsoft Internet Information Services 6.0
  • Microsoft Internet Information Services 5.1
  • Microsoft Internet Information Services 5.0
  • Microsoft Internet Information Server 4.0



INTRODUCTION

This article describes some of the requirements for using the Open Database Connectivity (ODBC) logging feature in Microsoft Internet Information Services (IIS).

MORE INFORMATION

In IIS, you can use the ODBC logging feature to log data in a local Microsoft Office Access database or in a remote Microsoft SQL Server database.

You can use the SQL Native Client ODBC driver to connect to a local SQL Server 2005 database or to a remote SQL Server 2005 database. However, when you use the ODBC logging feature in IIS and create a system data source name (DSN) by using the SQL Native Client ODBC driver, IIS may not insert all the data in the table. This issue occurs because the SQL Native Client ODBC driver is incompatible with IIS.

Microsoft does not support configuring the ODBC logging feature in IIS by using the SQL Native Client ODBC driver. You must use the SQL Server ODBC driver instead.

REFERENCES

For more information about how to configure the ODBC logging feature in IIS, click the following article number to view the article in the Microsoft Knowledge Base:

245243 How to configure ODBC logging in IIS


Keywords: kbhowto kbexpertiseinter kbinfo KB931202