SQL Server

Load a Private Key from a PKCS #8 File

Demonstrates the Chilkat PrivateKey.LoadPkcs8File method, which loads a private key from a file. The only argument is the file path. Despite the name, it accepts any supported unencrypted private-key representation, not only PKCS #8.

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: PKCS #8 is the modern standard container for a private key of any algorithm (RSA, EC, Ed25519), in DER (binary) or PEM. This method reads the unencrypted form and, helpfully, inspects the content so it also loads other unencrypted representations that happen to be in the file. For an encrypted PKCS #8 file, use LoadPkcs8EncryptedFile.

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.LoadPkcs8File method, which loads a private key from a file.  The
    --  only argument is the file path.  Despite the name, it accepts any supported unencrypted
    --  private-key representation, not only unencrypted PKCS #8.

    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, 'LoadPkcs8File', @success OUT, 'qa_data/private_pkcs8.der'
    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