I began getting the error below out of the blue one day while inserting into the Customer table.  I think that this may have something to do with the new Quickbooks patch that came out recently.  I have not changed any of the scripts that perform the insert and I was inserting error free for months, leading me to believe that Intuit changed the interal column names or something like that.  Any insight?

42S00:[QODBC] Column Not Found: Name

Are you talking about the QuickBooks 2006 R7 Update? Suggest you check that you can still access:

SELECT * from Customer

and

SELECT NAME from Customer

using VB Demo.

I have also received the same error using v 7.00.00.207 with QB Enterprise 6.0.

The following query randomly fails with the 42S00 error.

Select EstimateLine.*,Item.Type from EstimateLine left outer JOIN Item ON EstimateLine.EstimateLineItemRefListID = Item.ListID where txnId ='2844-1197764203'  order by EstimateLineSeqNo, EstimateLineGroupSeqNo

Sometime it works and sometimes it doesn't.

Here is the qodbc message log:

2007-02-20 16:19:16 QODBC Ver:  7.00.00.207 *********************************************************************************************************************
IsAService: True
SQL Statement: Select EstimateLine.*,Item.Type from EstimateLine left outer JOIN Item ON EstimateLine.EstimateLineItemRefListID = Item.ListID where txnId = '2844-1197764203' order by EstimateLineSeqNo, EstimateLineGroupSeqNo
Error Getting XML in BuildAndLoadXMLForNextRecord
Input XML:
<?xml version="1.0" encoding="ISO-8859-1"?>
<?qbxml version="5.0"?>
<QBXML>
    <QBXMLMsgsRq onError="continueOnError">
        <ItemQueryRq requestID="1">
            <ListID>
</ListID>
            <IncludeRetElement>ListID</IncludeRetElement>
            <IncludeRetElement>EditSequence</IncludeRetElement>
            <IncludeRetElement>SalesTaxCodeRef</IncludeRetElement>
            <OwnerID>0</OwnerID>
        </ItemQueryRq>
    </QBXMLMsgsRq>
</QBXML>