Dear Support,
We are using QODBC Driver 7.0.0214. We have execute a query “Select * From Invoices” using VB Demo on one of our client QuickBooks 2007 Canadian Edition Database. But QODBC unable to retrieve any records even though there are many invoices exits in QuickBooks. The QODBC gives the same results when we execute query on InvoiceLine, Purchase Order and Purchase Order Line Tables.
The below is error log in QODBC SDK Message Log File.
20070605.190440 I 2516 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 1404).
20070605.190440 I 2516 SpecVersion Current version of qbXML in use: CA3.0
20070605.190440 I 2516 QBSDKMsgSetHandler QUERY: Invoice
20070605.190440 I 2516 InvoiceStorage::DoQuery Returning no more than 00000500 invoices
20070605.190442 E 2516 StorageInterface *** UNKNOWN EXCEPTION THROWN WHEN PROCESSING THE QUERY REQUEST ***. This is an indication of a possible internal QBXML error.
20070605.190442 I 2516 QBSDKMsgSetHandler Request 1 failed.
20070605.190443 I 2516 MsgSetHandler Finished.
20070605.190443 I 2516 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 1404), ret = 0.
Please Advice!
Sincerely,
Clifford
|