Gmail SMTP: Send with OAuth2 on Port 465
Send email through Gmail with implicit TLS on port 465 and OAuth2. Set SmtpSsl=true and StartTLS=false. This replaces the old ordinary-password example while preserving its URL.
This sends a real message. Set the From address to the authorized mailbox or a permitted send-as identity and use a recipient you control. SMTP acceptance does not guarantee delivery. Gmail sending limits still apply. After an uncertain submission, verify the outcome before retrying.
First authorize the mailbox for https://mail.google.com/ and refresh the token as needed. Read the current token from gmail-mail-token.json in a private working directory. Narrow Gmail REST scopes do not authorize these protocols. Keep the token and authentication logs private.
See the Gmail SMTP, IMAP, and POP3 guide for current authentication choices and Gmail-specific examples.
Chilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
DECLARE @iTmp1 int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- Assumes Chilkat is unlocked. See Global Unlock Sample.
DECLARE @token int
EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @token OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
EXEC sp_OAMethod @token, 'LoadFile', @success OUT, 'gmail-mail-token.json'
IF @success <> 1
BEGIN
PRINT 'Could not read gmail-mail-token.json from the private working directory.'
EXEC @hr = sp_OADestroy @token
RETURN
END
EXEC sp_OAMethod @token, 'JsonTypeOf', @iTmp0 OUT, 'access_token'
EXEC sp_OAMethod @token, 'StringOfEquals', @iTmp1 OUT, 'access_token', '', 1
IF (@iTmp0 <> 1) or (@iTmp1 = 1)
BEGIN
PRINT 'An OAuth access token is required. Authorize or refresh the account first.'
EXEC @hr = sp_OADestroy @token
RETURN
END
DECLARE @mailbox nvarchar(4000)
SELECT @mailbox = 'user@example.com'
DECLARE @mailman int
EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT
EXEC sp_OASetProperty @mailman, 'SmtpHost', 'smtp.gmail.com'
EXEC sp_OASetProperty @mailman, 'SmtpPort', 465
EXEC sp_OASetProperty @mailman, 'SmtpSsl', 1
EXEC sp_OASetProperty @mailman, 'StartTLS', 0
EXEC sp_OASetProperty @mailman, 'RequireSslCertVerify', 1
-- Alternative: port 587 with SmtpSsl=false and StartTLS=true.
EXEC sp_OASetProperty @mailman, 'SmtpUsername', @mailbox
EXEC sp_OASetProperty @mailman, 'SmtpPassword', ''
EXEC sp_OAMethod @token, 'StringOf', @sTmp0 OUT, 'access_token'
EXEC sp_OASetProperty @mailman, 'OAuth2AccessToken', @sTmp0
DECLARE @email int
EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT
EXEC sp_OASetProperty @email, 'From', @mailbox
EXEC sp_OASetProperty @email, 'Subject', 'Sample message'
EXEC sp_OASetProperty @email, 'Body', 'This message was sent through Gmail SMTP using OAuth2.'
EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Recipient', 'recipient@example.net'
IF @success <> 1
BEGIN
PRINT 'Could not add the recipient.'
EXEC @hr = sp_OADestroy @token
EXEC @hr = sp_OADestroy @mailman
EXEC @hr = sp_OADestroy @email
RETURN
END
-- This sends a real message. Replace the recipient with an address you control.
EXEC sp_OAMethod @mailman, 'SendEmail', @success OUT, @email
IF @success <> 1
BEGIN
EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT
PRINT 'SMTP send failed. Check the token, mailbox, recipient, and Gmail sending limits.'
-- Inspect LastErrorText privately if needed; do not publish authentication/session logs.
-- A lost connection after DATA can leave acceptance uncertain. Avoid blindly retrying.
EXEC @hr = sp_OADestroy @token
EXEC @hr = sp_OADestroy @mailman
EXEC @hr = sp_OADestroy @email
RETURN
END
EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT
IF @success <> 1
BEGIN
PRINT 'Gmail accepted the message, but closing the connection failed. Do not resend it.'
EXEC @hr = sp_OADestroy @token
EXEC @hr = sp_OADestroy @mailman
EXEC @hr = sp_OADestroy @email
RETURN
END
PRINT 'Gmail accepted the message for delivery.'
EXEC @hr = sp_OADestroy @token
EXEC @hr = sp_OADestroy @mailman
EXEC @hr = sp_OADestroy @email
END
GO