View Single Post
 
Old 03-01-2013, 03:00 AM
ArviL ArviL is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2013
Posts: 11
ArviL is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
OK, it looks like I got the reason I have problem from here.
"
If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message:



The specified DSN contains an architecture mismatch between the Driver and Application



To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN."

But the DSN used for queries from Excel files isn't user-defined! It was installed by MS Office Installer! So MS Office Installer didn't check, is there 32-bit or 64-bit OS? And no update or SP didn't correct this either?

The problem isn't that the query doesn't work properly in my computer - I can cope with this. But there are somewhat 200+ MS Office users in our plants all over 4 European countries, and any of them my need to use some of workbooks I have designed. When I go to bosses, and say: "Khm...! We have to employ some guy who will manage all those ODBC datasources!", then I hardly can expect some positive response :-)
Reply With Quote