HTTP Upload using a Proxy Server

HTTP Upload using a proxy server. For more information about HTTP Upload, see this blog post: HTTP Upload Overview

Download Chilkat Upload ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @upload int
    EXEC @hr = sp_OACreate 'Chilkat.Upload', @upload OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  You may send test uploads to this URL:
    --  http://www.chilkatsoft.com/cgi-bin/ConsumeUpload.exe
    -- 
    --  A test HTML page is located at:
    --  http://www.chilkatsoft.com/upload.html

    --  Specify the page (ASP, ASP.NET, Perl, Python, Ruby, CGI, etc)
    --  that will process the HTTP Upload.
    EXEC sp_OASetProperty @upload, 'Hostname', 'www.chilkatsoft.com'
    EXEC sp_OASetProperty @upload, 'Path', '/cgi-bin/ConsumeUpload.exe'

    --  Specify an HTTP proxy server:
    EXEC sp_OASetProperty @upload, 'ProxyDomain', 'localhost'
    EXEC sp_OASetProperty @upload, 'ProxyPort', 808

    --  Add one or more files to be uploaded.
    EXEC sp_OAMethod @upload, 'AddFileReference', NULL, 'file1', 'dude.gif'
    EXEC sp_OAMethod @upload, 'AddFileReference', NULL, 'file2', 'pigs.xml'
    EXEC sp_OAMethod @upload, 'AddFileReference', NULL, 'file3', 'sample.doc'

    --  Do the upload.  The method returns when the upload
    --  is completed.
    --  This component also includes asynchronous upload capability,
    --  which is demonstrated in another example.
    DECLARE @success int

    EXEC sp_OAMethod @upload, 'BlockingUpload', @success OUT
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @upload, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN
        PRINT 'Files uploaded!'
      END
END
GO