Using SQL Server 2005. Database resides on the same machine as QuickBooks and QODBC.
When I attempt to query QODBC, I receive the following error 95% of the time:
Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.)
Query:
I've tried quering select *, I've tried querying a single field as well.
Please help.
select TxnID, TimeCreated, TimeModified, EditSequence, TxnNumber, CustomerRefListID, CustomerRefFullName, ClassRefListID, ClassRefFullName, TemplateRefListID, TemplateRefFullName, TxnDate, TxnDateMacro, RefNumber, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3, BillAddressAddr4, BillAddressCity, BillAddressState, BillAddressPostalCode, BillAddressCountry, ShipAddressAddr1, ShipAddressAddr2, ShipAddressAddr3, ShipAddressAddr4, ShipAddressCity, ShipAddressState, ShipAddressPostalCode, ShipAddressCountry, PONumber, TermsRefListID, TermsRefFullName, DueDate, SalesRepRefListID, SalesRepRefFullName, FOB, ShipDate, ShipMethodRefListID, ShipMethodRefFullName, Subtotal, ItemSalesTaxRefListID, ItemSalesTaxRefFullName, SalesTaxPercentage, SalesTaxTotal, TotalAmount, IsManuallyClosed, IsFullyInvoiced, Memo, CustomerMsgRefListID, CustomerMsgRefFullName, IsToBePrinted, CustomerSalesTaxCodeRefListID, CustomerSalesTaxCodeRefFullName, SalesOrderLineSeqNo, SalesOrderLineGroupTxnLineID, SalesOrderLineGroupItemGroupRefListID, SalesOrderLineGroupItemGroupRefFullName, SalesOrderLineGroupDesc, SalesOrderLineGroupQuantity, SalesOrderLineGroupIsPrintItemsInGroup, SalesOrderLineGroupTotalAmount, SalesOrderLineGroupSeqNo, SalesOrderLineTxnLineID, SalesOrderLineItemRefListID, SalesOrderLineItemRefFullName, SalesOrderLineDesc, SalesOrderLineQuantity, SalesOrderLineRate, SalesOrderLineRatePercent, SalesOrderLinePriceLevelRefListID, SalesOrderLinePriceLevelRefFullName, SalesOrderLineClassRefListID, SalesOrderLineClassRefFullName, SalesOrderLineAmount, SalesOrderLineSalesTaxCodeRefListID, SalesOrderLineSalesTaxCodeRefFullName, SalesOrderLineInvoiced, SalesOrderLineIsManuallyClosed, FQSaveToCache, FQPrimaryKey, CustomFieldSalesOrderLineOther1, CustomFieldSalesOrderLineOther2, CustomFieldSalesOrderLineGroupOther1, CustomFieldSalesOrderLineGroupOther2, CustomFieldSalesOrderLineGroupLineOther1, CustomFieldSalesOrderLineGroupLineOther2, CustomFieldOther, CustomFieldBags, CustomFieldBeverage, CustomFieldCups, CustomFieldDMA, CustomFieldRollingStock, CustomFieldScreens, CustomFieldTrays
from QODBC...SalesOrderLine NOSYNC |
