[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 as 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 with different regions but it could definitely work well with both QBES or QBPremier (which are all the same region edition).
QODBC is not upward compatible only backward, meaning you would need version 11 of QODBC to work with QuickBooks 2011. Version 11 of the driver will work with all editions of QuickBooks 2002- 2011 Pro and Higher. The Read Only version of QODBC is included with QuickBooks Enterprise Solutions 11.
In such case, if you setup your QODBC DSN as "Use the company file that's now open in QuickBooks", QODBC will automatically point to the current open company file no matter 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 setup QODBC for Auto-login into QuickBooks for more. And we always suggest you to set up different QODBC DSNs to point to different company files.