win7/win2008 R2 X64 System IIS 7.5 Access database connection fault resolution _win server

In WIN7 X64 system or other Windows X64 system IIS, you cannot connect to access data by using Jet.
Common Error Tips:

ADODB. Connection error ' 800a0e7a ', provider not found. The program may not be installed correctly.

Or

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '
[Microsoft] [ODBC Driver Manager] did not find a data source name and no default driver specified

The reason is that there is no 64-bit system jet driver.

Workaround One:

Start – Run – Enter "cmd" and type the following command to enable IIS 32-bit mode:
(1) If it is IIS6
cscript%systemdrive%\inetpub\adminscripts\adsutil.vbs SET w3svc/apppools/enable32bitapponwin64 1
(2) If it is IIS7:
appcmd List Apppool/xml | appcmd set Apppool/in/enable32bitapponwin64:true

Attention:

APPcmd.exe is located in the C:\Windows\System32\inetsrv directory
Use Cd c:\Windows\System32\inetsrv to switch to this directory,
If you do not switch, you are prompted that Appcmd is not an internal or external command, is not a program that can be run, or a batch file.

Workaround Two:
Modify the "Advanced settings" of the application pool.

Open IIS Manager, click the "Application Pool" on the left, right-click DefaultAppPool or the name of your site's standalone application pool in the view, select Advanced Settings, and modify the following image:




Set the Enable 32-bit application to true.

method Three:

Using new version of data driver

Download installation: Microsoft Access Database Engine Redistributable for X6 4

To modify the connection string:
Provider=microsoft.ace.oledb.12.0;data source=; User id=; password=; The
Data source\user Id\password is set according to the actual situation.

But there is a difference between the data drivers for aces and jet, and it's not good to test for some programs that need to be modified but don't know how to change them. The second method recommended by

is whether your site is a stand-alone application pool,
If it is, modifying the default application pool has no effect, and you need to modify the application pool for that site name.