Hello, I am getting this error when doing an update to the customer table:
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The OLE DB provider "MSDASQL" for linked server "QODBC" could not UPDATE table "[QODBC]...[customer]". Unknown provider error.".
I am able to READ from the customer table fine, its just when I goto UPDATE that it gives this error.
Here is my update command:
update QODBC...customer set name = ? where ListID = ?
( i have traced and the data going in is OK ,... i,e, valid ? and ? ) )
This is the error I have from the QODBC trace file:
20080710.140955 I 3636 CustomerStorage::DoQuery Setting iterator chunk size to 00000500 20080710.140955 I 3636 QBSDKMsgSetHandler Request 1 completed successfully. 20080710.140955 I 3636 MsgSetHandler Finished. 20080710.140955 I 3636 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3184), ret = 0. 20080710.140955 I 3636 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3184). 20080710.140956 I 3636 SpecVersion Current version of qbXML in use: 6.0 20080710.140956 I 3636 QBSDKMsgSetHandler QUERY: List Delete 20080710.140956 I 3636 QBSDKMsgSetHandler Request 1 completed successfully. 20080710.140956 I 3636 MsgSetHandler Finished. 20080710.140956 I 3636 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3184), ret = 0. 20080710.140956 I 3636 QBSDKProcessRequest Application named 'FLEXquarters QODBC' starting requests (process 3184). 20080710.140957 E 3636 TagDefs Lookup: looking for CurrencyRef, but not found! 20080710.140957 W 3636 QBNCustomerQueryRq::AddIncludeRetElement IncludeRetElement specified unknown tag 'CurrencyRef'. 20080710.140957 E 3636 TagDefs Lookup: looking for IsUsingCustomerTaxCode, but not found! 20080710.140957 W 3636 QBNCustomerQueryRq::AddIncludeRetElement IncludeRetElement specified unknown tag 'IsUsingCustomerTaxCode'. 20080710.140957 I 3636 SpecVersion Current version of qbXML in use: 6.0 20080710.140957 I 3636 QBSDKMsgSetHandler QUERY: Customer Job 20080710.140957 I 3636 QBSDKMsgSetHandler Request 1 completed successfully. 20080710.140957 I 3636 MsgSetHandler Finished. 20080710.140957 I 3636 QBSDKProcessRequest Application named 'FLEXquarters QODBC' finishing requests (process 3184), ret = 0. 20080710.141002 I 3184 RequestProcessor "EndSession" has not been called. 20080710.141002 I 3184 RequestProcessor "CloseConnection" has not been called. 20080710.141102 I 3184 RequestProcessor "EndSession" has not been called. 20080710.141102 I 3184 RequestProcessor "CloseConnection" has not been called.
Any suggetions greatly appreciated.
B.
|