SAP Knowledge Base Article - Preview

2105759 - Error: "Insufficient base table information for updating or refreshing." when using the SQL Anywhere OLE DB Provider

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.