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 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.

Solutions

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.

 

(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).