[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 64Bit Windows Operating System, test the connection using VB Demo works well. But when trying to connect to QODBC (QuickBooks Data) using with 64-bit applications, such as MS Access, Excel,PHP, and SQL Server, I get following error:
"The specified DSN contains an architecture mismatch between driver and application."
Is there any settings needs 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 use 32-bit application to avoid this error, i.e. Uninstall your 64bit application and get/install a 32bit 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 "license invalid" error. If you are using SQL Server/Windows Service/Any Service based application, you need an 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 below error when I try to get data from MS Excel:
I kindly request you to please create new MS Excel file & import data using QRemote 64 bit DSN and share outcome. If a new MS Excel file is working, then I kindly request you to please verify connection string of both excel file.
Please open MS Excel file go to "Data" tab >> Click on "Connection" >> Click on "Properties" >> Navigate to Defination 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