Windows XP SP2, QODBC 7.214 and 7.231, MS Access 2003 SP2, QB 2005 Non-Profit. When executing a simple InvoiceLine insert:
sqlstr="INSERT INTO InvoiceLine ( CustomerRefListID, ClassRefListID, TxnDate, IsToBePrinted, InvoiceLineItemRefListID, InvoiceLineDesc, InvoiceLineRate, InvoiceLineQuantity, InvoiceLineSalesTaxCodeRefListID, FQSaveToCache) VALUES ('23B0001-989528441', '30000-1178651908', #2007-10-05#, 0, '390000-1026172685', 'Item 1', 25, 1, '20000-1102386300', 0)" CurrentDB.Execute(sqlstr).
MS Access threw error 3155 (ODBC Insert failed on ODBC insert) however the invoice was added in QB, making error handling problematic. There was 2 months operation without errors, then every insert caused the error. The client had a deadline so proper error handling was not performed. Upgrade from 7.214 to 7.231 did not fix the problem. An unknown combination of shutting down the applications and deleting invoices in QB "fixed" the problem so that further inserts did not throw the error.
I have not been able to reproduce the problem, so I'm wondering if this kind of behavior has been seen before (Error 3155 on an otherwise successful insert). I wish I had more details to provide, but if and when this problem will reoccur is unknown.
Thank you,
Tom Remmers
|