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) Use CSP to Load Certificate from Smartcard in Reader (or from USB Token)Demonstrates how to load the certificate that is on the smartcard currently inserted into the smartcard reader. (Also can load the smartcard on a USB token.) Note: This example requires Chilkat v9.5.0.77 or later.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls. // CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @sTmp0 nvarchar(4000) -- This example requires that we already know the name of the CSP (Cryptographic Service Provider) for the smartcard. -- It is often the "Microsoft Base Smart Card Crypto Provider". You can see what CSP's are registered on your system with this code: DECLARE @csp int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Csp', @csp OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @st int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringTable', @st OUT DECLARE @success int EXEC sp_OAMethod @csp, 'GetProviders', @success OUT, @st IF @success = 0 BEGIN EXEC sp_OAGetProperty @csp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @csp EXEC @hr = sp_OADestroy @st RETURN END -- Iterate over the CSP names.. DECLARE @i int SELECT @i = 0 DECLARE @numProviders int EXEC sp_OAGetProperty @st, 'Count', @numProviders OUT WHILE @i < @numProviders BEGIN EXEC sp_OAMethod @st, 'StringAt', @sTmp0 OUT, @i PRINT @i + ': ' + @sTmp0 SELECT @i = @i + 1 END -- Some common CSP names are: -- Microsoft Base Smart Card Crypto Provider -- 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</li> -- MySmartLogon NFC CSP</li> -- NFC Connector Enterprise</li> -- ActivClient Cryptographic Service Provider</li> -- EnterSafe ePass2003 CSP v1.0</li> -- Athena ASECard Crypto CSP" -- Create a Csp object and set the ProviderName equal to our desired CSP name. -- (setting the ProviderName selects the desired CSP.) EXEC sp_OASetProperty @csp, 'ProviderName', 'Microsoft Base Smart Card Crypto Provider' -- Load the certificate on this CSP.. DECLARE @cert int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Cert', @cert OUT EXEC sp_OAMethod @csp, 'LoadSmartcardCert', @success OUT, @cert IF @success = 0 BEGIN EXEC sp_OAGetProperty @csp, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @csp EXEC @hr = sp_OADestroy @st EXEC @hr = sp_OADestroy @cert RETURN END EXEC sp_OAGetProperty @cert, 'SubjectCN', @sTmp0 OUT PRINT 'Cert loaded from smartcard or USB token: ' + @sTmp0 EXEC @hr = sp_OADestroy @csp EXEC @hr = sp_OADestroy @st EXEC @hr = sp_OADestroy @cert END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.