HTTP Resume Download File

Demonstrates how to resume downloading of a partially downloaded file.

Download Chilkat HTTP ActiveX

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

    DECLARE @success int

    --  Any string unlocks the component for the 1st 30-days.
    EXEC sp_OAMethod @http, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        RETURN
      END

    --  Resume downloading a file.
    --  It is assumed that a prior download was interrupted
    --  and a partial file already exists on the local filesystem.
    --  To download the remainder of the file, call ResumeDownload:
    DECLARE @localFilename nvarchar(4000)

    SELECT @localFilename = 'ChilkatPerl.zip'
    DECLARE @url nvarchar(4000)

    SELECT @url = 'http://www.chilkatsoft.com/download/ChilkatPerl.zip'
    EXEC sp_OAMethod @http, 'ResumeDownload', @success OUT, @url, @localFilename
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN
        PRINT 'Download Complete!'
      END
END
GO