.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

Creating assembly throwing an error as system.directoryservices assembly is not in the SQL Server

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
Hi, I am trying to create an assembly (DLL file that created by C# ) which uses System.DirectoryServices assembly. When I try with following script Create ASSEMBLY Addresstype From 'C:\ActiDirectoryFunctions\ActiveDirectoryFunctions.dll' I am getting following Error Assembly 'ActiveDirectoryFunctions' references assembly 'system.directoryservices, version=2.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. From above error message, I learnt that System.DirectoryServices assembly is not in the SQL Server. I am using SQL SERVER 2005 SP2 and .Net Framework 3 is there in the machine How to manually add this assembly into this SQL Server Machine? Please let me know if you know Thank you, Raj Dreaming a world without any war in anywhere


View Complete Post


More Related Resource Links

HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web.

  
HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web. I have a C# library (dll) I want to add to SQL Server via "CREATE ASSEMBLY", but the DLL uses these references: Microsoft.VisualBasic System System.Core System.Data System.Data.DataSetExtensions System.Drawing System.Management System.Web System.Web.Extensions System.Web.Mobile System.Web.Services System.Xml System.Xml.Linq And just to be clear, the DLL is a .NET 3.5 app, with the SQL Server being SQL Server 2008. Right off the bat, the "CREATE ASSEMBLY" call fails due to System.Web, which strangely, is 2.0.0.0. The CREATE ASSEMBLE says this error: Msg 10301, Level 16, State 1, Line 1 Assembly 'MyLibrary' references assembly 'system.web, version=2.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. I have tried to use VS 2010, to create a SQL Server DB project, and it point blank does not let one add references to things like System.Web. When trying to use "Add Ref", VS 2010 literally lo

Assembly load error system.runtime.serialization

  
Hello ! I have a web project which i began there is some month, and compile perfectly until now. In fact, i have some compile error;   erreur 1 Could not load file or assembly 'System.Runtime.Serialization, Version=3.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The module was expected to contain an assembly manifest.   on explorer :   The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018) Description : Une exception non gérée s'est produite au moment de l'exécution de la demande Web actuelle. Contrôlez la trace de la pile pour plus d'informations sur l'erreur et son origine dans le code. Détails de l'exception: System.BadImageFormatException: The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018) Erreur source: Une exception non gérée s'est produite lors de l'exécution de la demande Web actuelle. Les informations relatives à l'origine et l'emplacement de l'exception peuvent être identifiées en utilisant la trace de la pile d'exception ci-dessous. Trace de la pile: [BadImageFormatException: The module was expected to contain an assembly manifest. (Exception from HRESULT: 0x80131018)] System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBa

Unknown server tag error even after assembly registration

  

Hey guys,

I don't know what is going on. When I try to add a tab container in my page, it allows me to do that but when I modify the code, the unknown server tag error pops up in the design view of the page.

I checked the source code to see if I had my @register clause in there, and it was there, but still the error shows. I don't know what happened, the last time it worked perfectly.

I have also recently downloaded the cute editor for .net and installed the .dlls to my bin folder and it is showing the same simtoms as well.

Had any1 encountered this problem before and if so how did you fix it?


Thanks,

Zeph


hi i m getting "failed to install assembly:- microsoft.visualbasic.vsa.dll because of system error:-

  
pls help me rectifying this error n pls guide me to rectify it

hi i m getting "failed to install assembly:- microsoft.visualbasic.vsa.dll because of system error:-0x80131107" during the installtion of microsoft .net framework 2.0

SQL Server 2008 R2 enterprise fails with assembly error.

  

I have been trying to install Sql Server 2008 R2 Enterprise Edition on a 64-bit Windows 7 real machine (not a VM). Every single time it fails when installing the setup support files, during the "ExecuteStandardTimingsWorkflow" action. This is the dialog that comes up:

 

"The following error has occured:

An error occured during the installation of assembly 'Microsoft.SqlServer.GridControl,fileversion="10.50.1600.1",version-"10.0.0.00000",culture="nuetral",publickeytoken="<number>",processArchitecture="x86". Please refer to Help and Support for more information. HRESULT: 0x80131047.

"

I have tried running the setup.exe from a 32-bit command prompt, and an elevated command prompt. I am logged in as a system administrator. I removed a version of SQL Server that was previously on the system sql server 2008. I also had rebooted before all of these installation attempts.


Error: The type 'System.Windows.DependencyObject' is defined in an assembly that is not referenced

  

Hi

I have an ObservableCollection which I would like to sort.

List
<TLstNodeData> SWNodeList = TopNode.SubNodes.OrderBy(SNode => SNode.NodeDispText).ToList();

In a WindowsForm application targeting the .NET 4.0 Framework it compiles and works as expected.

If I do this in a WCF Service in my web project also targeting the .NET 4.0 Framework I get the following error.

Error 1 The type 'System.Windows.DependencyObject' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Windows, Version=2.0.5.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e'.

When I add this

Deployment error system.data.sqlserverce version 3.5.1.0 glabal assembly cache

  

I have upgraded my development environment from Visual C# 2008 Express on Windows XP to Visual C# 2010 Express running on Windows 7 that uses SQLCE SP2.  I use a private deployment of the SQLCE 32-bit and 64-bit libaries and for the past year has wworked fine deploying to all systems.  Since upgrading I have been unable to produce a successful deployment.  I get an error almost immediately when my program attempts to update

system.data.sqlserverce version 3.5.1.0 glabal assembly cache

I have been attempting to do the deployment on a Windows 7 64 bit machine.  Does anybody have any ideas what I can do to eliminate this issue.  I have ensure that my build is targeting .NET 3.5

Dave


David Allen

Error: Encountered multiple versions of the same assembly with GUID...try pre-importing...TlbImp

  

Hi!  Can someone tell me how I can troubleshoot the following error: "Encountered multiple versions of the same assembly with GUID...try pre-importing one of these assemblies".

The website developed in VS 2010 (.Net 3.5). This error is only received on my workstation.  Another person developing the site does not experience this issue at all.  Also, not sure if this matters, but on my workstation the 'Assembly Information...' dialog contains no values even though the 'AssemblyInfo.vb' file does specify values for the title, desc, etc.  The GUID being referenced in the error is the main project of the three projects within the solution.

I tried looking through the GAC, but do not see any references to the projects or DLLs in the VS solution and am not sure what else/where to look.

If I delete the copy of the solution on my local machine and pull down a copy from source control (AnkhSVN) the solution will build with no error.  Once I make any changes, such as adding a new aspx file, then the error is received.

I can provide any additional information needed.


The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must

  

Hi,

This is frustrating, and I don't know how to solve it.

I have a strange problem. I am adding a LinqDatasource object, and set the context:

        protected void LinqDataSource_ContextCreating(object sender, LinqDataSourceContextEventArgs e)
        {
            e.ObjectInstance = new KaruselaDataContext(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        }


Then I get this error:
The type 'System.Data.Linq.DataContext' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'.

 

On web.config I already have this:
<add assembly="System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

NOTE: The datacontext is in a different project (DLL proect) where I added a refernce to System.Data.Linq.

is there another way adding a refernce to a web project? or only though teh web.config?

Thanks.


Registering controls of current assembly object reference NOT set error

  

Hi There,

I have created a simple ASP.net Web Application (2.0) and have added a web user control.

Now in my page I have added this control but I have registered like this,

<%@ Register Assembly="WebApplication1" Namespace="WebApplication1" TagPrefix="Custom" %>

Which means I want to access all the controls in my current Web Application project

Then I have added my user control like this,

<Custom:MyUserControl ID="MyUserControl1" runat="server" PublicProperty="Hello" />

Every thing is fine but when I execute the project, NO control on my user control gets "instantiated" and thus I receive error "Object Reference Not Set"

Note that My Control has,

1) Public property PublicProperty as String

2) 1 Label control

In Load Event Handler I am setting Text property of Label Control to PublicProperty. Here object reference NOT set error occurs (which means Label control is NOT initialized).

I don't want to register my control using Src, TagPrefix etc. Any ideas?

Thanks


Error Handling: Throwing Custom Exception Types from a Managed COM+ Server Application

  

Exception handling semantics in .NET are based on type, so you can create custom exceptions that have their own properties and methods. In .NET, exceptions are first-class citizens, and since they're the built-in error handling mechanism, all .NET-compliant languages must support exceptions. In addition, COM+ services are available to .NET code as Enterprise Services, so you can leverage exceptions in your Enterprise Services design.In this article the author describes custom exceptions, throwing exceptions across COM interop boundaries, and working with Enterprise Services.

Bob DeRemer

MSDN Magazine March 2004


Error loading an assembly in VS 2010

  

Could not load file or assembly 'file:///C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\0385538b\d249bb9e\App_global.asax.nfwopg19.dll' or one of its dependencies. The system cannot find the file specified.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IO.FileNotFoundException: Could not load file or assembly 'file:///C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\root\0385538b\d249bb9e\App_global.asax.nfwopg19.dll' or one of its dependencies. The system cannot find the file specified.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Assembly Load Trace: The followin

Video: SharePoint 2010: Creating .NET Assembly Connectors in Visual Studio 2010 Support

  
Learn how the inclusion of Business Connectivity Services (BCS) creates opportunities to leverage SharePoint features and APIs against your existing line of business data that is available via direct database access or via Web services. (Length: 5:41)

Error on executing VB file : The assembly does not allow partially trusted callers

  
Dear All ! Though there are many posts stated with solutions, im still facing the error in my application. I have created a VB Class Library project in VS 2008 which on execution in another application (ERP) will open a VB form holding a report. Its working fine in Server machine. The report is drawn from a DB placed on another server. Everything works fine in Server. But in another machine its not.  I did opened the project from the local machine, Build it so tht the dll be caught in the ERP application and so it did, iam able to see the dll within the application. but on execution its throwing the error 'The Call to member failed. The assembly does not allow partially trusted callers ' What should i do in order to execute the project in all local machines application ??   Thanks in Advance... waiting for a solution.. Radhai.  

Problem to create assembly which depends on other dll's from SQL Server

  
I am developing an application in .Net but I need to access to some procedures in ASP.Net since SQL Server.I have got it but i have problems to assembly the dll if it has dependencies of another dll's.I have read that if a dll need other dll it call it automatically but when I try to assembly my class in .NET there is the next error: Create failed for SqlAssembly 'ClaseEjemplo'. Assembly 'csyt.dal, version=0.0.0.0, culture=neutral, publickeytoken=null.' was not found in the SQL catalog. (.Net SqlClient Data Provider) Nevertheless if I the class hasn't another dependencies it works.The class I am trying to assembly is ClaseEjemplo.If I try to use the procedure of other class "'csyt.dal" I have problems.If ClaseEjemplo hasn't dependencies it works perfectly!My class ClaseEjemplo is: using System;using System.Collections.Generic;using System.Text;using Csyt.DAL;using Csyt.Info; namespace ClaseEjemplo{    public class Class1    {        public static long devolucion()        {            AIAlarmaDB.TipoCondicion aux1 = new AIAlarmaDB.TipoCondicion();                        AIAlarmaDB aux = new AIAlarmaDB();            aux1=aux.GetTipoCondicionById(1);            return aux1.Id;        }     }}Thanks in advance

clr assembly in sql server - working directory? and exception question

  
Hello, I have a small assembly in sql server 2008... it's pretty simple, but in the very rare circumstance that it may throw an exception I am catching it and writting to a log file. something like: using (StreamWriter sr = new StreamWriter(@".\ErrorLog.txt", true)) { sr.WriteLine("{0:G} ===> {1}", DateTime.Now, ex.Message); } I believe that should write the file to the working directory... 1. what would the working directory be for sql server 2008? the binn directory? 2. what would happen if a clr assembly added to sql server throws an exception that is not handled by your clr code?

The condition of creating assembly for external access permission?

  
To create an EXTERNAL_ACCESS or UNSAFE assembly in SQL Server, one of the following two conditions must be met: 1. The assembly is strong name signed or Authenticode signed with a certificate. This strong name (or certificate) is created inside SQL Server as an asymmetric key (or certificate), and has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission (for external access assemblies) or UNSAFE ASSEMBLY permission (for unsafe assemblies). 2. The database owner (DBO) has EXTERNAL ACCESS ASSEMBLY (for EXTERNAL ACCESS assemblies) or UNSAFE ASSEMBLY (for UNSAFE assemblies) permission, and the database has the TRUSTWORTHY Database Property set to ON. The two conditions listed above are also checked at assembly load time (which includes execution). At least one of the conditions must be met in order to load the assembly. This is a explanation on msdn.I think if only one of these condition is met,it will work. But after I do the first condition,I still can not create an assembly with EXTERNAL_ACCESS permission except SET TRUSTWORTHY on. should the two condition be met?  
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend