[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 Australian QuickBooks file (version 2007/08 trial) 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.
Your trial version of QuickBooks must be registered with Quicken before QuickBooks will allow integrated applications to access it. Once you have QuickBooks registered, 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 only. 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