Post reply

SQLOLDB version 19 driver not connected database SQL 2016 version.

  • September 8, 2022 at 9:27 am

    #4085312

    HI.

    Destination DB version SQL 2016, So application does not able to connect database. connection string using Provider=sqloledb;

    Error:

    ConStatus Error [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

    Destination DB server windows 2019 version and TLS 1.0 client by default disabled, So I made it enabled as below location in registry setting but not hope and not resolving issues.

    'HKLM:SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0\Client' -Name 'Enabled' -value '00000001'

    Thanks

  • September 8, 2022 at 10:52 am

    #4085341

    Is this a question or just a comment? What do you need?

  • September 9, 2022 at 12:55 pm

    #4085840

    Error:

    ConStatus Error [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.

    In Application server does not connected to database server due to SQLOLDB driver, how to resolve this error?

    Please suggest.

    Thanks

     

  • September 9, 2022 at 1:26 pm

    #4085851

    Are you sure it's the driver causing the issue, rather than the deprecated TLS protocol? You should probably be aiming to use TLS 1.2.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • September 9, 2022 at 6:19 pm

    #4085974

    SQLOLEDB does not support TLS1.2.

    so you need to ensure there is a common protocol on both client and server which can be used is you must use that driver (TLS1.0).

     

    Secondly that driver has been deprecated for decades now (went into depreciation in SQL 2005)

    Upgrade the driver to msoledbsql for TLS1.2 support.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply