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

Source: Internet
Author: User

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/

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.