SQL Server

Create an MHT Archive from a URL

Demonstrates Mht.GetMHT, which creates an MHT web archive from a live web page (or local HTML file) and returns the complete MHT MIME text in memory.

Background. An MHT (MHTML) web archive is a single MIME file that bundles an HTML page together with its referenced resources, such as images and style sheets, so the page can be stored or viewed offline as one file.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

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
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @mht int
    EXEC @hr = sp_OACreate 'Chilkat.Mht', @mht OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  Create an MHT web archive from a live web page and return the complete MHT MIME text in memory.
    --  Supported statically referenced resources (images, style sheets, etc.) are captured.
    DECLARE @mhtText nvarchar(4000)
    EXEC sp_OAMethod @mht, 'GetMHT', @mhtText OUT, 'https://example-code.com/crumb/index.html'
    EXEC sp_OAGetProperty @mht, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @mht, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mht
        RETURN
      END

    PRINT @mhtText

    EXEC @hr = sp_OADestroy @mht


END
GO