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 a 32-bit driver and can work with 32-bit applications. 64-bit applications cannot talk to a 32-bit Driver, and the same is with 64-bit applications 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 32-bit. Please follow the steps below:

1) Click Windows Start

2) Click Run in the window, and 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 though you are in the 64-bit machine.