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) Send Email without Authentication (no Login)Demonstrates how to send email using an SMTP server that does not require authentication. An SMTP server that needs no authentication should be protected by a firewall, to prevent outsiders from using it as a SPAM server. To send email without logging in, simply set the mailman's SmtpAuthMethod property = "NONE".
// 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 the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. -- The mailman object is used for sending and receiving email. DECLARE @mailman int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.MailMan', @mailman OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- Set the SMTP server. Perhaps it is the local machine. EXEC sp_OASetProperty @mailman, 'SmtpHost', 'localhost' -- Or perhaps it's a particular computer on the local network: EXEC sp_OASetProperty @mailman, 'SmtpHost', '192.168.1.123' -- Or provide a local domain that resolves to an IP address on the local network: EXEC sp_OASetProperty @mailman, 'SmtpHost', 'mymailsesrver.com' -- Set the SmtpAuthMethod property = "NONE" EXEC sp_OASetProperty @mailman, 'SmtpAuthMethod', 'NONE' -- Set the SMTP login/password (this may be omitted given no authentication will take place) -- mailman.SmtpUsername = "myUsername"; -- mailman.SmtpPassword = "myPassword"; -- Create a new email object DECLARE @email int EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Email', @email OUT EXEC sp_OASetProperty @email, 'Subject', 'This is a test' EXEC sp_OASetProperty @email, 'Body', 'This is a test' EXEC sp_OASetProperty @email, 'From', 'Chilkat Support <support@chilkatsoft.com>' DECLARE @success int EXEC sp_OAMethod @email, 'AddTo', @success OUT, 'Chilkat Admin', 'admin@chilkatsoft.com' -- To add more recipients, call AddTo, AddCC, or AddBcc once per recipient. -- Call SendEmail to connect to the SMTP server and send. -- The connection (i.e. session) to the SMTP server remains -- open so that subsequent SendEmail calls may use the -- same connection. EXEC sp_OAMethod @mailman, 'SendEmail', @success OUT, @email IF @success <> 1 BEGIN EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mailman EXEC @hr = sp_OADestroy @email RETURN END -- Some SMTP servers do not actually send the email until -- the connection is closed. In these cases, it is necessary to -- call CloseSmtpConnection for the mail to be sent. -- Most SMTP servers send the email immediately, and it is -- not required to close the connection. We'll close it here -- for the example: EXEC sp_OAMethod @mailman, 'CloseSmtpConnection', @success OUT IF @success <> 1 BEGIN PRINT 'Connection to SMTP server not closed cleanly.' END PRINT 'Mail Sent!' EXEC @hr = sp_OADestroy @mailman EXEC @hr = sp_OADestroy @email END GO |
© 2000-2024 Chilkat Software, Inc. All Rights Reserved.