PRB: SQLConfigDatasource Allows PageTimeout Value of 0

ID: Q238752

The information in this article applies to:

Microsoft Open Database Connectivity, versions 3.0, 3.5, 3.51, 3.6, 3.7
Microsoft ODBC Driver for Access, versions 3.0, 3.5, 3.6, 4.0

SYMPTOMS

The ODBC API call, SQLConfigDataSource(), provides the application developer a means to programmatically create a Datasource Name (DSN) for the ODBC "Microsoft Access Driver (*.mdb)." The SQLConfigDataSource() function can create a registry entry for PageTimeout that allows the value of 0. When the DSN is created in this manner and is reviewed in the ODBC Administrator, the following error message is displayed when the <OK> button is clicked:

ODBC Microsoft Access Setup - Invalid page timeout value.

CAUSE

A PageTimeout value of 0 or less is not valid for this driver property.

RESOLUTION

Ensure that the PageTimeout value is set to something greater than 0 when using the SQLConfigDataSource() function in the ODBC API.

STATUS

This behavior is by design.

Additional query words: SQLConfigDataSource PageTimeOut

Keywords : kbODBC odbcAccess kbGrpMDAC kbGrpODBC
Version : WINDOWS:3.0,3.5,3.51,3.6,3.7,4.0
Platform : WINDOWS
Issue type : kbprb