Knowledgebase
[QODBC-Desktop] Troubleshooting: Begin Session Failed. Error = 8004041d, 80040418, 8004041a, 80040430
Posted by brad waddell on 12 March 2009 05:21 PM

Troubleshooting: Begin Session Failed. Error = 8004041d, 80040418, 8004041a, 80040430

Problem Description:

Get the following errors from QODBC driver:

ERROR [00000] [QODBC] QB Begin Session Failed. Error = 8004041d,80040418 This application is not allowed to log into this QuickBooks company data file automatically. The QuickBooks administrator can grant permission for automatic login through the Integrated Application preferences.

Test connection to Quick Books - FAILED: "[QODBC] QB Begin Session Failed. Error = 8004041a. This application does not have permission to access this QuickBooks company data file. The QuickBooks administrator can grant access permission through the Integrated Application preferences" 

Step.png

Error.png

 

Problem Description:

I am receiving the error: “Recent changes to your configuration require you (the QuickBooks Administrator) to go into the Integrated Applications preferences and re-authorize your integrated application to log in automatically.” Immediately when starting the QODBC program.

Solutions:

Please keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode. Navigate to "Edit" Menu -> "Preferences"  -> "Integrated Applications" -> "Company Preferences" Tab.

Please make sure ALL the applications with the name "FLEXquarters QODBC" has "Allow Access" option CHECKED/TICKED. If it is unchecked, please check it & apply changes by clicking "OK" button.

Keep QuickBooks running and in single user mode, try to connect with your application.

If you are still facing the issue, please remove all the integrated applications in QuickBooks via QuickBooks -> Edit Menu -> Preferences -> Integrated Applications -> Company Preference Tab

How to remove QODBC Related Certificates from Integrated Application under QuickBooks

After removing all the "FLEXquarters QODBC"  integrated applications, please close Integrated applications window.

Test the connection using QODBC Support Wizard and VB Demo

 

Problem Description:

I have installed the latest version on a PC running Windows 2008 R2 and Reckon Enterprise 2014. I got the following message when I tried to test the link:

"QB Begin Session Failed. Error = 80040430, This application is unable to log into the Reckon Accounts company data file automatically.The Reckon Accounts administrator must grant permission for automatic login through the Integrated Application preferences. If such permission was already granted, the administrator must revoke permission, then grant the permission again"

 

Error.png 

Solutions:

I would like to inform you that above error says that you have not accepted QuickBooks certificate. Please keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode and try to connect using your application, it should pop-up Data Access Certificate on QuickBooks, Please accept the Certificate Then try again.

I kindly request you to please create new MS Access database & keep QuickBooks running, logged in as Admin to your company file, Switch to single user mode and try to connect, it should pop-up Data Access Certificate on QuickBooks, Please accept the Certificate. 

I would like to inform you that QuickBooks issue Certificate is for each application. You might have accepted the certificate for application A, but application B would not have access. 

Notes for QB 2006 and before Users

For those who use QuickBooks 2006 and the previous version, please see: After upgrading to QuickBooks 2006, QODBC "auto-login" unattended mode no longer works? For more details on troubleshooting auto-login mode connections.

This is a known problem that exists in the QuickBooks qbXML SDK from Intuit, caused by QuickBooks when upgrading an existing QuickBooks company file that had previously worked with QODBC to the new 2006 USA format (used by QuickBooks 2006 and 2007) or even adding new user accounts to QuickBooks. The problem still exists with QuickBooks 2007.

This issue is an Intuit SDK issue, not QODBC. Intuit required us to change unattended mode access for QuickBooks 2005 and 2006, which we did from QODBC v6.00.00.150 onwards. Unfortunately, all 2005 company files that have been accessed previously by QODBC have this problem when the company file is converted by QuickBooks to the new 2006 or 2007 Anywhere Sybase backend format. The Intuit conversion corrupts the internal integrated applications settings, and you need to do the 17 step procedure workaround.

The staff at IntuitQBES (QuickBooks Enterprise Solutions) would like me to pass the following message to you:

Using the R5 (or later) release for QuickBooks Enterprise Solutions Version 8, developers can now use their QODBC applications with QuickBooks closed.

Download the R5 (or later)update here:

http://support.quickbooks.intuit.com/Support/ProductUpdates.aspx

Remember that when using this feature, you have to use 'Locate a company file' or a QODBC connection string with "DFQ=C:\Program Files\QODBC Driver for QuickBooks\sample04.qbw" rather than 'Use the company file that's now open in QuickBooks'.

Note: R5(or later) for QuickBooks Enterprise 8 (2008) has the Intuit bug fix, not R11(or later) for QuickBooks Enterprise 7 (2007) !!!!

(97 vote(s))
Helpful
Not helpful

Comments (1)
Eric
20 September 2012 03:44 PM
Attn: QuickBooks Development:I own a construction compnay that does subcontract work for other construction companies in addition to being the prime contractor on many of our own projects. Several times I have brought to the attention of Intuit (through customer support) a problem with the way certain data is displayed and/or printed on various forms. Situation -My customer is “Smith Construction Co.”Smith Construction builds spec houses as well as custom houses for many different clients.Smith Construction needs pricing from me on several different phases of spec house being built on Lot 101. These may include Cabinets, Flooring, Tile, Carpet, Swimming Pool, etc.In QuickBooks, The Customer Name is entered as “Smith Construction”A Job under “Smith Construction” is entered as “Lot 101”Since Smith Construction is having several phases of the house on Lot 10 quoted by my compnay, each phase is entered as a sub job under the job “Lot 101” (Smith Construction:Lot 101:Cabinets). By doing this, I can track the profit or loss of each phase of the Lot 101 project being built by Smith Construction. Everything mentioned so far works and achieves my need for tracking the profit and loss as required.Here lies a problem that needs to be addressed by the QuickBooks development team.On any estimate or an invoice I send to Smith Construction, only the last portion of the job in the “Project/Job” field is displayed on that form. “Smith Construction:Lot 101:Cabinets” is displayed and printed only as “Cabinets” on an estimate or invoice. What I would like to be displayed is “Lot 101:Cabinets” so that my customer (Smith Construction) can identify which house this cabinet installation belongs to when looking at an estimate or invoice.Everything prints correctly on statements so I have to think this is an easy fix.Please let me know if this is something that can be added in future updates toQuickBooks.Sincerely,Kyle BowserTymeless FlooringQuickBooks Enterprise Solutions 11.00 30 user
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).