SQL Server

Using an S3 Compatible Storage Provider

See more Amazon S3 Examples

Demonstrates how to use a compatible S3 storage provider. This example retrieves the XML listing the buckets for an Amazon S3 account.

In all cases, follow the Amazon S3 examples, except specify the AwsEndpoint for your S3 compatible storage provider.

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
    DECLARE @iTmp0 int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- 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

    -- Insert your access key here:
    EXEC sp_OASetProperty @http, 'AwsAccessKey', 'AWS_ACCESS_KEY'

    -- Insert your secret key here:
    EXEC sp_OASetProperty @http, 'AwsSecretKey', 'AWS_SECRET_KEY'

    -- Set the AwsEndpoint to your S3 compatible storage provider
    -- This example uses basefarm.net
    EXEC sp_OASetProperty @http, 'AwsEndpoint', 'basefarm.bf.object.osl.basefarm.net'

    DECLARE @xmlStr nvarchar(4000)
    EXEC sp_OAMethod @http, 'S3_ListBuckets', @xmlStr OUT

    EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        -- Failed
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN
        -- Success.  Show the XML response.  (Use the online tool at the link below to generate parsing code.)

        PRINT @xmlStr
      END

    -- Use this online tool to generate parsing code from sample XML: 
    -- Generate Parsing Code from XML

    EXEC @hr = sp_OADestroy @http


END
GO