MS Query Error - The specified DSN contains an architecture mismatch between Driver & Application
-
jeudi 7 avril 2011 00:28I'm attempting to connect to an Informix server 64 bit. I've installed the Informix SDK 3.70 64 bit client and have tested the ODBC connectivity and it works. When I run MS Query in Excel 2010 I get the above error. I have reinstalled this twice. Removing all programs, program references and registry keys. The ODBC setup appears to be working in the 64 bit mode. I am forced to set a user DSN vs System DSN (this is another issue). It looks like MS Query is working in 32 bit mode somehow as if I select <New Data Source> it only brings up the 32 bit ODBC drivers not the 64. Is there a switch/registry setting that MS Query in EXcel 2010 / Windows 7 64bit needs to have set/changed? Please assist. Many thanks
Toutes les réponses
-
vendredi 8 avril 2011 19:16
Are you running 64-bit Excel (Office)? If not, then MSQuery would only run in the 32-bit mode and the 64-bit drivers would not show up.
Will Buffington
Microsoft Excel Support- Marqué comme réponse Harry Yuan lundi 11 avril 2011 02:09
-
mardi 19 avril 2011 19:08
Are you running 64-bit Excel (Office)? If not, then MSQuery would only run in the 32-bit mode and the 64-bit drivers would not show up.
Will Buffington
Microsoft Excel Support
I'm having the same problem. The Windows 7 compatibility page says that the version of Excel I am on is both 32 and 64 bit compliant, but the "about" screen says nothing about being either 32 or 64 bit.What can I do to determine exactly what version of Excel I have and its compatibility with 32 and/or 64 bit drivers?
Thanks.
-
lundi 30 avril 2012 15:20Has anyone ever figured out why this is happening and found a solution?
.png)
