SQL Server

Encrypt MIME using PEM Certificate

See more MIME Examples

Encrypt MIME using a PEM certificate. SQL Server

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

    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

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

    -- Create a simple MIME message to be encrypted:
    EXEC sp_OAMethod @mime, 'AddHeaderField', @success OUT, 'Content-Type', 'text/plain'
    EXEC sp_OAMethod @mime, 'AddHeaderField', @success OUT, 'abc', '123'
    EXEC sp_OAMethod @mime, 'SetBody', NULL, 'This is a test'

    DECLARE @cert int
    EXEC @hr = sp_OACreate 'Chilkat.Cert', @cert OUT

    EXEC sp_OAMethod @cert, 'LoadFromFile', @success OUT, 'qa_data/pem/mf_public_rsa.pem'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @cert, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @cert
        RETURN
      END

    -- Encrypt the MIME.
    EXEC sp_OAMethod @mime, 'Encrypt', @success OUT, @cert
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @cert
        RETURN
      END

    -- Display the MIME:
    EXEC sp_OAMethod @mime, 'GetMime', @sTmp0 OUT
    PRINT @sTmp0

    -- The resulting S/MIME looks like this:

    -- Content-Type: application/x-pkcs7-mime; name="smime.p7m"; smime-type="enveloped-data"
    -- abc: 123
    -- Content-Disposition: attachment; filename="smime.p7m"
    -- Content-Transfer-Encoding: base64
    -- 
    -- MIICMAYJKoZIhvcNAQcDoIICITCCAh0CAQAxggGoMIIBpAIBADCBizB3MQswCQYDVQQGEwJQTDEi
    -- MCAGA1UEChMZVW5pemV0byBUZWNobm9sb2dpZXMgUy5BLjEnMCUGA1UECxMeQ2VydHVtIENlcnRp
    -- ZmljYXRpb24gQXV0aG9yaXR5MRswGQYDVQQDExJDZXJ0dW0gTGV2ZWwgSVYgQ0ECEDVuXbie8bb5
    -- sHeajm5k3ZYwDQYJKoZIhvcNAQEBBQAEggEADNac7gEUOvTWfyqwe0cS+m65Lte7ZmDGRElvqeo7
    -- C2+JZJfuxl2Roy+4vTovnn+9U2Yf5Kqc1m2ZPCE5Q8ExvOV4M0cTocLNLK6sfCR7cvo1xgf220qf
    -- XYqWF1/ePuP9j1FrkFvBOoS4BREAnXsEa4zvuhvNPsMfjInK8wWnMftbLUiriAZBq391D+dxxX8M
    -- kB1EHCWaS3H8WQI/caTnkRS6YdOCOrctJHtotkcU+4gcIxfTcq6yeloceURbesAYAvdRbIGszKCQ
    -- FA2sC1x8SkDQCHfNUvmyS/fmkq5waFpmq1ksOspInb4ZM7SOjEUu+22vkAgbTmOS3MUdieuRcTBs
    -- BgkqhkiG9w0BBwEwHQYJYIZIAWUDBAECBBClRoHLQZyzdHwoZA6pZjLYgEChuMzbQRXOjNF3RpnI
    -- ZjNTKFDuhaUqk0rRTTn3D89F7ZMUBtoCP0bw+bH5UE9zpDaAgCF9s3W3/D5YNgAuw4AZ

    EXEC @hr = sp_OADestroy @mime
    EXEC @hr = sp_OADestroy @cert


END
GO