Chilkat HOME Android™ Classic ASP C C++ C# Mono C# .NET Core C# C# UWP/WinRT DataFlex Delphi ActiveX Delphi DLL Visual FoxPro Java Lianja MFC Objective-C Perl PHP ActiveX PHP Extension PowerBuilder PowerShell PureBasic CkPython Chilkat2-Python Ruby SQL Server Swift 2 Swift 3/4 Tcl Unicode C Unicode C++ Visual Basic 6.0 VB.NET VB.NET UWP/WinRT VBScript Xojo Plugin Node.js Excel Go
(SQL Server) GMail IMAP Authentication using OAuth2 Access TokenDemonstrates how to do IMAP OAuth2 authentication for GMail (or any other IMAP mail server supporting OAuth2 authentication). This example assumes an OAuth2 access token was previously obtained.
CREATE PROCEDURE ChilkatSample AS BEGIN DECLARE @hr int DECLARE @sTmp0 nvarchar(4000) -- This example requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. -- See Get GMail IMAP OAuth2 Access Token for Desktop App -- for sample code showing how to obtain a GMail IMAP read/write access token. -- In this example, our access token was previously saved to the following file which contains JSON like this: -- { -- "access_token": "ya39.Ci-XA_C5bGgRDC3UaD-h0_NeL-DVIQnI2gHtBBBHkZzrwlARkwX6R3O0PCDEzRlfaQ", -- "token_type": "Bearer", -- "expires_in": 3600, -- "refresh_token": "1/r_2c_7jddspcdfesrrfKqfXtqo08D6Q-gUU0DsdfVMsx0c" -- } -- DECLARE @json int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END DECLARE @success int EXEC sp_OAMethod @json, 'LoadFile', @success OUT, 'qa_data/tokens/_gmailFullAccess.json' IF @success <> 1 BEGIN PRINT 'Failed to load GMail access token file.' EXEC @hr = sp_OADestroy @json RETURN END DECLARE @accessToken nvarchar(4000) EXEC sp_OAMethod @json, 'StringOf', @accessToken OUT, 'access_token' -- Do OAuth2 authentication by using the access token as the password in the Login method below... DECLARE @imap int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Imap', @imap OUT EXEC sp_OASetProperty @imap, 'Ssl', 1 EXEC sp_OASetProperty @imap, 'Port', 993 -- Connect to the GMail IMAP server. EXEC sp_OAMethod @imap, 'Connect', @success OUT, 'imap.gmail.com' IF @success <> 1 BEGIN EXEC sp_OAGetProperty @imap, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @json EXEC @hr = sp_OADestroy @imap RETURN END -- Indicate that XOAUTH2 authentication is to be used: EXEC sp_OASetProperty @imap, 'AuthMethod', 'XOAUTH2' -- Login -- Use the email address of the GMail account that granted authorization. EXEC sp_OAMethod @imap, 'Login', @success OUT, 'user@gmail.com', @accessToken IF @success <> 1 BEGIN EXEC sp_OAGetProperty @imap, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 END ELSE BEGIN PRINT 'Successfully authenticate with GMail IMAP using XOAUTH2!' END EXEC @hr = sp_OADestroy @json EXEC @hr = sp_OADestroy @imap END GO |
© 2000-2019 Chilkat Software, Inc. All Rights Reserved.