[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
|
|
Problem Created a VBS referring - http://support.flexquarters.com/esupport/index.php?/Default/Knowledgebase/Article/View/506/57/examples-of-how-to-use-qodbc-via-visual-basic 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" Solution
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. | |
|