SQL Server

Load a Private Key from an XML File

Demonstrates the Chilkat PrivateKey.LoadXmlFile method, which loads a private key from an XML file. The only argument is the file path. Chilkat recognizes RSA, DSA, EC, and Ed25519 XML produced by GetXml, and auto-detects other supported unencrypted representations.

Note: The file path is relative to the application's current working directory. Absolute paths may also be used. Supply the path to your own key file.

Background: The file-based form of LoadXml, for a key saved as an XML file — typically one written by SaveXmlFile or exported from .NET. Because it also inspects the content, it will load other unencrypted representations if the file turns out not to be XML.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Demonstrates the PrivateKey.LoadXmlFile method, which loads a private key from an XML file.  The
    --  only argument is the file path.  Chilkat recognizes RSA, DSA, EC, and Ed25519 XML produced by
    --  GetXml, and auto-detects other supported unencrypted representations.

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

    EXEC sp_OAMethod @privKey, 'LoadXmlFile', @success OUT, 'qa_data/private_key.xml'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @privKey
        RETURN
      END


    EXEC sp_OAGetProperty @privKey, 'KeyType', @sTmp0 OUT

    PRINT 'Loaded a ' + @sTmp0 + ' private key.'

    EXEC @hr = sp_OADestroy @privKey


END
GO