我如何连接到我的64位SQL Server使用ODBC？ [英] How do I connect to my 64-bit SQL Server with ODBC?

问题描述

我最近安装了SQL Server 2008前preSS在我的Windows 7旗舰版64位家用机。我也有IIS 7.5与PHP 5.3，而我试图连接通过 ADODB 到SQL，但一直得到这个错误：

I recently installed SQL Server 2008 Express on my Windows 7 Ultimate x64 home machine. I also have IIS 7.5 with PHP 5.3, and I was trying to connect to SQL via ADODB, but kept getting this error:

[Microsoft][ODBC Driver Manager] The specified DSN contains an
architecture mismatch between the Driver and Application

做少量挖掘在互联网上之后，我觉得这是因为SQL Server ODBC驱动程序是为32位操作系统，而我是64。首先，我是不是正确的？这是我遇到麻烦的原因是什么？其次，如果是的话，我该如何解决这一问题？是否有与64位操作系统上运行任何更新的ODBC驱动程序？我看了看，但未能找到任何...

After doing a small amount of digging on the internet, I think this is because the SQL Server ODBC driver is meant for 32-bit operating systems, and mine's 64. First of all, am I correct? Is this the reason I'm running into trouble? Secondly, if so, how do I fix this? Are there any updated ODBC drivers that work with 64-bit operating systems? I looked but was unable to find any...

推荐答案

您说得对，它做的位。

希望这有助于：

- 从MSDN -

--From MSDN --

要管理连接到一个32位驱动程序在64位的数据源   平台，使用C：\ WINDOWS \ SYSWOW64 \ odbcad32.exe的。要管理数据   源连接到一个64位的驱动程序，使用   C：\ WINDOWS \ SYSTEM32 \ odbcad32.exe的。如果使用64位odbcad32.exe的   配置或删除的DSN连接到32位的驱动程序，你会   收到此消息。

To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver you will receive this message.

这篇关于我如何连接到我的64位SQL Server使用ODBC？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！