SAP Knowledge Base Article - Preview

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

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 'asename', Procedure 'sp_oledb_getcolumnprivileges', Line 39:
Invalid column name 'predid'.

Msg 7988, Level 16, State 1:
Server 'asename', 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 'asename', 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 'asename', Procedure 'sp_oledb_gettableprivileges', Line 35:
Invalid column name 'predid'.

Msg 7988, Level 16, State 1:
Server 'asename', 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 'asename', 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 for Me (Login required).

Search for additional results

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