Upload Files to a Web Server - Simplest Example

This is the simplest example for uploading some files to a web server. the BlockingUpload call is synchronous and returns when the upload is finished (or failed). The Chilkat Upload software is freeware and may be used in both commercial and non-commercial applications and websites.

The C# code to receive the upload at http://www.chilkatsoft.com/receiveUpload.aspx may be seen here: C# ASP.NET Code to Receive Upload

Download Chilkat Upload ActiveX (freeware)

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

    --  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', '/receiveUpload.aspx'

    --  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