Create Assembly in SQL Server For MSHTML

• martin.h

  SSC Rookie

  Points: 48

  More actions

  February 15, 2019 at 8:25 am

  #382754

  .NET Framework version --> 4.0.30319.42000
  SQL Server Version --> Microsoft SQL Server 2016 (SP1-GDR) (KB4458842) - 13.0.4224.16 (X64) 

  I need to implement "MSHTML" as an ASSEMBLY in SQL Server  to utilise "Spire.PDF". However, whilst there appears to be conflicting opinions in respect of "MSHTML" in .NETv4, I get the following message when attempting to create the assembly: 
  Warning: The Microsoft .NET Framework assembly 'microsoft.mshtml, version=7.0.3300.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.' you are registering is not fully tested in the SQL Server hosted environment and is not supported. In the future, if you upgrade or service this assembly or the .NET Framework, your CLR integration routine may stop working. Please refer SQL Server Books Online for more details.
  Msg 6509, Level 16, State 141, Line 1
  An error occurred while gathering metadata from assembly 'Microsoft.mshtml' with HRESULT 0x80070057.

  ... Of course the end result is the assembly is not created...

  Can anyone definitively state I am attempting the impossible?, or, if not, can anyone give a clue as to how I can achieve my objective as I am rapidly running out of ideas?

  Thanks in anticipation.

  Martin Hope