[QODBC-Desktop] Troubleshooting: Using QODBC to connect to different versions of QuickBooks
Posted by Juliet (QODBC Support) on 30 August 2011 06:28 AM
Troubleshooting: Using QODBC to connect to different versions of QuickBooks
Can multiple versions of QuickBooks (such as Pro, Premier, and Enterprise) on the same server work with the same edition of QODBC installed?
Sometimes could get the error below:
Error Description: Error code is: 800401F3:: Failed to connect, with ODBC: [QODBC] QB Begin Session Failed. Error = 80040421, This file can only be opened with QuickBooks Enterprise Solutions. Please open this file with QuickBooks Enterprise Solutions, then try again.
QODBC is licensed by the version of QuickBooks you are using. You could not use it with different versions in different regions, but it could work well with both QBES and QBPremier (all in the same region edition).
QODBC is not upward compatible, only backward, meaning you need version 11 of QODBC to work with QuickBooks 2011. Version 11 of the driver will work with all QuickBooks 2002- 2011 Pro and Higher editions. The Read Only version of QODBC is included with QuickBooks Enterprise Solutions 11.
And we always suggest you set up different QODBC DSNs to point to different company files. In such case, if you set up your QODBC DSN as "Use the company file that's now open in QuickBooks," QODBC will automatically point to the currently open company file, no matter if it's a QBES file or QBPro file. And if you want to specify a company file by checking the option "Locate a company file" in QODBC, please see: How to set up QODBC for Auto-login into QuickBooks for more.