SAP Knowledge Base Article - Preview

3656556 - Error 456 for readonly connection when adding 'set rowcount' - SAP ASE

Symptom

  • Error 456 is reported
  • When a connection with 'set readonly on'
  • Tries to set rowcount option as well:

    set readonly on
    go
    set rowcount 10
    go

    Msg 456, Level 16, State 1:
    Server 'ASE', Line 1:
    Failed to execute SET ROW COUNT, because this is a read-only connection.
    Read-only connections can only execute SELECT statements.
    Use 'set readonly off' to execute SET ROW COUNT.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP04
  • SAP Adaptive Server Enterprise (ASE) 16.1

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.