PRB: SQLConfigDatasource Allows PageTimeout Value of 0 (238752)

MORE INFORMATION

Steps to Reproduce Problem

1. Use the following code to create a DSN that has a PageTimeout value of 0:
   
   Note You must change uid=<username> and pwd=<strong password> to the correct values before you run this code. Make sure that uid has the appropriate permissions to perform this operation on the database.

   #include <windows.h>
   #include <odbcinst.h>
   #include <stdio.h>
   
   int main(int argc, char* argv[])
   {
   	BOOL	rc;
   	char szDriver[] = "Microsoft Access Driver (*.mdb)\0\0";
   		rc = SQLConfigDataSource( NULL, 
   								  ODBC_ADD_DSN, 
   								  szDriver, 
   								  (LPCSTR)"DSN=TestDSN\0" 
   									"DBQ=C:\\db1.mdb\0" 
   									"DRIVER=C:\\WINNT\\System32\\odbcjt32.dll\0" 
   									"DRIVERID=25\0" 
   									"PAGETIMEOUT=0\0" 
   									"FIL=MS Access\0"
   									"THREADS=3\0"
   									"DESCRIPTION=Testing Driver\0" 
   									"UID=<username>\0"
   									"PWD=<strong password>\0"
   									"IMPLICITCOMMITSYNC=Yes\0"
   									"MAXBUFFERSIZE=2048\0" 
   									"USERCOMMITSYNC=Yes\0" 
   									" General\0\0");
   	   
   		return 0;
   }
   					

2. Click ODBC Administrator.
3. Select the DSN you created, then click Configure.
4. Click Advanced to see the PageTimeout value.
5. Press OK.