In a 64-bit system, IIS cannot run 32-bit programs. In a 64-bit system, a 32-bit program cannot run. The system prompts that no provider is specified, and no default provider is specified.
This is a typical 64-bit system problem. Because the 64-bit operating system does not support the Microsoft ole db provider for jet driver or earlier Microsoft Access Driver (*. MDB. This was confirmed on Microsoft's website. Microsoft ole db provider for jet for access and Excel databases is unavailable in 64-bit versions. That is to say, the following two connection strings are no longer working properly:
"Provider = Microsoft. Jet. oledb.4.0; Data Source =" & server. mappath (db)
"Driver = Microsoft Access Driver (*. mdb); DBQ =" & server. mappath (db)
In this case, you can only use one method to set the IIS runtime environment to 32 bits: "server/application pool/defaultapppool/Set application pool default settings/(General) /enable the 32-bit application/true ". This is the use method of Vista. If it is not enough in 2003, you should use the following command.
CMD to DoS Workspace
Go to c: \ Inetpub \ adminscripts \
Run
Adsutil. vbs set w3svc/apppools/enable32bitapponwin64 true
Iisreset
You can.