DX Infrastructure Manager

Expand all | Collapse all

Missing MSOLEDBSQL driver support

  • 1.  Missing MSOLEDBSQL driver support

    Posted 30 days ago
    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 30 days ago
    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 23 days ago
    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 18 days ago

    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 18 days ago
    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 17 days ago
    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 17 days ago
    Will also bring it up internally.

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



  • 8.  RE: Missing MSOLEDBSQL driver support

    Posted 17 days ago
    👍

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



  • 9.  RE: Missing MSOLEDBSQL driver support

    Posted 11 days ago
    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
    ------------------------------