Recently I was inserting a invoiceline through the VB Demo when the QODBC driver and quickbooks locked up. Everthing just froze. Finally I was able to end task on everything. The next time I tried to access the invoiceline or invoice table. Nothing happens.
I run the query in vb demo Select * from invoice
The drive status box says Table name invoice operation Waiting on Quickbooks elapsed time : just keeps ticking away. total records 0 found records 0
then QBSDKMsgSet message freezes here 20080523.080457 I 2684 QBSDKMsgSetHandler QUERY: Invoice 20080523.080457 I 2684 InvoiceStorage::DoQuery Setting iterator chunk size to 00000500
I can not access the vbdemo to disconnect it because it is frozen. The quickbooks application seems to be attempting to do something the hour glass in up during the entire process. The only way to exit out is to end the quickbooks through task manager and then disconnect the vbdemo.
It seems as if the invoiceline table is locked or corrupt. I did reboot of the computer. I did get a list from select * from invoice. I then tried Select * from Invoiceline. The problem occured again locking both queries. If I try with a different company, all is fine. Any suggestions on what this may be.
|