SQL Server

Set a MIME Body from a File

Demonstrates the Chilkat Mime.SetBodyFromFile method, which reads a local file and sets it as the body, choosing content headers from the filename extension. The only argument is the file path.

Note: The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background: This is the one-call way to turn a file into a MIME part: Chilkat reads the bytes and infers the Content-Type and transfer encoding from the extension — .jpg becomes image/jpeg with base64, .txt a text type, and so on. It is the natural building block for adding an attachment, usually followed by setting a Content-Disposition and filename.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Demonstrates the Mime.SetBodyFromFile method, which reads a local file and sets it as the body,
    --  choosing content headers based on the filename extension.  The only argument is the file path.

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

    --  The Content-Type and encoding are set from the ".jpg" extension (image/jpeg, base64).
    EXEC sp_OAMethod @mime, 'SetBodyFromFile', @success OUT, 'qa_data/photo.jpg'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        RETURN
      END


    EXEC sp_OAGetProperty @mime, 'ContentType', @sTmp0 OUT
    PRINT 'Content-Type: ' + @sTmp0

    EXEC sp_OAGetProperty @mime, 'Encoding', @sTmp0 OUT
    PRINT 'Encoding: ' + @sTmp0

    EXEC @hr = sp_OADestroy @mime


END
GO