I am having an issue with Chilkat and executing the below block of code. This worked in 2008 and now that we have moved to 2012 I get "invalid class string" at @description and an error of 99. I am thinking that something changed when upgrading to 2012 but I am unsure of what and I am still pretty new to SQL Server.
Thank you in advance for your help.
EXEC @hr = sp_OACreate 'ChilkatDotNet4.Upload', @upload OUT
select @hr
If @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
-- Added to help troubleshooting.
EXEC @HR = sp_OAGetErrorInfo
@upload,
@Source OUT,
@Description OUT;
select @hr, @source, @Description
SET @result = 99
SELECT @result
END