Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3/4TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

Excel Examples

Web API Categories

ASN.1
Amazon Glacier
Amazon S3
Amazon S3 (new)
Amazon SES
Amazon SNS
Amazon SQS
Azure Cloud Storage
Azure Service Bus
Base64
Bounced Email
Box
CSR
CSV
Certificates
Compression
DKIM / DomainKey
DSA
Diffie-Hellman
Digital Signatures
Dropbox
Dynamics CRM
ECC
Email Object
Encryption
FTP
FileAccess
Firebase
GMail REST API
Google APIs
Google Calendar
Google Cloud Storage
Google Drive
Google Photos
Google Sheets
Google Tasks
Gzip
HTML-to-XML/Text
HTTP

HTTP Misc
IMAP
JSON
JSON Web Encryption (JWE)
JSON Web Signatures (JWS)
JSON Web Token (JWT)
Java KeyStore (JKS)
MHT / HTML Email
MIME
Microsoft Graph
NTLM
OAuth1
OAuth2
OneDrive
OpenSSL
Outlook
PEM
PFX/P12
POP3
PRNG
REST
REST Misc
RSA Encryption
SCP
SFTP
SMTP
SSH
SSH Key
SSH Tunnel
SharePoint
Socket/SSL/TLS
Spider
Stream
Tar Archive
Upload
WebSocket
XAdES
XML
XML Digital Signatures
XMP
Zip
curl

 

 

 

(Excel) Debugging with Socket Session Logging

Debugging with socket session logging.

The Chilkat Socket component provides properties for keeping a session log making it possible to see the exact bytes received and sent on a TCP/IP or SSL connection. To enable session logging, set the KeepSessionLog property = True. The SessionLogEncoding property controls how binary, non-printable bytes are represented in the log. There are two possible settings: Possible values are "esc" and "hex". The default value is "esc".

When set to "hex", the bytes are encoded as a hexidecimalized string. The "esc" encoding is a C-string like encoding, and is more compact than hex if most of the data to be logged is text. Printable us-ascii chars are unmodified. Common "C" control chars are represented as "\r", "\n", "\t", etc. Non-printable and byte values greater than 0x80 are escaped using a backslash and hex encoding: \xHH. Certain printable chars are backslashed: SPACE, double-quote, single-quote, etc.

Download Excel Class Modules

Chilkat Excel Class Modules

Dim socket As Chilkat.Socket
Set socket = Chilkat.NewSocket

Dim success As Boolean
success = socket.UnlockComponent("Anything for 30-day trial")
If (success <> True) Then
    Debug.Print socket.LastErrorText
    Exit Sub
End If

'  Enable session logging:
socket.KeepSessionLog = True
socket.SessionLogEncoding = "esc"

'  To demonstrate session logging, we'll connect to an
'  HTTP server and download the HTTP response header:
Dim ssl As Boolean
ssl = False
Dim maxWaitMillisec As Long
maxWaitMillisec = 20000
success = socket.Connect("www.chilkatsoft.com",80,ssl,maxWaitMillisec)
If (success <> True) Then
    Debug.Print socket.LastErrorText
    Exit Sub
End If

'  Set maximum timeouts for reading an writing (in millisec)
socket.MaxReadIdleMs = 10000
socket.MaxSendIdleMs = 10000

'  The socket component includes a BuildHttpGetRequest
'  method for convenience. Build a GET and send it to
'  the web server:
Dim httpGet As String
httpGet = socket.BuildHttpGetRequest("http://www.chilkatsoft.com/")

'  Send it...
success = socket.SendString(httpGet)
If (success <> True) Then
    Debug.Print socket.LastErrorText
    Exit Sub
End If

'  Read the response up to the first double CRLF:
Dim httpHeader As String
httpHeader = socket.ReceiveUntilMatch("\r\n" & vbCrLf)
If (socket.LastMethodSuccess <> True) Then
    Debug.Print socket.LastErrorText
    Exit Sub
End If

'  Close the connection with the server
'  Wait a max of 20 seconds (20000 millsec)
success = socket.Close(20000)

'  Display the session log:
Debug.Print socket.SessionLog

'  Show the HTTP response header:
Debug.Print httpHeader

 

© 2000-2019 Chilkat Software, Inc. All Rights Reserved.