Knowledgebase: Setup
[QODBC-Desktop] QB Open Connection Failed. Error = 8004042f
Posted by brad waddell on 12 March 2009 05:21 PM

Troubleshooting: QB Open Connection Failed. Error = 8004042f

Problem Description

    When trying to connect to the QuickBooks or Reckon, and getting the following error.

Test Connection to QuickBooks Failed.

[QODBC] QB Open Connection Failed. Error = 8004042f, The requested connection type could not be found.

 

Solutions

It would help if you had QuickBooks installed on the machine on which QODBC is installed.

If you already have installed QuickBooks and are still facing the issue, please reinstall QuickBooks.

Restart your machine after QuickBooks is installed.
Start QuickBooks and update to the latest release.
Test connection using QODBC Support Wizard - http://qodbc.com/links/2981
 
For QuickBooks 2021 or older versions:
If you are facing the 'Create QuickBooks COM instance Error=80040154' or 'Class not found' error, please refer to 


 
For QuickBooks 2011 or older versions

QuickBooks Trial Edition:

   Your trial version of QuickBooks must be registered with Quicken before QuickBooks will allow integrated applications to access it. Once you have QuickBooks written, follow the: How to Connect to QuickBooks for the First Time to connect again.

     If your trial version is registered, you might have chosen to install a QuickBooks flavor that's not communicating with the SDK. The workaround for this is simple -- if you go to your QuickBooks program files directory and COPY qbw32.exe to qbw32<flavor>.exe where <flavor> is the flavor of QuickBooks you have installed:

Pro
Premier
PremierAccountant
PremierContractor
etc.

     Then your QODBC connection issue should go away.

     For example, if you have QB Premier, contractor edition installed, then you would copy QBW32.exe to QBW32PremierContractor.exe in the QuickBooks program files directory, etc., as per below:

qbw32premieraccountant.exe
qbw32premiercontractor.exe
qbw32premiergeneric.exe
qbw32premiernonprofit.exe
qbw32premierprofessional.exe
qbw32premierretail.exe
qbw32premierwholesale.exe
qbw32pro.exe
qbw32simplestart.exe

QODBC Instruction

     QODBC is a fully functional ODBC driver for reading and writing QuickBooks Pro, Premier, Accountant, and Enterprise accounting data files. QODBC doesn't work with QuickBooks Easy Start, Accounting (formally known as Lite), Plus, or Small Business Editions.

     BTW: The Australian version of QuickBooks also doesn't support Integrated Applications like QODBC on Microsoft Windows Vista operating systems. You must use QuickBooks on Windows XP or Windows 2003 platforms.

(139 vote(s))
Helpful
Not helpful

Comments (2)
Pablo
05 February 2015 01:29 PM
I am getting this error, even though quickbooks is open and there is a qbw32premiergeneric.exe present. Any other reasons?
Jack
23 February 2015 01:37 PM
Hi Pablo,

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