[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 the driver and the application.
Troubleshooting: The specified DSN contains an architecture mismatch between the driver and the 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. (The specified DSN contains an architecture mismatch between the driver and application.) when you directly use QODBC with a 64-bit application, it will report this error.
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 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 your site's support pages and help. I can successfully connect to the QB using the QRemote Server, but Excel occasionally fails. 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, I kindly request you to verify the connection string in both excel files.
Please open the MS Excel file and go to the "Data" tab >> Click on "Connection" >> Click on "Properties" >> Navigate to the Definition tab >> You can find the 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