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

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 returns the binary data as […]

How to Implement a REST API Function

Question: We are trying to interface with RingCentral to send faxes and they require us to upload the file and also send a JSON message at the same time – is there a function that can do this? Answer: The best way to solve such a problem is as follows: 1. Find the Developer Documentation for the REST API in […]

PDF Unsigned Signature Fields

Unsigned signature fields in a PDF are placeholders for digital signatures that can be added to a PDF document at a later time. These fields are often created by the author or originator of the document, and they indicate where and how a digital signature should be placed. When the document is distributed, recipients can then use these fields to […]

Explaining the SigningTime Authenticated Attribute in PKCS7 Signatures

The “signingTime” authenticated attribute in PKCS #7 (now part of Cryptographic Message Syntax or CMS) signatures is an optional attribute that indicates the date and time when the digital signature was created. It is commonly included in signed-data objects to provide a timestamp that can help verify when a signature was applied. Detailed Explanation: Attribute OID: The “signingTime” attribute is […]

Error Code 800A01AD trying to CreateObject in VBScript

Question: I got the following error when trying to instantiate an ActiveX object in my VBScript (.vbs) Code “800A01AD”Message “ActiveX component can’t create object: ‘Chilkat.Cert’” Answer: It means the ActiveX is not registered.  Yes, you probably registered the ActiveX, but you need to understand if your VBScript is running as a 32-bit process, or a 64-bit process.  You then need […]

How to Run 32-bit vs 64-bit VBScript

To run a .vbs VBScript explicitly as either a 32-bit or 64-bit process on a 64-bit Windows system, you need to specify which version of the Windows Script Host (wscript or cscript) to use. By default, the script runs using the version of the Windows Script Host that matches the bitness of the environment in which it is invoked (32-bit […]

Explaining .p7m and .p7s Files

.p7m and .p7s files are types of files associated with cryptographic signatures and encryption, specifically those based on the PKCS #7 standard. These files are commonly encountered in contexts like secure email and digitally signed documents. 1. What is a .p7m File? A .p7m file is a digitally signed or encrypted file that uses the PKCS #7 (Public Key Cryptography […]

Chilkat v10.0.1 Release Notes

Chilkat v10.0.1 is a patch for certain builds of Chilkat. Previous Version: Chilkat v10.0.0 Release Notes/ .NET Core Packages on NuGet: When v10.0.0 was released, Chilkat removed the substring “-9.5.0” from the DLLs/shared libs in the ChilkatNativeLib NuGet package.  This caused the following error because now both native and managed DLLs were named the same (ChilkatDnCore.dll).  This is now fixed […]