Troubleshooting: QB Begin Session Failed. Error = 8004041c

Problem Description

     When I run a report in my Java file using QODBC to connect to QuickBooks I get the following error:

     java.sql.SQLException: [QODBC] QB Begin Session Failed. Error = 8004041c, An internal QuickBooks error occurred while trying to access the QuickBooks company data file.

     And below is the Java code used:

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
Connection con = DriverManager.getConnection("jdbc:odbc:QuickBooks Data");
Connection con1 = DriverManager.getConnection("jdbc:odbc:ABC");

qrystr="sp_report OpenInvoices show Text, Blank, TxnType, Date, RefNumber, PONumber, Terms, DueDate, Aging, OpenBalance, Memo parameters DateMacro = 'Today'";

Solutions

     Try using VB Demo to establish a connection first. I'm guessing you haven't set unattended mode correctly, see: How to setup QODBC for Auto-login into QuickBooks to add a QuickBooks Data DSN to the specified company file.

     Besides, Java would need a System DSN and hopefully, you have configured the QODBC DCOMs and have the latest Web server edition of QODBC. And QuickBooks must be closed (not running) when you start your JAVA application.