32位和64位ODBC驱动程序之间的结构不匹配 [英] Architecture mismatch between 32-bit and 64-bit ODBC drivers
问题描述
我读过的最周围的32位/ 64位的ODBC驱动程序和应用程序不匹配的讨论。我已经实现在我的问题与错误消息文章的建议，仍然没有找到成功。我最近从Windows XP转换到Windows 8.1，并正尝试重新建立我曾在XP中的数据库连接。我使用本地主机通过一个系统DSN服务了从本地的MS Access数据库中的数据的Active Server Pages（ASP经典） - 一切为32位和在同一台机器上。我已经启用所有的新的Windows 8.1的机器上的相关IIS参数，但不断收到在主题行中描述的错误消息。显然，有32位应用程序和64位平台之间不匹配，但解决方法大多数文章建议不工作（即创建ODBC管理SYSWOW64文件夹中的系统DSN）。请帮助。
I've read most of the discussion surrounding 32-bit/64-bit ODBC driver and application mismatches. I have implemented the suggestions in articles pertaining to the error message in my question, and still have not found success. I recently converted from Windows XP to Windows 8.1, and am trying to reestablish the database connections that I had in XP. I was using localhost with Active Server Pages (classic ASP) serving up data from a local MS Access database via a system DSN - everything was 32-bit and on the same machine. I've enabled all the relevant IIS parameters on my new Windows 8.1 machine, but keep getting the error message described in the subject line. Obviously there's a mismatch between the 32-bit application and 64-bit platform, but the workaround most articles suggest isn't working (i.e., create system DSN from ODBC manager within sysWoW64 folder). Please help.
推荐答案
您需要从微软下载中心下载Microsoft Access数据库引擎2010可再发行。 32位驱动程序和64位驱动程序都可用。
是什么在起作用？
You need to download the Microsoft Access Database Engine 2010 Redistributable from the Microsoft download center. A 32bit driver and 64bit driver are both available. What works?
如果您有任何的Office安装在64位服务器，然后安装64位驱动程序。
If you have a 64bit server with no Office installation then install the 64bit driver.
如果您有32位Office安装64位服务器，然后安装32位的驱动程序*。
If you have a 64bit server with 32bit office installation then install the 32bit driver*.
如果您有没有安装的Office 32位服务器，然后安装32位的驱动程序。
If you have a 32bit server with no Office installation then install the 32bit driver.
如果您有32位Office安装32位服务器，然后安装32位的驱动程序。
If you have a 32bit server with 32bit Office installation then install the 32bit driver.
*如果您要安装在64位机器上的32位驱动程序，然后安装程序会抱怨和失败。然而，安装有一个覆盖标志，如果你通过命令行（CMD.EXE）以管理员权限进行安装。
*If you are trying to install the 32bit drivers on a 64bit machine then the installer will complain and fail. However the install has an override flag if you install it via the command line (cmd.exe) with administrator privileges.
AccessDatabaseEngine_x64.exe /passive
ASP经典连接字符串
的访问文件的
<%
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.mdb;Persist Security Info=False;"
Con.Close
%>
的 Excel文件的
<%
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\book1.xlsx;Extended Properties=Excel 12.0;"
Con.Close
%>
这篇关于32位和64位ODBC驱动程序之间的结构不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
