Consulting

Results 1 to 3 of 3

Thread: Run-Time Error '-2147217900 (80040e14)': The Certificate, asymmetric key, or private

  1. #1
    VBAX Newbie
    Joined
    Apr 2015
    Posts
    1
    Location

    Run-Time Error '-2147217900 (80040e14)': The Certificate, asymmetric key, or private

    Hi,

    When I am trying to get data from SQL (SCCM 2012 server), but I'm getting error:
    Run-Time Error '-2147217900 (80040e14)': The Certificate, asymmetric key, or private key data is invalid.

    Set cn = New ADODB.Connection
    cn.CommandTimeout = 0
    cn.Open "Provider = SQLOLEDB.1; server=(Server Address); Database=(db name); Trusted_Connection=yes"
    sSql = "Select * FROM DB"
    Set rs = New ADODB.Recordset
    rs.CursorLocation = adUseClient 'who manages the cursor ADO (adUSEclient) or Server (adUseServer)
    rs.Open sSql, cn '// ERROR Apears on this line.

    Sometimes it passes though this line, sometimes it stops and If i press debug and run again it passes.

    Maybe you know where issue could be?

  2. #2
    VBAX Regular Mdos568's Avatar
    Joined
    Mar 2017
    Location
    Sydney
    Posts
    6
    Location
    To work around the issue, do the following to set the Compatibility Level of the Database to 80:

    • In Enterprise Manager, right click the database. Select Properties.
    • Select the Options Tab.
    • Change the Compatibility Level to 80.

  3. #3
    Quote Originally Posted by Mdos568 View Post
    To work around the issue, do the following to set the Compatibility Level of the Database to 80:

    • In Enterprise Manager, right click the database. Select Properties.
    • Select the Options Tab.
    • Change the Compatibility Level to 80.
    Wow thanks. Your fix has worked on a similar error I was encountering

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •