Question:
I am using the code from this example: http://www.example-code.com/sql/http_post_form.asp
I have downloaded the activeX files and registered them on my server, it is running windows 2012 server 64bit.
When I run the stored procedure : [ChilkatSample]
I get the error: Failed to create ActiveX component
I am using SQL Server 2014 express edition
Please advise what I need to do to get it to work.
The ActiveX needs to be registered on the computer where SQL Server runs. If SQL Server runs as a 32-bit process, then make sure to download and register the 32-bit ActiveX. If SQL Server runs as a 64-bit process, then make sure to download and register the 64-bit ActiveX.
Be sure to carefully follow the directions for ActiveX registration here: http://www.chilkatsoft.com/downloads_ActiveX.asp
It is very easy to make a mistake. Also, see the note about the MSVC 9.0 runtime libs needing to be present:
MSVC++ 9.0 Runtime Libs
The Chilkat ActiveX DLLs are implemented in C++ and are built using Visual Studio 2008 (VC++ 9.0). This means the VC++ 9.0 runtime libs must be present on the computer where your app runs. The VC++ 9.0 runtime is typically already pre-installed on Windows computers, but for older computers it may not exist. If not, then you'll receive an "application configuration is incorrect" error. To fix, download and install the VC9 redist from here:
(64-bit) http://www.microsoft.com/en-us/download/details.aspx?id=15336 (32-bit) http://www.microsoft.com/en-us/download/details.aspx?id=29
(Chilkat builds using Visual Studio 2008 because it is the oldest possible Visual Studio that satisfies certain Windows security/compliance type certifications. The older the VC++ runtime, the less likely you'll find a computer that doesn't already have it pre-installed. For example, if Chilkat built with VS2013, then many more computers would not already have the runtime already present.)
Finally, Chilkat posted a C# .NET application that will examine a system to see if the Chilkat ActiveX is registered. You can run the 32-bit build to check the 32-bit Chilkat registration, or you can run the 64-bit build to check the 64-bit Chilkat registration.
See https://github.com/chilkatsoft/Check-ActiveX-Registration