64位ODBC异常 [英] 64 bit ODBC Exception

问题描述

将开发平台从Windows XP X86迁移到Windows 7 X64时，出现以下ODBC异常:

I am getting the following ODBC exception when I moved my development platform from Windows XP X86 to Windows 7 X64:

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

我确定这意味着连接的服务器是32位，运行的计算机是64位，正在使用的ODBC驱动程序是64位.

What I'm sure it means is that the server it is connecting to is 32 bit, and the computer I'm running on is 64 bit and the ODBC driver in use is 64 bit.

我正在编写的应用程序设置为以32位模式运行，因为我们使用的某些第三方软件不兼容64位.

The application I am writing is set to run in 32 bit mode because some of the third-party software that we employ is not 64 bit compatible.

我尝试下载32位驱动程序并更改了DSN，但无法解决我的问题.我仍然有例外.

I tried downloading a 32 bit driver and changing the DSN but it did not fix my issue. I still get the exception.

如果任何人都有32位SQL驱动程序的任何链接，或者关于如何通过更改项目来解决此问题的任何想法，我都会耳熟能详.

If anyone has any links for 32 bit SQL drivers, or any ideas on how I could fix this by changing the project around, I'm all ears.

预先感谢

-Jrud-

推荐答案

听起来，您已经使用64位ODBC管理器设置了32位DSN:

It sounds more that you've setup a 32-bit DSN using the 64-bit ODBC Administrator :

http://msdn.microsoft.com/en -us/library/ms712362(VS.85).aspx

尝试改用此ODBC管理器:

Try using this ODBC Administrator instead :

c:\ windows \ sysWOW64 \ odbcad32.exe

c:\windows\sysWOW64\odbcad32.exe

这篇关于64位ODBC异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！