错误 [IM014] [Microsoft][ODBC Driver Manager] 指定的 DSN 包含驱动程序和应用程序之间的体系结构不匹配

我该如何解决这个错误?错误 [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains a architecture mismatch between the Driver and Application ..它发生在我正在做的一个新项目中......我使用vb 2008，MYSQL作为我的数据库和windows 8.1 作为我的操作系统

我在论坛上读到您刚刚使用 odbc 管理员工具修复...我尝试在那里创建我的 DSN，但它仍然无法正常工作...我尝试打开我的一个旧项目它工作正常..但是这个新项目一直收到这个错误..我需要这个才能工作，这样我才能做我的水晶报告..我已经尝试修复这个错误一整天了，但我无法修复它..

有人可以帮助我吗?谢谢..

解决方案

这是一个 64 位与 32 位的问题.您正在 64 位系统上访问 32 位 odbc 驱动程序.

如果您打开 c:windowssystem32odbcad32.exe，您将看不到 c:windowssyswow64odbcad32.exe 中的驱动程序(或正好相反)

检查你的应用程序的目标平台，如果这不能解决它，你可以通过安装正确的驱动程序(64位或32位)来偷偷摸摸

如果您从 Visual Studio 调试项目，您还需要将其作为 32 位运行.为此，您需要通过右键单击项目并选择属性来打开项目属性.到达这里后，您需要将 Run64BitRuntime 设置为 FALSE.

how can i fix this error? ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.. it is occuring in a new project that i am doing... im using vb 2008 , MYSQL as my database and windows 8.1 as my OS

i read on forums that you just fix with the odbc administrator tool... i tried creating my DSN there but it still doesnt work... i tried opening an old project of mine it works fine.. but this new project keeps getting that error.. i need this to work so that i can do my crystal reports.. i've been trying to fix this error for a full day now and i cant fix it..

can someone help me? THANKS..

解决方案

its a 64 vs 32 bit issue. You are accessing a 32 bit odbc driver on a 64 bit system.

IF YOU OPEN c:windowssystem32odbcad32.exe you will not see a driver there that is in c:windowssyswow64odbcad32.exe (or just the opposite)

Check the target platform of your application, and if that doesn't fix it, you might be able to sneak by just installing the correct driver ( 64 or 32 bit )

If you are debugging the project from Visual Studio, you will also need to run it as 32-bit. In order to do this you need to open the project properties by right clicking on the project and selecting properties. Once here you need to set Run64BitRuntime to FALSE.*