Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-05-01 08:51 AM

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

I am moving a QV app from a 32 bit OS to 64 bit OS.  I installed 64 bit QV.  I created  64 bit ODBC for SQL and it works fine.  I created 32  bit ODBC for MS Access but receive the following error,

SQL##f - SqlState: IM014, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

ODBC CONNECT TO [QV Sales;DBQ=\\FB-DC\D\ACCESS812\QV Sales.mdb]

I tried cecking the box "Force 32 bit" but continue to receive this error.  Thanks for our help

10,636 Views
0 Likes
1 Solution

Accepted Solutions
Not applicable
‎2013-05-01 02:40 PM
Author

Setup 32 bit ODBC by executing c:\windows\sysWOW64\odbcad32.exe.

In QV ODBC script statement click on "Force 32 bit" and redo the ODBC statement.  Click "Connect" button and select the ODBC source. Should be "ODBC CONNECT32 TO" as oposed to "ODBC CONNECT TO".

View solution in original post

5,970 Views
1 Reply
Not applicable
‎2013-05-01 02:40 PM
Author

Setup 32 bit ODBC by executing c:\windows\sysWOW64\odbcad32.exe.

In QV ODBC script statement click on "Force 32 bit" and redo the ODBC statement.  Click "Connect" button and select the ODBC source. Should be "ODBC CONNECT32 TO" as oposed to "ODBC CONNECT TO".

5,971 Views