Knowledgebase
[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.

(5 vote(s))
Helpful
Not helpful

Comments (4)
Edgar
20 September 2012 07:13 AM
Keep these atircles coming as they've opened many new doors for me.
Ksks
20 September 2012 01:13 PM
I'm grtafuel you made the post. It's cleared the air for me.
Astro
20 September 2012 04:24 PM
Thanky Thanky for all this good ifnoramiton!
Star
31 March 2016 12:31 PM
Love you!!!!!!!!!!!! You are the only one to suggest the solution 2, and that's the only solution that works!!!! Like after an year of troubleshooting that worked! You're a genius :):) Thank you for this simple awesome step
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).