Knowledgebase: Version
[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

Problem Description

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.

Solutions

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.

 

(70 vote(s))
Helpful
Not helpful
Comments (3)
Howard Fuller
24 July 2013 04:11 PM
Does not work! This is the most frustrating software setup I have ever been through. I started with my first computer in 1980.
Regardless of how the access is configured the "Only licensed for use with Enterprise Version" stop sign comes up.
I am using Quickbooks Premier - 2013. If I transfer the file to the Enterprise version, my client will not be able to use the file that I return to him.
How to solve this dead end?
CP Wilkinson II
05 December 2014 10:51 AM
I would like more information as with Howard Fuller i'm working with a company file that is in premier only and i can't change it up to enterprise for compatibility reasons. All indications of your site say that QODBC works with pro , premier and enterprise, is this correct?
Jack
09 December 2014 12:17 PM
Hi Wilkinson,

I would like to inform you that QODBC can works with QuickBooks Enterprise, Pro, Premier.

I kindly request you to please raise a support ticket to the QODBC Technical Support department from below mentioned link & provide requested information:

http://support.flexquarters.com/esupport/index.php?/Tickets/Submit

I kindly request you to share more information about the issue you’re facing, so that we can locate the problem quickly.

We may need following information, I kindly request you to attach below listed files when replying to the ticket.
1) Screenshot of QODBC Setup Screen -- > About (Start>>All Programs>> QODBC Driver for use with QuickBooks>> QODBC Setup Screen >> About Tab )
2) Screenshot of the issue you’re facing.
3) Share QuickBooks Version details: Press f2 on QuickBooks UI & share screenshot.
4) Share the SQL statement you’re using.
Share Entire Log Files as an attachment in text format from
5) QODBC Setup Screen -- > Messages -- > Review QODBC Messages
6) QODBC Setup Screen -- > Messages -- > Review SDK Messages
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).