Spire.PDF is a professional PDF library applied to creating, writing, editing, handling and reading PDF files without any external dependencies. Get free and professional technical support for Spire.PDF for .NET, Java, Android, C++, Python.

Mon Sep 15, 2014 5:00 pm

Hi,

We're deploying the Spire.Pdf dll as part of a Sql Server 2012 CLR function, and one of the dependencies that comes up is for Microsoft.Mshtml.dll. When adding this assembly the following error occurs.

Msg 6509, Level 16, State 141, Line 118
An error occurred while gathering metadata from assembly 'Microsoft.mshtml' with HRESULT 0x80070057.

The CLR function does load and seems to function correctly, but I'd like to understand that dependency and see if it can be removed.

Thanks,
Reuven

reuven
 
Posts: 1
Joined: Sun Sep 14, 2014 5:23 pm

Tue Sep 16, 2014 1:46 am

Hello,

Thanks for your inquiry.
As the error occurs when added Microsoft.Mshtml.dll, I am afraid that we cannot be of much help.
Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Sat Apr 30, 2016 8:21 pm

I have this very same issue happening, however it does not seem to load the assembly. Therefore spire.pdf.dll can't load. What are we supposed to do now that microsoft.mshtml.dll is deprecated?

jbj
 
Posts: 1
Joined: Sat Apr 30, 2016 6:49 pm

Tue May 03, 2016 3:37 am

Hello,

Thanks for your inquiry. I have noticed the issue on SQL Server2012 and suppose that Microsoft.mshtml.dll might be not supported on sql2012, we try to resolve it but there is no any solution on internet currently, we will look into it further and confirm if the reference can be removed from our product, once there is any update, we will let you know.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Fri Feb 15, 2019 4:31 pm

Has this ever been resolved?

I am attempting to use Spire.PDF on SQL Server, and will need to source an alternative solution soon if unable to do so.

MDHope
 
Posts: 1
Joined: Tue Feb 12, 2019 10:24 am

Mon Feb 18, 2019 3:29 am

Dear Martin,

Thanks for your inquiry.
After investigating, we found the reference (Microsoft.mshtml.dll) can't be removed from our product, because other features of our Spire.PDF depend on it. Sorry that there is no good solution to handle it on SQL Server 2012 at present. If you have other questions, please feel free to write back.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Mon Mar 04, 2019 7:12 am

Hello,

After our internal discussion, we decided to create a version which didn't include the features that depend on the reference (Microsoft.mshtml.dll).
Please download this version via this link, https://www.e-iceblue.com/downloads/Tem ... _5.3.0.zip, and then apply it to SQL Server2012.

Here is SQL command for reference.

Code: Select all
CREATE ASSEMBLY [System.Windows.Forms]
FROM'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\System.Windows.Forms.dll'
WITH PERMISSION_SET=UNSAFE

CREATE ASSEMBLY [System.Web]
FROM 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\System.Web.dll'
WITH PERMISSION_SET=UNSAFE

CREATE ASSEMBLY [Spire.License]
FROM'D:\NET4.0\Spire.License.dll'
WITH PERMISSION_SET=UNSAFE

CREATE ASSEMBLY [Spire.Pdf]
FROM'D:\NET4.0\Spire.Pdf.dll'
WITH PERMISSION_SET=UNSAFE


Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Sep 30, 2019 7:28 pm

Hi,
i have the same issue. Could You upload version 5.3.0 once again? because Your link not work

Thank You

gianfranco10
 
Posts: 2
Joined: Mon Sep 30, 2019 7:18 pm

Tue Oct 01, 2019 1:54 am

Hi,

Thanks for your inquiry.
The fix has been included in the latest version of Spire.Pdf. Please download and test Spire.PDF Pack(Hot Fix) Version:5.9.16.

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Tue Oct 01, 2019 2:03 pm

Hotfix doesn`t works.

Issue is that Spire have depend on the reference Microsoft.mshtml.dll which we can`t attach to databse sql server 2012 ( see the same issue in above posts ) . Ealier You wrote that You create special assembly "After our internal discussion, we decided to create a version which didn't include the features that depend on the reference (Microsoft.mshtml.dll).".
Could You do this again ?

gianfranco10
 
Posts: 2
Joined: Mon Sep 30, 2019 7:18 pm

Wed Oct 02, 2019 3:05 am

Hi,

Thanks for your feedback.
Sorry the link of the version 5.3.0 we provided before is not accessible now. And as now we are on Chinese National Day holidays, we will check the broken link of original version and make a confirmation for your issue, then give you a response once we back to office on 08/10/2019. Sorry for the inconvenience caused and thanks for your understanding.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Tue Oct 08, 2019 8:09 am

Hi,

Spire.pdf_5.3.0 is available now. Please download it via this link,https://www.e-iceblue.com/downloads/TempVersion/spire.pdf_5.3.0.zip.

And we also upload the latest version which suppports the feature, https://www.e-iceblue.com/downloads/TempVersion/spire.pdf_5.10.1_SQL_CLR.zip.

Sincerely,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Return to Spire.PDF