Chilkat v11.2.0 Release Notes

Pinned November 3, 2025

Previous Version: Chilkat v11.1.0 Release Notes The main addition in v11.2.0 is the Chilkat.Ai class, and the Chilkat.StringBuilder.MarkdownToHtml method. Ai: The Chilkat AI class provides a unified API for interacting with different AI providers: OpenAI, Google, Claude, xAI, Perplexity, and DeepSeek. It provides functionality for conversation management, multimodal inputs, and streaming mode. Markdown to HTML […]

Semantic Versioning Starting with Chilkat 10.0.0

Pinned September 26, 2024

Starting with the v10.0.0 release (end of September 2024), Chilkat moves to standard semantic versioning.   Prior to this release, for various technical reasons, Chilkat was stuck with versions 9.5.0.xx, where only xx changed. For this first leap to semantic versioning, where the major version changes to 10 (from 9), there are no backward incompatible changes.  […]

SQL Server Methods that Return Long Strings

January 3, 2025 in General

SQL Server Methods that Return Long Strings Some ActiveX methods return strings that are too long for local string variables. How can these be returned to the calling stored procedure? Answer The Chilkat Global object has a property named KeepStringResult which can be set to 1. (The default value is 0.) When set to 1, […]

Returning Binary Data from ActiveX to SQL Server varbinary(max)

October 11, 2024 in SQL Server

The error -2147211494 (hex 0x80040202) in SQL Server when using “sp_OAMethod” typically indicates a type mismatch or invalid data type issue, particularly when interacting with COM objects that return binary data. The Chilkat ActiveX returns a SAFEARRAY of VT_UI1, which causes the problem explained below.  The solution is to instead look for the Chilkat method that […]

SQL sp_OAMethod String Length Return Value Limitations

May 27, 2022 in SQL Server

The sp_OAMethod function is used to call ActiveX methods in SQL stored procedures.  If the ActiveX method returns a string, there is a limit imposed by sp_OAMethod on the size of the string that can be returned.  (Perhaps it is 4000 chars?) This blog post describes a way to workaround this limitation. An example of […]