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) Get Base64 Public Key from Private KeyDemonstrates how to get the public key in base64 format from a private key.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls. // CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @iTmp0 int DECLARE @sTmp0 nvarchar(4000) -- Load a private key from base64. DECLARE @bd int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.BinData', @bd OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int EXEC sp_OAMethod @bd, 'AppendEncoded', @success OUT, 'MHQCA....n0Q==', 'base64' DECLARE @privKey int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.PrivateKey', @privKey OUT EXEC sp_OAMethod @privKey, 'LoadAnyFormat', @success OUT, @bd, '' IF @success = 0 BEGIN EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @bd EXEC @hr = sp_OADestroy @privKey RETURN END DECLARE @pubKey int EXEC sp_OAMethod @privKey, 'GetPublicKey', @pubKey OUT EXEC sp_OAGetProperty @privKey, 'LastMethodSuccess', @iTmp0 OUT IF @iTmp0 = 0 BEGIN EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @bd EXEC @hr = sp_OADestroy @privKey RETURN END DECLARE @pubKeyBase64 nvarchar(4000) EXEC sp_OAMethod @pubKey, 'GetEncoded', @pubKeyBase64 OUT, 1, 'base64' PRINT @pubKeyBase64 EXEC @hr = sp_OADestroy @pubKey EXEC @hr = sp_OADestroy @bd EXEC @hr = sp_OADestroy @privKey END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.