I’m working with QuickBooks Pro2005.  I’ve had nothing but problems with the QODBC driver ever since it was installed back in March.  The current problem goes a little like this.  I open the Access reporting program ask it to “Refresh info from QB” then the QODBC asks me for my password (which it’s never done before) then it asks a second and a third time and then it closes the application, then nothing.  It used to not ask for my password but give me an error that said “QODBC—connection to ‘QuickBooks_NAData’ failed.”  My third problem is that we purchased for 5 users.  One of the computers is no longer useable and I’d like to know how to get it on another computer.

also receiving "action failed" messages with Erro #10004

Use VB Demo to check that your "QuickBooks_NAData" DSN is still configured correctly. See: How do I use the VB Demo for testing? 

See also: How do I connect to QuickBooks for the first time? 

Okay, if I test it the way it tells me to and use QuickBooks Data then it works.  If I test it using QB NAData the it does the say as when I'm trying to use it.  It asks me for my password about three times and then nothing

  I'm getting new errors when I try to run the report ........

QOBBC call Failed

QODBC -- Error #10004

Okay, if I go thru all that and then test the connection to QB it says it's fine.  But when I go to actualy run it I'm still getting error #10004.  And if I run the message log it looks like this.........

2006-07-25 08:09:34 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error = 80040416, If QuickBooks is not running, a call to the "BeginSession" method must include the name of the QuickBooks company data file.
Begin Session errors can be caused when running ASP or other system service and not setting the "Advanced" button option of either "Use DCOM Servers" or "Remote Connector"

2006-07-25 08:11:32 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
SQLOptimize_OpenOptimizeDBHandle Company Name or Optimizer Version do not match:
Baseline Engineering Corporation
not an error

2006-07-25 08:12:54 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2006-07-26 14:52:50 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2006-07-26 14:52:52 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2006-07-26 14:53:58 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2006-07-28 16:46:21 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 151 - Authorization Required

2006-07-28 16:47:12 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 151 - Authorization Required

2006-07-28 17:10:05 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 151 - Authorization Required

2006-07-28 17:10:30 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2006-07-28 17:13:50 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT "ListID" ,"Entity"."ListID" FROM "Entity" WHERE (("Type" = 'Employee' ) AND NOT(({fn right("FullName" ,7 )}= '-Markup' ) ) )
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="4.1"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <EntityQueryRq requestID="1">
            <MaxReturned>00001000</MaxReturned>
            <ActiveStatus>All</ActiveStatus>
            <NameRangeFilter>
                <>
                </>
        </NameRangeFilter>
        <IncludeRetElement>ListID</IncludeRetElement>
        <IncludeRetElement>EditSequence</IncludeRetElement>
        <IncludeRetElement>FullName</IncludeRetElement>
        <IncludeRetElement>Name</IncludeRetElement>
    </EntityQueryRq>
</QBXMLMsgsRq>
</QBXML>

2006-07-28 17:20:03 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT "ListID" ,"Entity"."ListID" FROM "Entity" WHERE (("Type" = 'Employee' ) AND NOT(({fn right("FullName" ,7 )}= '-Markup' ) ) )
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="4.1"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <EntityQueryRq requestID="1">
            <MaxReturned>00001000</MaxReturned>
            <ActiveStatus>All</ActiveStatus>
            <NameRangeFilter>
                <>
                </>
        </NameRangeFilter>
        <IncludeRetElement>ListID</IncludeRetElement>
        <IncludeRetElement>EditSequence</IncludeRetElement>
        <IncludeRetElement>FullName</IncludeRetElement>
        <IncludeRetElement>Name</IncludeRetElement>
    </EntityQueryRq>
</QBXMLMsgsRq>
</QBXML>

2006-07-29 07:44:31 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2006-07-29 07:44:33 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. Error Calling OpenQBConnection Returned Error: 10061 - [10061] Connection refused

2006-07-29 07:49:57 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT "ListID" ,"Entity"."ListID" FROM "Entity" WHERE (("Type" = 'Employee' ) AND NOT(({fn right("FullName" ,7 )}= '-Markup' ) ) )
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="4.1"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <EntityQueryRq requestID="1">
            <MaxReturned>00001000</MaxReturned>
            <ActiveStatus>All</ActiveStatus>
            <NameRangeFilter>
                <>
                </>
        </NameRangeFilter>
        <IncludeRetElement>ListID</IncludeRetElement>
        <IncludeRetElement>EditSequence</IncludeRetElement>
        <IncludeRetElement>FullName</IncludeRetElement>
        <IncludeRetElement>Name</IncludeRetElement>
    </EntityQueryRq>
</QBXMLMsgsRq>
</QBXML>

2006-07-31 09:19:52 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2006-07-31 09:19:55 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2006-07-31 09:22:02 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2006-07-31 09:22:05 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
Begin Session Failed. S0000 00000 [QODBC] QB Begin Session Failed. User Canceled

2006-08-01 14:43:36 QODBC Ver:  6.00.00.150 *********************************************************************************************************************
IsAService: False
SQL Statement: SELECT "ListID" ,"Entity"."ListID" FROM "Entity" WHERE (("Type" = 'Employee' ) AND NOT(({fn right("FullName" ,7 )}= '-Markup' ) ) )
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="4.1"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <EntityQueryRq requestID="1">
            <MaxReturned>00001000</MaxReturned>
            <ActiveStatus>All</ActiveStatus>
            <NameRangeFilter>
                <>
                </>
        </NameRangeFilter>
        <IncludeRetElement>ListID</IncludeRetElement>
        <IncludeRetElement>EditSequence</IncludeRetElement>
        <IncludeRetElement>FullName</IncludeRetElement>
        <IncludeRetElement>Name</IncludeRetElement>
    </EntityQueryRq>
</QBXMLMsgsRq>
</QBXML>

Yes, often there's two once you start using auto-login.

See also: What is error: 3260 (“Insufficient permission level to perform this action”)?