Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3/4 Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(SQL Server) PKCS7 Decrypt MIMELoads a PKCS7 encrypted MIME file and decrypts. The cert and private key used for decryption is loaded from a PFX file.
CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @sTmp0 nvarchar(4000) DECLARE @mime int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Mime', @mime OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int EXEC sp_OAMethod @mime, 'UnlockComponent', @success OUT, 'Anything for 30-day trial.' IF @success = 0 BEGIN EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mime RETURN END -- Load the MIME EXEC sp_OAMethod @mime, 'LoadMimeFile', @success OUT, 'encryptedMime.txt' IF @success = 0 BEGIN EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mime RETURN END -- The AddPfxSourceFile and/or AddPfxSourceData -- methods may be called one or more times (one per PFX) -- to add sources from which the MIME component will -- search for certificates and private keys when decrypting. DECLARE @pfxPassword nvarchar(4000) SELECT @pfxPassword = 'myPassword' EXEC sp_OAMethod @mime, 'AddPfxSourceFile', @success OUT, 'myCertAndPrivateKey.pfx', @pfxPassword IF @success = 0 BEGIN EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mime RETURN END -- Decrypt... EXEC sp_OAMethod @mime, 'Decrypt', @success OUT IF @success = 0 BEGIN EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mime RETURN END -- Display the decrypted MIME: EXEC sp_OAMethod @mime, 'GetMime', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mime END GO |
© 2000-2016 Chilkat Software, Inc. All Rights Reserved.