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) URL Signing for Google Maps APIDemonstrates how to sign a URL for the Google Maps API.
// Important: See this note about string length limitations for strings returned by sp_OAMethod calls. // CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int -- This example assumes the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. DECLARE @crypt int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Crypt2', @crypt OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- The output will be modified Base64. -- Modified Base64 for URLs replaces the '+' and '/' characters -- of standard Base64 with '-' and '_' respectively, so that these -- Base64 signatures no longer need to be URL-encoded. EXEC sp_OASetProperty @crypt, 'EncodingMode', 'modBase64' -- Set the hash algorithm to sha-1 EXEC sp_OASetProperty @crypt, 'HashAlgorithm', 'sha-1' DECLARE @sig nvarchar(4000) -- Set the HMAC key (this is the private key provided by Google) EXEC sp_OAMethod @crypt, 'SetHmacKeyEncoded', NULL, 'vNIXE0xscrmjlyV-12Nj_BvUPaw=', 'modBase64' -- Compute the URL signature EXEC sp_OAMethod @crypt, 'HmacStringENC', @sig OUT, '/maps/api/geocode/json?address=New+York&sensor=false&client=clientID' -- The result should be KrU1TzVQM7Ur0i8i7K3huiw3MsA= PRINT @sig EXEC @hr = sp_OADestroy @crypt END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.