使用传统ASP在Windows Server 2003中的MS Access数据库

I'm migrating a classic ASP site from Windows Server 2003 to Windows Server 2008 R2. The problem is that the site are using a Microsoft Access database and using Microsoft.Jet.OLEDB.4.0 as provider.

我正在将一个经典的ASP站点从Windows Server 2003迁移到Windows Server 2008 R2。问题是该站点使用Microsoft Access数据库并使用Microsoft.Jet.OLEDB.4.0作为提供程序。

I have search the Internet for a solution, but can't find any driver that work in 64 bit Windows. Is it any other provider that I can use to access the database?

我在Internet上搜索解决方案，但找不到任何在64位Windows中运行的驱动程序。是否可以使用任何其他提供程序来访问数据库？

2 个解决方案

#1

I found the solution

我找到了解决方案

I changed the connections string to

我将连接字符串更改为

"Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\database.mdb;Uid=Admin;Pwd="

Then I enable 32 bits application. See http://www.iis.net/learn/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/using-classic-asp-with-microsoft-access-databases-on-iis

然后我启用32位应用程序。见http://www.iis.net/learn/application-frameworks/running-classic-asp-applications-on-iis-7-and-iis-8/using-classic-asp-with-microsoft-access-databases -on-IIS

#2

For run ASP application on 64 bit machine

用于在64位机器上运行ASP应用程序

Please change the application pool which is using for this Website to Enable 32 bit = true (don't know the exact property name) in IIS

请将用于此网站的应用程序池更改为在IIS中启用32位= true（不知道确切的属性名称）

#1