SQL Server

Download Image (JPG, GIF, etc.) to Base64

See more HTTP Examples

Demonstrates how to download an image, or any type of file, to get the data in base64 encoding format. SQL Server

-- 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 @success int
    SELECT @success = 0

    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @http int
    EXEC @hr = sp_OACreate 'Chilkat.Http', @http OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @http, 'KeepResponseBody', 1

    DECLARE @bd int
    EXEC @hr = sp_OACreate 'Chilkat.BinData', @bd OUT

    EXEC sp_OAMethod @http, 'DownloadBd', @success OUT, 'https://www.chilkatsoft.com/images/starfish.jpg', @bd
    DECLARE @statusCode int
    EXEC sp_OAGetProperty @http, 'LastStatus', @statusCode OUT
    IF @success = 0
      BEGIN
        IF @statusCode = 0
          BEGIN
            -- Unable to either send the request or get the response.
            EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
            PRINT @sTmp0
          END
        ELSE
          BEGIN
            -- We got a response, but the status code was not in the 200s

            PRINT 'Response status code: ' + @statusCode
            -- Examine the response body.

            PRINT 'Response body:'
            EXEC sp_OAGetProperty @http, 'LastResponseBody', @sTmp0 OUT
            PRINT @sTmp0
          END

        PRINT 'Download failed.'

      END
    ELSE
      BEGIN

        PRINT 'Download success, response status = ' + @statusCode

        DECLARE @base64_image_data nvarchar(4000)
        EXEC sp_OAMethod @bd, 'GetEncoded', @base64_image_data OUT, 'base64'

        PRINT 'image data in base64 format:'

        PRINT @base64_image_data
      END

    EXEC @hr = sp_OADestroy @http
    EXEC @hr = sp_OADestroy @bd


END
GO