DX Infrastructure Manager

Expand all | Collapse all

Missing MSOLEDBSQL driver support

  • 1.  Missing MSOLEDBSQL driver support

    Posted 10-28-2020 08:56 AM
    Hi,

    is it just to me? I'm missing support for the current MSOLEDBSQL driver within the current version.

    According to Microsoft (Microsoft OLE DB Driver for SQL Server - SQL Server)
    the current usable DB drivers of the data_engine (SQLOLEBB) and (SQLNCL) are outdated/depracted.

    Has anyone here seen statements on this from Broadcom?

    Thanks.

    ------------------------------
    Olaf
    ------------------------------


  • 2.  RE: Missing MSOLEDBSQL driver support

    Broadcom Employee
    Posted 10-28-2020 04:17 PM
    My lab shows these:

    The previous Microsoft OLE DB Provider for SQL Server (SQLOLEDB) and SQL Server Native Client OLE DB provider (SQLNCLI) remains deprecated and it is not recommended to use either for new development work.


    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Missing MSOLEDBSQL driver support

    Posted 11-04-2020 05:15 AM
    Hi,

    I understand the Microsoft page "note" that SQLNCLI is deprecated regardless of the version of SQLNCLI.
    A little further down on the page you can find this note:
    »To use the new Microsoft OLE DB Driver for SQL Server in existing applications, you should plan to convert your connection strings from SQLOLEDB or SQLNCLI, to MSOLEDBSQL.«




    ------------------------------
    Olaf
    ------------------------------



  • 4.  RE: Missing MSOLEDBSQL driver support

    Posted 11-09-2020 06:52 AM

    Hi David,

    further investigation shows me that also the SQLNCLI11 driver is not supported.
    As you can read here (https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/support-policies-for-sql-server-native-client?view=sql-server-ver15) and here (https://docs.microsoft.com/en-us/answers/questions/28268/sql-native-client-110-support.html) SQLNCLI11 is only supported up to MS SQL Server 2014, i.e. from MS SQL Server 2016 and newer not supported anymore.
    There seem to be environments where the connections of SQLNCLI11 and SQL 2019 work and environments where this combination does not work.


    Kind regards



    ------------------------------
    Olaf
    ------------------------------



  • 5.  RE: Missing MSOLEDBSQL driver support

    Broadcom Employee
    Posted 11-09-2020 12:43 PM
    Thank you for the further research into this.
    So  SQLNCLI11 is supported only up to SLQ Server 2014, and UIM is supporting 2012, and 2014 so we still need  SQLNCLI11 there.
    This seems to come down to just what your original post is pointing out that UIM is still lacking support for MSOLEDBSQL.
    Have not seen it in the list for the upcoming 20.3.1 so posted it at Ideation.
    https://community.broadcom.com/participate/ideation-home/viewidea?IdeationKey=f026579f-025f-4812-8591-6395f5c0cc7b



    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 6.  RE: Missing MSOLEDBSQL driver support

    Posted 11-10-2020 10:54 AM
    Hi David,

    thanks for posting it as Ideation. I votet it up and hoppefully many others too.


    ------------------------------
    Olaf
    ------------------------------



  • 7.  RE: Missing MSOLEDBSQL driver support

    Broadcom Employee
    Posted 11-10-2020 10:55 AM
    Will also bring it up internally.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 8.  RE: Missing MSOLEDBSQL driver support

    Posted 11-10-2020 10:58 AM
    👍

    ------------------------------
    Olaf
    ------------------------------



  • 9.  RE: Missing MSOLEDBSQL driver support

    Posted 11-16-2020 09:42 AM
    I believe adding this will also fix issues with using windows authentication in sql 2016 in AD 2016 environments

    ------------------------------
    Knows a little about UIM/DXim, AE, Automic
    ------------------------------



  • 10.  RE: Missing MSOLEDBSQL driver support

    Posted 03-11-2021 03:47 AM
    Edited by Olaf Pape 03-11-2021 03:48 AM
    Hi @David Michel,

    long time ago and nothing happens, as far as I can see.
    Is support of MSOLEDBSQL on the roadmap for data_engine and the other probes?
    Is it planned for 20.3.3.?


    ------------------------------
    Olaf Pape
    ------------------------------



  • 11.  RE: Missing MSOLEDBSQL driver support

    Posted 06-23-2021 05:28 AM
    Edited by Olaf Pape 06-23-2021 05:30 AM
    Hi @David Michel​,

    it's been over three months since my last unanswered post and nothing has changed yet. Also the latest version of the data_engine (v20.31) has no change in the supported MS-SQL drivers.
    The issue has been on my radar for over a year, but product support apparently hasn't.

    It would be nice if something changes with this issue and not like with some other problems up to 2 years pass.


  • 12.  RE: Missing MSOLEDBSQL driver support

    Posted 06-29-2021 03:41 AM
    @David Michel Nice that you have changed the title of the ideation, but should the compatibility page be updated to indicate that although Broadcom supports MS-SQL 2016+ but is using unsupported microsoft software to do so! ?

    @Olaf Pape I hope that like mongodb issue, that broadcom realise this issue is not going away and actually address it.

    I hope more people see this and upvote the ideation https://community.broadcom.com/participate/ideation-home/viewidea?IdeationKey=f026579f-025f-4812-8591-6395f5c0cc7b as this is going to become more of a problem as  we try to identify the risk for changes and updates to UIM

    Regards, Andrew
    ​​

    ------------------------------
    Knows a little about UIM/DXim, AE, Automic
    ------------------------------



  • 13.  RE: Missing MSOLEDBSQL driver support

    Broadcom Employee
    Posted 06-29-2021 08:12 AM
    The product manager is having development look into this.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 14.  RE: Missing MSOLEDBSQL driver support

    Broadcom Employee
    Posted 07-21-2021 08:26 AM
    A feature has been added for this so it is now in the backlog and will be addressed.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 15.  RE: Missing MSOLEDBSQL driver support

    Posted 07-21-2021 08:43 AM
    Thanks @David Michel for keeping us updated.​


  • 16.  RE: Missing MSOLEDBSQL driver support

    Posted 07-22-2021 02:48 AM
    @David Michel as this in the backlog does it have a estimate or target release defined yet, as I would like to add this to our risk log as part of the update (as accepted change by Broadcom).

    Thanks, Andrew


    ------------------------------
    Knows a little about UIM/DXim, AE, Automic
    ------------------------------



  • 17.  RE: Missing MSOLEDBSQL driver support

    Broadcom Employee
    Posted 07-22-2021 01:41 PM
    Can't say.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------