SQL Server

Save a Public Key as a PEM File

Demonstrates the Chilkat PublicKey.SavePemFile method, which saves the public key in PEM format. The first argument selects the representation and PEM label, and the second is the destination path.

Note: The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background: PEM is the most widely accepted public-key file format, so this is the usual way to write a key for distribution or for tools that expect a .pem. Choose false for the modern PUBLIC KEY (SubjectPublicKeyInfo) label in most cases, or true for the legacy RSA-specific label when required.

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

    --  Load a public key to export.  LoadFromFile inspects the content, so it accepts DER, PEM, XML,
    --  JWK, and other supported representations.
    DECLARE @pubKey int
    EXEC @hr = sp_OACreate 'Chilkat.PublicKey', @pubKey OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @pubKey, 'LoadFromFile', @success OUT, 'qa_data/public.pem'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @pubKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @pubKey
        RETURN
      END

    --  Save the public key in PEM format.  The 1st argument selects the representation and PEM label,
    --  and the 2nd is the destination path.
    DECLARE @preferPkcs1 int
    SELECT @preferPkcs1 = 0
    EXEC sp_OAMethod @pubKey, 'SavePemFile', @success OUT, @preferPkcs1, 'qa_output/public.pem'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @pubKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @pubKey
        RETURN
      END

    PRINT 'Saved.'

    EXEC @hr = sp_OADestroy @pubKey


END
GO