-
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?
-
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.
-
Originally Posted by
Mdos568
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
-
Forum Rules