Subject: References to ComponentPro.Sftp.dll  within a Visual C# SQL CLR Database fails
Date: 2013-02-21 21:16:38
From: Jerry Aguirre
Source: references-componentpro-sftp-dll-within-visual-c-sql-clr-database-fails
----------------------------------------------------------------------


	I read the blog and found a similar topic "References to UtlimateSFTP DLLs not possible within a Visual C# SQL CLR Database Project?"; however, when I tried to register the dll it failed.

	USE master

	GO

	sp_configure 'clr enabled', 1

	GO

	RECONFIGURE

	GO

	

	USE [SFSTest]

	GO

	ALTER DATABASE [SFSTest] SET TRUSTWORTHY ON

	GO

	

	CREATE ASSEMBLY [ComponentPro.Sftp.dll]

	 FROM 'C:\ComponentPro\UltimateFtpExpert v5.1.12221\Bin\Net4_0\ComponentPro.Sftp.dll'

	 WITH PERMISSION_SET = UNSAFE;

	 

	but I get Msg 10301, Level 16, State 1, Line 3

	Assembly 'ComponentPro.Sftp' references assembly 'system.drawing, version=4.0.0.0, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.

	 

	Workstation: Windows 7 64 bits

	Database: Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)    Oct 19 2012 13:38:57    Copyright (c) Microsoft Corporation     Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

	 

	Is this a 32\64 bit issue?

	 

----------------------------------------------------------------------

Note: This question has been asked on the Q&A forum of Thang Dang's fraudulent ComponentPro brand
If you purchased anything from ComponentPro, you have been scammed. Contact the payment processor
who sold you the license and ask for your money back.

Back to ComponentPro Q&A Forum Index