![]() |
Chilkat HOME Android™ AutoIt C C# C++ Chilkat2-Python CkPython Classic ASP DataFlex Delphi DLL Go Java Node.js Objective-C PHP Extension Perl PowerBuilder PowerShell PureBasic Ruby SQL Server Swift Tcl Unicode C Unicode C++ VB.NET VBScript Visual Basic 6.0 Visual FoxPro Xojo Plugin
(SQL Server) SOCKS4, SOCKS5 Proxy for POP3Demonstrates how to communicate with a POP3 server through a SOCKS4 or SOCKS5 proxy. Note: This example requires Chilkat v11.0.0 or greater.
-- 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 -- Important: Do not use nvarchar(max). See the warning about using nvarchar(max). DECLARE @sTmp0 nvarchar(4000) DECLARE @success int SELECT @success = 0 -- This example requires the Chilkat API to have been previously unlocked. -- See Global Unlock Sample for sample code. -- The mailman object is used for receiving (POP3) -- and sending (SMTP) email. DECLARE @mailman int EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mailman OUT IF @hr <> 0 BEGIN PRINT 'Failed to create ActiveX component' RETURN END -- To use a SOCKS4 or SOCKS5 proxy, simply set the following -- properties prior to making any calls that communicate with -- a POP3 server: -- The SOCKS hostname may be a domain name or -- IP address: EXEC sp_OASetProperty @mailman, 'SocksHostname', 'www.mysocksproxyserver.com' EXEC sp_OASetProperty @mailman, 'SocksPort', 1080 EXEC sp_OASetProperty @mailman, 'SocksUsername', 'myProxyLogin' EXEC sp_OASetProperty @mailman, 'SocksPassword', 'myProxyPassword' -- Set the SOCKS version to 4 or 5 based on the version -- of the SOCKS proxy server: EXEC sp_OASetProperty @mailman, 'SocksVersion', 5 -- Note: SOCKS4 servers only support usernames without passwords. -- SOCKS5 servers support full login/password authentication. -- Set the POP3 server's hostname EXEC sp_OASetProperty @mailman, 'MailHost', 'pop.someMailServer.com' -- Set the POP3 login/password. EXEC sp_OASetProperty @mailman, 'PopUsername', 'myLogin' EXEC sp_OASetProperty @mailman, 'PopPassword', 'myPassword' -- Copy the all email from the user's POP3 mailbox -- into a bundle object. The email remains on the server. DECLARE @bundle int EXEC @hr = sp_OACreate 'Chilkat.EmailBundle', @bundle OUT DECLARE @keepOnServer int SELECT @keepOnServer = 1 DECLARE @headersOnly int SELECT @headersOnly = 0 -- Irrelevent because we are NOT downloading headers-only DECLARE @numBodyLines int SELECT @numBodyLines = 0 EXEC sp_OAMethod @mailman, 'FetchAll', @success OUT, @keepOnServer, @headersOnly, @numBodyLines, @bundle IF @success = 0 BEGIN EXEC sp_OAGetProperty @mailman, 'LastErrorText', @sTmp0 OUT PRINT @sTmp0 EXEC @hr = sp_OADestroy @mailman EXEC @hr = sp_OADestroy @bundle RETURN END DECLARE @email int EXEC @hr = sp_OACreate 'Chilkat.Email', @email OUT DECLARE @i int SELECT @i = 0 EXEC sp_OAGetProperty @bundle, 'MessageCount', @iTmp0 OUT WHILE @i < @iTmp0 BEGIN EXEC sp_OAMethod @bundle, 'EmailAt', @success OUT, @i, @email EXEC sp_OAGetProperty @email, 'From', @sTmp0 OUT PRINT 'From: ' + @sTmp0 EXEC sp_OAGetProperty @email, 'Subject', @sTmp0 OUT PRINT 'Subject: ' + @sTmp0 SELECT @i = @i + 1 END EXEC sp_OAMethod @mailman, 'Pop3EndSession', @success OUT EXEC @hr = sp_OADestroy @mailman EXEC @hr = sp_OADestroy @bundle EXEC @hr = sp_OADestroy @email END GO |
© 2000-2025 Chilkat Software, Inc. All Rights Reserved.