[QODBC-Desktop] QODBC Reports Architecture Mismatch Problem When connecting
Posted by Wilson (QODBC Support) on 07 May 2012 02:41 AM
The specified DSN contains an architecture mismatch between driver and application.
Troubleshooting: The specified DSN contains an architecture mismatch between driver and application.
Using QODBC on a 64-bit Windows Operating System, test the connection using QODBC Test Tool works well. But when trying to connect to QODBC (QuickBooks Data) using 64-bit applications, such as MS Access, Excel, PHP, and SQL Server, I get the following error:
"The specified DSN contains an architecture mismatch between driver and application."
Are there any settings that need to be done to fix this problem?
QODBC is a 32-bit driver, which means it can only work with 32-bit applications when you directly use QODBC with a 64-bit application, it will report this error. (The specified DSN contains an architecture mismatch between driver and application.)
You could switch to using the 32-bit application to avoid this error, i.e. Uninstall your 64-bit application and get/install a 32-bit version of the same application.
Use QRemote: A new component added into QODBC, and it can connect to 32-bit QODBC from 64-bit applications without any problems. Please click here for more information about QRemote.
Note: QRemote can only work with Licensed QODBC 2012 or higher, or it will report a "license invalid" error. If you are using SQL Server/Windows Service/Any Service-based application, you need a QODBC Server license to connect using QRemote.
Problem Description 2:
We upgrade to the latest release of the QODBC driver and followed the instructions to connect using the QRemote 64-bit option. Our environment is Win 8.1 64-bit and we are running Excel 2013 64-bit version. I have tried multiple attempts using the support pages and help from your site. I can successfully connect to the QB using the QRemote Server but Excel fails every time. This worked fine before the upgrade.
I am getting the below error when I try to get data from MS Excel:
Please create new MS Excel file & import data using QRemote 64-bit DSN and share the outcome. If a new MS Excel file is working, then I kindly request you to please verify the connection string in both excel files.
Please open MS Excel file go to "Data" tab >> Click on "Connection" >> Click on "Properties" >> Navigate to Definition tab >> You can find Connection String box.
Please verify both workbook connection strings. I think there might be a different connection string.
Keywords: ColdFusion, PHP, SQL Server, MS Access, MS Excel