MS Access数据库在Windows Server 2003中使用传统的ASP [英] MS Access database in Windows Server 2003 using classic ASP
问题描述
我迁移从Windows Server 2003到Windows Server 2008 R2的传统的ASP网站。问题是,在网站上使用的是Microsoft Access数据库,并使用Microsoft.Jet.OLEDB.4.0作为提供程序。
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.
我在网上搜索解决办法,但不能发现,在64位Windows上工作的任何驱动程序。这是任何其他供应商,我可以用它来访问数据库?
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?
推荐答案
我找到了解决办法。
我改变了连接字符串
"Driver={Microsoft Access Driver (*.mdb)};Dbq=c:\database.mdb;Uid=Admin;Pwd="
然后,我让32位应用程序。见<一href=\"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\" rel=\"nofollow\">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
这篇关于MS Access数据库在Windows Server 2003中使用传统的ASP的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!