在Windows Server 2008，IIS7.5和连接到MS Access 97数据库 [英] Windows Server 2008, IIS7.5 and connection to MS Access 97 database

问题描述

我知道，话题听起来很可怕。但我实际上是连接这些技术。

I know, the topic sounds terrible. But I actually have to connect these technologies.

我目前从Windows Server 2003 32位与IIS 6到Windows Server 2008 R2 64位迁移公司的内联网（在传统的ASP大多写的）与IIS 7.5。一切正常，除了它使用设置康恩=的Server.CreateObject（adodb.connection）连接到 CONNSTRING =DRIVER一子页面完全正常= {Microsoft Access驱动程序（* .mdb）中}; DBQ =路径\\为\\ MDB \\其中\\是\\真的\\有。

I am currently migrating company's intranet (written mostly in classic ASP) from Windows Server 2003 32 bit with IIS 6 to Windows Server 2008 R2 64 bit with IIS 7.5. Everything works perfectly fine except for one subpage which uses set conn = server.createobject("adodb.connection") to connect to connstring="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=path\to\mdb\which\is\really\there".

我打开连接（ conn.open CONNSTRING ），建立一个查询字符串，然后，当我想设置rsresult = conn.execute（ sqlusr）我得到

I open connection (conn.open connstring), build a query string and then, when I want to set rsresult = conn.execute(sqlusr) I get

Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'TABLE_THAT_ACTUALLY_EXISTS' failed.

这错误是在用行conn.execute（sqlusr）抛出。当然，它的工作在previous环境很好。

That error is thrown at the line with conn.execute(sqlusr). Of course, it worked fine in previous environment.

• connect在Windows Server上的MS Access ACCDB文件2008 - 我才知道，在Windows Server 2008已经MSJet preinstalled，所以这个问题是没有用的（提醒：MDB是进入97）


• http://support.microsoft.com/kb/168336 - 这实际上是如何连接成功，但我认为某事可能是错误的，拼写错误，...


• 我复制的ODBC数据源形式previous服务器到新的（我不停的名字） - 问题依然存在


• 我安装了Windows Server 2008的计算机上的最新更新

• connect to MS Access accdb file on Windows Server 2008 - I learned that Windows Server 2008 has MSJet preinstalled, so this question is of no use (reminder: mdb is for Access 97)
• http://support.microsoft.com/kb/168336 - this is actually how the connection is made but I thought that sth may be wrong, misspelled, ...
• I copied ODBC data sources form previous server to the new one (I kept the names) - problem still exists
• I installed the latest updates on Windows Server 2008 machine

• MDB 将打开的仅在Access 97（为什么不问我：？/我不是谁试图唯一一个在Access 2000/2003/2007/2010打开它 - 它的工作无处）


• 本网页上的IIS 7.5已启用32位应用程序的应用程序池选项设置为真正。父路径也被启用。

• mdb will open only in Access 97 (why? don't ask me : / I wasn't the only one who tried to open it in Access 2000/2003/2007/2010 - it worked nowhere)
• application pool for this web page on IIS 7.5 has Enable 32-bit Applications option set to true. Parent paths are also enabled.

我将是什么检查/办/如何解决这个问题的任何额外的提示表示感谢。

I will be grateful for any additional tips on what to check/do/how to fix this issue.

推荐答案

好吧，我解决我的问题。我能够从Access 97中导入数据和表格，Access 2010的真轻松。然后，我遇到了一些问题与ASP及其MDB连接。所以我直接连接到数据库。我还是要修复SQL语句，但主要的问题得到解决。

OK, I solved my problem. I was able to import data and forms from Access 97 to Access 2010 really easily. Then I encountered some problems with asp and its connection to mdb. So I connected directly to the database. I still have to fix sql statement, but the main problem is resolved.

谢谢！

这篇关于在Windows Server 2008，IIS7.5和连接到MS Access 97数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！