Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
QODBC Error Database Vendor Code 10004 using QBOE |
Author |
Message |
|
Posted : 2007-05-22 08:58:18 |
I am getting a QODBC Error 42S00 Database Vendor Code 10004
Here is the log
2007-05-21 17:21:57 QODBC Ver: 7.00.00.214 ********************************************************************************************************************* IsAService: False SQL Statement: SELECT "Bill"."VendorRefFullName", "Bill"."TxnDate", "Bill"."RefNumber", "Bill"."AmountDue" FROM "Bill" "Bill" ORDER BY "Bill"."VendorRefFullName" Error Getting XML in BuildAndLoadXMLForNextRecord Input XML: <?xml version="1.0" encoding="ISO-8859-1"?> <!DOCTYPE QBXML PUBLIC '-//INTUIT//DTD QBXML QBO 6.0//EN' 'http://apps.quickbooks.com/dtds/qbxmlops60.dtd'> <QBXML> <SignonMsgsRq> <SignonTicketRq requestID="0"> <ClientDateTime>2007-05-21T17:21:26</ClientDateTime> <SessionTicket>V1-204-Jmddaf8jBZlLtDjnXPy4Rw:107328049</SessionTicket> <Language>English</Language> <AppID>71271511</AppID> <AppVer>1.0</AppVer> </SignonTicketRq> </SignonMsgsRq> <QBXMLMsgsRq onError="continueOnError"> <BillQueryRq requestID="1"> <MaxReturned>00001000</MaxReturned> </BillQueryRq> </QBXMLMsgsRq> </QBXML>
I also checked the QODBC V 7.00.00.214, which indiates I have the latest.
What is causing this?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-05-24 15:51:15 |
You are using the QuickBooks Online Edition which will not return any results for any query that results with over 1000 rows being returned. Try limiting your query to a smaller date subset of your Bills instead of all Bills like this:
SELECT "Bill"."VendorRefFullName", "Bill"."TxnDate", "Bill"."RefNumber", "Bill"."AmountDue" FROM "Bill" "Bill" WHERE "Bill"."TxnDate" > {d '2007-01-01'} ORDER BY "Bill"."VendorRefFullName"
|
|
|
|
|