(SQL Server) 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).

A server-side C# example showing how to receive an upload is located at C# ASP.NET Code to Receive Upload

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @upload int
    -- Use "Chilkat_9_5_0.Upload" for versions of Chilkat < 10.0.0
    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 receive and process the HTTP Upload.
    EXEC sp_OASetProperty @upload, 'Hostname', 'www.mywebserver.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', 'swordfish.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

    EXEC @hr = sp_OADestroy @upload


END
GO