SAP Knowledge Base Article - Preview

3713229 - "ADO.NET MDA" Scripts remain the same after downgrade. - SAP ASE

Symptom

  • It was noted that upgrading to ASE 16.0 SP04 PL01 or higher "sp_version" is showing "OLEDB MDA" Scripts along with "ADO.NET" MDA Scripts. 
  • If it is a new installation on ASE 16.0 SP02, "sp_version" only shows "OLEDB MDA" Scripts.
  • However, if it's downgraded from ASE 16.0 SP04 PL01 or higher,  "ADO.NET MDA" Scripts remaines in "sp_version".
  • For example:
      • ASE downgraded  from ASE 16.0 SP04 PL01 to ASE 16.0 SP02 PL04

        sp_version
        go

        Script Version Status
        ------------------- ---------------------------------------------------------------------------------------------------------------------- --------
        ADO.NET MDA Scripts 16.0.04.07.1020/Fri Mar 21 UTC 07:54:25 2025 Complete
        ODBC MDA Scripts 16.0.02.04.1016/Fri May 13 UTC 03:01:05 2016 Complete
        OLEDB MDA Scripts 16.0.02.04.1016/Fri May 13 UTC 03:01:05 2016 Complete
        ...
        ...
        (8 rows affected)
      • Whereas, a New installation ASE 16.0 SP02 PL04, shows:

        sp_version
        go

        Script Version Status
        ------------------- ---------------------------------------------------------------------------------------------------------------------- --------
        ODBC MDA Scripts 16.0.02.04.1016/Fri May 13 UTC 03:01:05 2016 Complete
        OLEDB MDA Scripts 16.0.02.04.1016/Fri May 13 UTC 03:01:05 2016 Complete


Read more...

Environment

  • SAP Adaptive Server Enterprise 16.0 
  • SDK for SAP Adaptive Server Enterprise 16.0 

Product

SAP Adaptive Server Enterprise 16.0

Keywords

installmaster,OLE DB  , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.