[QODBC-Desktop] QODBC error 80004005 when trying to run .vbs file on 64-bit machine
Posted by Rajendra Dewani (QODBC Support) on 23 August 2012 06:47 AM
On Executing VBS an Error message came up - "[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; Code: 80004005; Source: Microsoft OLE DB Provider for ODBC Drivers"
Since you are using the 64-bit system, your VBS will be executed as 64-bit (by default).
QODBC is the 32-bit driver and can work with 32-bit applications. 64-bit applications cannot talk to a 32-bit Driver and same is with 64-bit application to 32-bit Driver.
For 64-bit applications use QRemote (which is a 64-bit Driver driver).
Solution 1 You can try to use QRemote to bridge QODBC and your application. Here is an article about how to use QRemote: http://www.qodbc.com/qremoteconnect.htm
Solution 2 and there is another solution for your issue. Please call your VBS as 32-bit. Please follow the steps below:
1) Click Windows Start
2) Click Run, in the window, type "%windir%\SysWoW64\cmd.exe"
3) Click OK, then type "cscript vbscriptfile.vbs" in the cmd window
This will make your VBS run in 32-bit mode even thou you are in the 64-bit machine.