Symptom
- When using the SQL Anywhere OLE DB Provider (ASAPROV, SAOLEDB), a RecordSet.Open query that is terminated with a semi-colon (;) will return the following exception upon a subsequent ADODB.Recordset.Update operation:
"Insufficient base table information for updating or refreshing."
- For this to occur, ADODB.Recordset.CursorLocation must also be set to 'ADODB.adUseClient'
Read more...
Environment
- SAP SQL Anywhere 16
- SAP SQL Anywhere 12
- SQL Anywhere 11
- SQL Anywhere 10
- SQL Anywhere 9
- SQL Anywhere client
- ADO / OLE DB
- Microsoft Windows (All Versions)
Product
SAP SQL Anywhere all versions ; SQL Anywhere all versions
Keywords
11565291, Sybase , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.