(SQL Server) Open Smartcard Certificate Store (or from USB Token)

Demonstrates how to open the certificate store of the smart card currently in the reader (or the USB token). Iterates over the certs found on the smartcard.

Note: This example requires Chilkat v9.5.0.80 or later.

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @certStore int
    -- Use "Chilkat_9_5_0.CertStore" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.CertStore', @certStore OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- To allow Chilkat to automatically choose a CSP,
    -- set the CSP name to the empty string.
    DECLARE @cspName nvarchar(4000)
    SELECT @cspName = ''

    -- Chilkat will choose the 1st 3rd party CSP in the following list
    -- that it finds on the system.  If no 3rd party CSP is found, then
    -- the "Microsoft Base Smart Card Crypto Provider" is automatically chosen
    -- 
    -- Bit4id Universal Middleware Provider
    -- eToken Base Cryptographic Provider
    -- FTSafe ePass1000 RSA Cryptographic Service Provider
    -- EnterSafe ePass2003 CSP v2.0
    -- Gemalto Classic Card CSP
    -- PROXKey CSP India V1.0
    -- PROXKey CSP India V2.0
    -- TRUST KEY CSP V1.0
    -- Watchdata Brazil CSP V1.0
    -- Luna Cryptographic Services for Microsoft Windows
    -- Luna SChannel Cryptographic Services for Microsoft Windows
    -- Safenet RSA Full Cryptographic Provider
    -- nCipher Enhanced Cryptographic Provider
    -- SafeSign Standard Cryptographic Service Provider
    -- SafeSign Standard RSA and AES Cryptographic Service Provider
    -- MySmartLogon NFC CSP
    -- NFC Connector Enterprise
    -- ActivClient Cryptographic Service Provider
    -- EnterSafe ePass2003 CSP v1.0
    -- Athena ASECard Crypto CSP"

    -- To get the list of CSP's on your system, see this example:
    -- List Cryptographic Service Providers (CSP's) on a Windows System

    -- Access the certificates on the smart card via the Chilkat certificate store class.
    DECLARE @success int
    EXEC sp_OAMethod @certStore, 'OpenSmartcard', @success OUT, @cspName
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @certStore, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @certStore
        RETURN
      END

    -- Iterate over certificates on the smartcard.
    DECLARE @i int
    SELECT @i = 0
    DECLARE @numCerts int
    EXEC sp_OAGetProperty @certStore, 'NumCertificates', @numCerts OUT

    PRINT 'numCerts = ' + @numCerts

    WHILE (@i < @numCerts)
      BEGIN
        DECLARE @cert int
        EXEC sp_OAMethod @certStore, 'GetCertificate', @cert OUT, @i
        EXEC sp_OAGetProperty @cert, 'SubjectCN', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @cert

        SELECT @i = @i + 1
      END

    EXEC @hr = sp_OADestroy @certStore


END
GO