2-Key Triple DES

Demonstrates 2-Key Triple DES encryption (112-bit 3DES encryption).

Download Chilkat Crypt ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @crypt int
    EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    EXEC sp_OAMethod @crypt, 'UnlockComponent', @success OUT, 'Anything for 30-day trial.'
    IF @success <> 1
      BEGIN
        PRINT 'Crypt component unlock failed'
        RETURN
      END

    --  Specify 3DES for the encryption algorithm:
    EXEC sp_OASetProperty @crypt, 'CryptAlgorithm', '3des'

    EXEC sp_OASetProperty @crypt, 'CipherMode', 'ecb'

    --  For 2-Key Triple-DES, use a key length of 128
    --  (Given that each byte's msb is a parity bit, the strength is really 112 bits).
    EXEC sp_OASetProperty @crypt, 'KeyLength', 128

    --  Pad with zeros
    EXEC sp_OASetProperty @crypt, 'PaddingScheme', 3

    --  EncodingMode specifies the encoding of the output for
    --  encryption, and the input for decryption.
    --  It may be "hex", "url", "base64", or "quoted-printable".
    EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'

    --  Let's create a secret key by using the MD5 hash of a password.
    --  The Digest-MD5 algorithm produces a 16-byte hash (i.e. 128 bits)
    EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'md5'
    DECLARE @keyHex nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'HashStringENC', @keyHex OUT, 'secretPassword'

    --  Set the encryption key:
    EXEC sp_OAMethod @crypt, 'SetEncodedKey', NULL, @keyHex, 'hex'

    --  Encrypt
    DECLARE @encStr nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'EncryptStringENC', @encStr OUT, 'The quick brown fox jumped over the lazy dog'
    PRINT @encStr

    --  Now decrypt:
    DECLARE @decStr nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'DecryptStringENC', @decStr OUT, @encStr
    PRINT @decStr
END
GO