Solve the problem that x64-bit IIS cannot connect to the Access Database

From http://blog.sina.com.cn/s/blog_67140b580100l6q6.html

Vista or 2003x64 (IIS6 or iis7) actually comes with Microsoft jet4.0 ole db provider, which can connect to the access database.
However, it only contains 32-bit data, which does not have 64-bit data and does not seem to provide 64-bit data for ms. Therefore, your project must be compiled into 32-bit data.ProgramTo call a 32-bit Microsoft jet4.0 ole db Provider. In vs2008, select any CPU in the CPU list

Error Type: ADODB. Connection(0x800a0e7a)Solution to provider not found

AnErrorOccurredOnTheServerWhenProcessingTheURL. PleaseContactTheSystemAdministrator

Method 1: Data Source

64-bit oledb provider for ODBC (msdasql)

Http://www.microsoft.com/downloa... 8-b9be-ca44d18b059b

Http://www.microsoft.com/downloads/details.aspx? Displaylang = ZH-CN & familyid = 000364db-5e8b-44a8-b9be-ca44d18b059b

Use \ syswow64 \ odbcad32.exe in the system directory to configure the data source on this tool.

Method 2: Run IIS6 32-bit

ASP. NET 2.0, 32-bit
To run the 32-bit version of ASP. NET 2.0, follow these steps:
1. Click Start, click Run, type cmd, and click OK ".
2. type the following command to enable the 32-Bit mode:
Cscript % systemdrive % \ Inetpub \ adminscripts \ adsutil. vbs set w3svc/apppools/enable32bitapponwin64 1

That is, cscript c: \ Inetpub \ adminscripts \ adsutil. vbs set w3svc/apppools/enable32bitapponwin64 1

3. type the following command to install ASP. NET 2.0 (32-bit) and install script ing in the IIS root directory:
% SystemRoot % \ Microsoft. NET \ framework \ v2.0.50727 \ aspnet_regiis.exe-I
4. Make sure that the status of ASP. NET 2.0.40607 (32-bit) is enabled in the Web Service Extension list of Internet Information Service Manager.
ASP. NET 2.0, 64-bit
To run the 64-bit version of ASP. NET 2.0, follow these steps: 1. Click Start, click Run, type cmd, and then click OK ".
2. type the following command to disable the 32-Bit mode:
Cscript % systemdrive % \ Inetpub \ adminscripts \ adsutil. vbs set w3svc/apppools/enable32bitapponwin64 0
3. type the following command to install ASP. NET 2.0 and install script ing in the IIS root directory:
% SystemRoot % \ Microsoft. NET \ framework64 \ v2.0.50727 \ aspnet_regiis.exe-I
4. Make sure that the ASP. Net 2.0.40607 status is set to allow in the Web Service Extension list of Internet Information Service Manager.
Note: The internal version of ASP. NET 2.0 may change as the internal version of the current release changes. These steps apply to the internal version 2.0.40607.

Appendix: MDAC 2.81 boot package

Http://www.microsoft.com/downloa... P; displaylang = ZH-CN

PS: Microsoft is ill. Why is there no MDAC for x64.
Source of this article from Yangcheng network Original article link: http://www.gznf.net/forum/thread-73571-1-1.html

Exercise caution when using Windows 2003 64-bit Edition
Http://bbs.coolfax.net/showtopic.aspx? Topicid = 260 & forumpage = 1 & onlyauthor = 1

Precautions for setting iis7 and solutions for Windows 2008 IA64-bit access failure.

The above method has been tested and is absolutely available.