Add PFX Bytes as a Decryption Source

See more MIME Examples

Loads a CMS/PKCS #7 encrypted S/MIME message and decrypts it back to the original MIME content.

AddPfxSourceBd registers PFX/P12 bytes held in a BinData as a source of certificates and private keys for later decryption.

The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    DECLARE @mime int
    EXEC @hr = sp_OACreate 'Chilkat.Mime', @mime OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @mime, 'LoadMimeFile', @success OUT, 'qa_data/encrypted.eml'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        RETURN
      END

    --  Add PFX/P12 bytes (from a BinData) as a source of certificates and private keys for later
    --  decryption.  The 1st argument is the BinData and the 2nd is the password (from a secure source).
    DECLARE @bdPfx int
    EXEC @hr = sp_OACreate 'Chilkat.BinData', @bdPfx OUT

    EXEC sp_OAMethod @bdPfx, 'LoadFile', @success OUT, 'qa_data/recipient.pfx'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @bdPfx, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @bdPfx
        RETURN
      END

    DECLARE @pfxPassword nvarchar(4000)
    SELECT @pfxPassword = 'myPfxPassword'
    EXEC sp_OAMethod @mime, 'AddPfxSourceBd', @success OUT, @bdPfx, @pfxPassword
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @bdPfx
        RETURN
      END

    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
        EXEC @hr = sp_OADestroy @bdPfx
        RETURN
      END

    PRINT 'Decrypted.'

    EXEC @hr = sp_OADestroy @mime
    EXEC @hr = sp_OADestroy @bdPfx


END
GO