Chilkat HOME .NET Core C# Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi ActiveX Delphi DLL Go Java Lianja Mono C# Node.js Objective-C PHP ActiveX PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift 2 Swift 3,4,5... Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) AES Encryption ECB Mode with PKCS7 PaddingDuplicates the following C# code: public static byte[] DecryptBySymmetricKey(string encryptedText, byte[] key) { string keyAsBase64 = Convert.ToBase64String(key); byte[] dataToDecrypt = Convert.FromBase64String(encryptedText); var keyBytes = key; AesManaged tdes = new AesManaged(); tdes.KeySize = 256; tdes.BlockSize = 128; tdes.Key = keyBytes; tdes.Mode = CipherMode.ECB; tdes.Padding = PaddingMode.PKCS7; ICryptoTransform decrypt__1 = tdes.CreateDecryptor(); byte[] deCipher = decrypt__1.TransformFinalBlock(dataToDecrypt, 0, dataToDecrypt.Length); tdes.Clear(); string EK_result = Convert.ToBase64String(deCipher); return EK_result; }
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls. -- CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- This example requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @crypt int -- Use "Chilkat_9_5_0.Crypt2" for versions of Chilkat < 10.0.0 EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- In the C# code above that is to be duplicated here, use the base64 encoded key. DECLARE @keyAsBase64 nvarchar(4000) SELECT @keyAsBase64 = '...' DECLARE @encryptedBytesAsBase64 nvarchar(4000) SELECT @encryptedBytesAsBase64 = '....' EXEC sp_OASetProperty @crypt, 'KeyLength', 256 EXEC sp_OASetProperty @crypt, 'CryptAlgorithm', 'AES' EXEC sp_OASetProperty @crypt, 'CipherMode', 'ecb' EXEC sp_OASetProperty @crypt, 'PaddingScheme', 0 EXEC sp_OAMethod @crypt, 'SetEncodedKey', NULL, @keyAsBase64, 'base64' EXEC sp_OASetProperty @crypt, 'EncodingMode', 'base64' -- Pass the base64 representation of the encrypted data. -- (The EncodingMode indicates you are passing base64.) DECLARE @EK_result nvarchar(4000) EXEC sp_OAMethod @crypt, 'DecryptStringENC', @EK_result OUT, @encryptedBytesAsBase64 PRINT @EK_result EXEC @hr = sp_OADestroy @crypt END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.