WINDOW2003 64-bit IIS connection access error "microsoft.jet.oledb.4.0" issue

WINDOW2003 64-bit IIS connection access error "microsoft.jet.oledb.4.0" issue

Because the 64-bit operating system does not support the Microsoft OLE DB Provider for Jet driver, the earlier Microsoft Access Driver (*.mdb) mode connection is not supported. So the Microsoftole DB Provider for Jet used for access and Excel databases is not available in the 64-bit version, which means that the following two connection strings are not working correctly:
"Provider=microsoft.jet.oledb.4.0;datasource=" &server.mappath (db)
"Driver=microsoft accessdriver (*.mdb);D bq=" &server.mappath (db)
In this case, you can only use one method to set the operating environment of IIS to 32 bits:

First, the practice on the IIS6:
1. Command line type:
cscript.exe%SystemDrive%\inetpub\adminscripts\adsutil.vbs SET W3svc/apppools/enable32bitapponwin64 1
Setting IIS6 allows 32-bit programs to run on 64-bit machines
2. Re-registering. NET Frameworks
%systemroot%\microsoft.net\framework\v2.0.50727\aspnet_regiis.exe-i

3. When you are finished, look at the Web service extension, you should have a 32-bit ASP. NET to allow, disadvantage: This will make all sites on the entire IIS run in 32-bit compatible mode.
Run IIS6 to see if it's resolved.
Set it to allow, disadvantage: all sites on the entire IIS run in 32-bit compatible mode
Second, the practice on the IIS7 is much simpler:
Application pool, advanced settings-allow 32-bit applications to be set to "True".

WINDOW2003 64-bit IIS connection access error "microsoft.jet.oledb.4.0" issue