Updating data with ADO and Client Access ODBC Driver

[Guest.Visitor]

I am trying to update data on our AS/400 with ADO 2.1 using the ODBC OLE DB Provider and the Client Access ODBC Driver. No matter what I try it always fails on the update call. The most common errors involve 'Insufficient base table information' or 'Cannot update because not a plain table specified in the FROM clause'. If anyone has come accross this before and knows a solution it would be greatly appreciated.

[Guest.Visitor]

Matthew, I'd like to see your Update Statement (SQL). Bill

[Guest.Visitor]

I am attempting to use cursor based updating. From what I have read on the client access web page, this is supposed to be possible when using the OLE DB provider for ODBC sources however they provide no information on how to do this. I have no problems creating the recordset however when I call recordset.update, an error is thrown. When I use client side cursors this error is "Insufficient base table information for updating or refreshing". When I use server side cursors the error is "The query is not updateable because the from clause is not a single simple table name". I have tried usign different settings to overcome this problem such as using different cursor types as well as opening the recordset using only the adCmdTable and adCmdTableDirect rather than asCmdText. The problem appears to be with the Client Access ODBC driver or the way I have configured it as I have been able to update using other ODBC drivers such as the Microsoft Access one. I was hoping someone out there would know if this is possible and if so, how?