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