1881345 - SDK 15.7 MDA script causes errors when executed vs pre ASE 15.7 ESD#2 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1881345 - SDK 15.7 MDA script causes errors when executed vs pre ASE 15.7 ESD#2

Symptom

  • Errors generated when executing the oledb_mda_157.sql script script on ASE 15.7 ESD#2 and above

Msg 207, Level 16, State 4:
Server 'ASE1570', Procedure 'sp_oledb_getcolumnprivileges', Line 39:
Invalid column name 'predid'.

Msg 7988, Level 16, State 1:
Server 'ASE1570', Procedure 'sp_procxmode', Line 159:
The specified object 'sp_oledb_getcolumnprivileges' is not found in database
'sybsystemprocs'.  Check sysobjects to make sure you own the object.
(return status = 1)

Msg 208, Level 16, State 2:
Server 'ASE1570', Line 1:
sp_oledb_getcolumnprivileges not found. Specify owner.objectname or use sp_help
to check whether the object exists (sp_help may produce lots of output).

Msg 207, Level 16, State 4:
Server 'ASE1570', Procedure 'sp_oledb_gettableprivileges', Line 35:
Invalid column name 'predid'.

Msg 7988, Level 16, State 1:
Server 'ASE1570', Procedure 'sp_procxmode', Line 159:
The specified object 'sp_oledb_gettableprivileges' is not found in database
'sybsystemprocs'.  Check sysobjects to make sure you own the object.
(return status = 1)

Msg 208, Level 16, State 2:
Server 'ASE1570', Line 1:sp_oledb_gettableprivileges
not found. Specify owner.objectname or use sp_help
to check whether the object exists (sp_help may produce lots of output).


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)15.7 ESD#2 and higer
  • SAP Sybase Software Developer Kit (SDK) 15.7 ESD xxx
  • SAP Sybase Software Developer Kit (SDK) 15.7 SPxxx
  • install_oledb_sprocs (script in question oledb_mda_157.sql)

Product

SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK 15.7 ; Sybase Software Developer Kit 15.7

Keywords

KBA , BC-SYB-SDK , SDK , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.