网站公司用asp+access来做网站的数据存储,但是发现部署到iis时总是出现乱码的提示,把asp的父路径启用了没有用,
后来我为了看看到底是什么错误,将asp连接数据库的逻辑看了一下,发现是连接access数据库连接不上提示的错误是中文版本的,这样一来先可以先解决错误的实际问题:asp 连接不上access.在微软上找了文章,大家可以搜索Using Classic ASP with Microsoft Access Databases on IIS 这个标题,因为iis版本高于7.0时有些安全的东西变了,而且在64位系统里没有64位的access驱动,所以要将网站的对应的“应用程序池”=》高级设置=》是否启用32位应用程序设置为True,这样就可以正常使用asp连接access的mdb数据库文件了。
In IIS 7.0, IIS 7.5, and above, several security changes were made that may affect how classic ASP applications will function. For example, if you were to copy a classic ASP application that uses an Access database that is within the Web site's content area to a server that uses IIS 7.0 or above, you may receive the following error message:
**Microsoft JET Database Engine error '80004005'
Unspecified error.
/example.asp, line 100**
This is a generic error triggered by the Access driver that may occur for a variety of reasons, but incorrect permissions is a common cause. More specifically, the ability to work with Microsoft Access databases is implemented through the Microsoft JET Database Engine, which creates various temporary and lock files when it connects to an Access database. The following sections will discuss some of the reasons why this may occur and how to resolve those situations.
Working with 64-bit Systems
Unfortunately there are no 64-bit ODBC drivers, so on 64-bit systems you will have to run your applications in 32-bit mode. To do so, use the following steps:
- On the taskbar, click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.
- In the Connections pane, click Application Pools.
- Highlight the application pool for your application, then click Advanced Settings... in the Actions pane.
- In the Advanced Settings dialog, specify True for Enable 32-Bit Applications.
- Click OK to close the Advanced Settings dialog.