Settings for running jet. oledb on 64-bit IIS (iis7)

The 64-bit operating system does not support the Microsoft ole db provider for jet driver.ProgramAnd earlier Microsoft Access Driver (*. mdb) connections are not supported. Therefore, Microsoft ole db provider for jet for access and Excel databases are 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 set the IIS runtime environment to 32 bits:

IIS6 practices:

1. Type in the command line:

Cscript.exe % systemdrive % \ Inetpub \ adminscripts \ adsutil. vbs set w3svc/apppools/enable32bitapponwin64 1

That is, IIS6 is set to allow 32-bit programs to run on 64-bit machines.

2. Register. Net frameworks again.

% SystemRoot % \ Microsoft. NET \ framework \ v2.0.50727 \ aspnet_regiis.exe-I

3. A 32-bit Asp.net is displayed, for example:

Set it to allow. Disadvantages: this will enable all sites on IIS to run in 32-bit compatibility mode.

Iis7 is much simpler:

Application pool, advanced settings --> allow 32-bit applications, such:

We recommend that you create an application pool for 32-bit application drivers.

Turn: http://xt3w.blog.163.com/blog/static/47958360201021610829718/