HTTP Session Logging

Demonstrates how to use the SessionLogFilename property to log HTTP requests and responses to a 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

    --  Set the SessionLogFilename property so that the Chilkat HTTP component
    --  logs the exact HTTP requests and responses to a log file.

    --  The SessionLogFilename may be used with any of the HTTP
    --  methods for sending GET, POST, PUT, DELETE, HEAD, etc.
    EXEC sp_OASetProperty @http, 'SessionLogFilename', 'c:/temp/httpSessionLog.txt'

    --  Try a simple HTTP GET and then examine the session log:
    DECLARE @html nvarchar(4000)

    EXEC sp_OAMethod @http, 'QuickGetStr', @html OUT, 'http://www.chilkatsoft.com/httpTest/abc.html'
    IF @html Is NULL 
      BEGIN
        EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  Here are the contents of the session log file after doing
    --  the GET request:

    --  
---- Sending ----
GET /httpTest/abc.html HTTP/1.1
Accept: */*
Accept-Encoding: gzip
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Language: en-us,en;q=0.5
User-Agent: Chilkat/1.0.0 (+http://www.chilkatsoft.com/ChilkatHttpUA.asp)
Host: www.chilkatsoft.com
Connection: Keep-Alive


---- Received ----
HTTP/1.1 200 OK
Content-Length: 37
Content-Type: text/html
Last-Modified: Wed, 09 Dec 2009 14:55:08 GMT
Accept-Ranges: bytes
ETag: "4eecd499df78ca1:28b"
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Date: Wed, 09 Dec 2009 15:15:50 GMT

<html>
<body>
ABC
</body>
</html>

END
GO

Need a specific example? Send a request to support@chilkatsoft.com