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