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


Post New Web Links

SQL2008 - Assembly versioning: Two versions of assembly '...'. Keep one version and drop the other

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Hi,

If someone has a suggestion of how to handle .NET dll assembly versions in a SQL Server 2008 database I would be very happy if you could explain how to do it.

First some background though so you'll understand the situation I'm in.

I've created a SQLCLR stored procedure in .NET with some code doning calculations in the database. Now I need to update the code according to some new business rules. Unfortunately we don't have a test environment where I can upload the code and test it until it works. Therefore I would like make the changes necessary in the code and somehow change the version number of the dll and deploy that to the database while the old dll is still used in production.

I've heard of the workaround with strong/weak assembly names but I'm wondering if there's a real versioning method around yet.

And yes I know the "easiest" way would be to create a testenvironment and ahve the normal setup with test/production servers but I still would like to know if my original idea is possible in any way.

Kind regards

-Tomas




View Complete Post


More Related Resource Links

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.


Programmatic access to Assembly Version in Product Properties?

  
Using VS2008 and would like to get programmatic access to the Assembly Version property in my Project Properties but I can't seem to find a way to do this. Any suggestions? The project is a .dll and I want to expose this version information to the caller in my interface section as a string.

"Mixed mode assembly is built against version 'v2.0.50727'.... " issue and use custom config file

  
Hi, My Winform applilcation has used Microsoft.SqlServer.Management.Common namespace(assembly :Microsoft.Sqlserver.smo.dll/Microsoft.Sqlserver.ConnectionInfo.dll) and developed in .NET 4.0. Problem:Application is throw an exception when it tries to use above assembly reference methods. Full error text is shown below, "Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in the 4.0 runtime without additional configuration information. " Error is resolved when we include "app.config" file with below code, <?xml version="1.0"?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> </configuration> But, I need to keep configuration file as "renamed.config" and not to include app.config file as of the project requirement.I have set configuration file as "renamed.config" file using below code, //AppDomain.CurrentDomain.SetData("APP_CONFIG_FILE", "d:\\reanmed.config" ); I have also included <Startup> element in this "renamed.config" configuration file and removed the app.config file.But it raise me below error, it always expect app.config file with <Startup> element to resolve this iss

Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0......

  
Hello to everyone. I have a .exe which uses the Server Management Objects(SMO) When I try it on my pc it runs without any problem. But on another pc it gives this error: Could not load file or assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. I'm using SQL Server 2000 and for the application: Visual Studio 2005. Any idea would be very useful!! Thanks in advance!!

Mixed mode assembly is built against version 'v2.0.50727' of the runtime and cannot be loaded in t

  
First, yes I've read every article I can find including this one: http://msmvps.com/blogs/rfennell/archive/2010/03/27/mixed-mode-assembly-is-built-against-version-v2-0-50727-error-using-net-4-development-web-server.aspx Of course it's for web server stuff, but I found this in my config file and added it. However, my problem now is that if I build in release mode I get a hard error in the error list telling me the same thing, even though it runs fine in debug and has the information in my app.config file. The really anoying part is that the error doesn't tell you WHICH assembly is the offending one. Anyone have any ideas?

Why windows service Looks for "Classlibrary2.resources Version=1.0.0.0...." assembly in resolver eve

  
In a simple Windows Service project, I have got below code. namespace WindowsService1 {     static class Program     {         /// <summary>         /// The main entry point for the application.         /// </summary>         static void Main()         {             System.Diagnostics.Debugger.Launch();             AppDomain.CurrentDomain.AssemblyResolve += new ResolveEventHandler(CurrentDomain_AssemblyResolve);             ClassLibrary2.Class1.Hello();         }         private static Assembly CurrentDomain_AssemblyResolve(object sender, ResolveEventArgs args)         {             return null;         }     } } Here "ClassLibrary2" is a simple class library project with couple resources and single class. No other settings are set. After installing WindowsService1, on starting the s

Could not load file or assembly 'TraceWrapper, Version=1.0.523.0, Culture=neutral, PublicKeyToken=3

  
Hello Friends, I am new in dot net. I am download SCVMM WCF code from Microsoft site and made some changes and build the solution "It is Successfully build" and Successfully RUN and Give the output. I got error when I browse the .svc file in browser. error message is below - Could not load file or assembly 'TraceWrapper, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. An attempt was made to load a program with an incorrect format. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } Server Error in '/' Application. Could not load file or assembly 'TraceWrapper, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. An attempt was made to l

Could not load file or assembly 'TraceWrapper, Version=1.0.523.0, Culture=neutral, PublicKeyToken=3

  
Hello Friends,   I am new in dot net. I am download SCVMM WCF code from microsof site and made some changes and build the solution "It is successfuly build" and Successfuly RUN and Give the output.   I got error when I browse the .svc file in browser. error message is below - Could not load file or assembly 'TraceWrapper, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. An attempt was made to load a program with an incorrect format. body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;} p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px} b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px} H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red } H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon } pre {font-family:"Lucida Console";font-size: .9em} .marker {font-weight: bold; color: black;text-decoration: none;} .version {color: gray;} .error {margin-bottom: 10px;} .expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; } Server Error in '/' Application. Could not load file or assembly 'TraceWrapper, Version=1.0.523.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. An attempt was mad

Could not load file or assembly 'Microsoft.Scripting.ExtensionAttribute, Version=2.0.0.0

  
Dear ASP.NET I keep getting this strange error (below) on my local machine on the first time the page loads, Then if I reload it - it loads correctly... What is really strange is that it does not happen on the server (same settings)   I'm using AJAXControlToolkit.dll version 4.1.40412.2 and this script manager (if not I get the Common.Common.js error)<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="AJAX" %> <AJAX:ToolkitScriptManager runat="server" ID="_scriptManager" AsyncPostBackTimeout="600" EnablePartialRendering="true" EnableHistory="true" />   I also tried to add this: <runtime> <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1"> <dependentAssembly> <assemblyIdentity name="Microsoft.Scripting.ExtensionAttribute" publicKeyToken="28f01b0e84b6d53e"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="4.0.0.0"/> </dependentAssembly> <dependentAssembly> <assemblyIdentity name="AjaxControlToolkit" publicKeyToken="31bf3856ad364e35"/> <bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="4.1.40412.0"/> </depende

Framework error:Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0

  
Hi,I use sql clr sp's to load data in to database using .net framework 2.0. I never had aproblem using this and it went well for months.I recently updated to net framework 3.5 sp1 and sqlserver sp3 on 32-bit sql server and win 2003.I am facing an error which i could not resolve.Error:System.IO.FileLoadException: Could not load file or assembly 'Microsoft.AnalysisServices, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)System.IO.FileLoadException:    at StoredProcedures.checktable(String paramComponent, String paramParameters)I have gone through different forums, and trie different options,but did not help. I am using 'unsafe'  option.I also tried to alter assembly which is mentioned in http://support.microsoft.com/kb/949080/pt But when i tried to alter the assembly using the above link or try to change the permission to external access on the assembly, i get the below error.Alter ASSEMBLY AccessibilityFROM 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Accessibility.dll'Cannot alter the assembly 'Accessibility', because it does not exist or you do not have permission.I am an admin on the server/sqlCan some one suggest how to alter assembly with permissions or solve this issue or am i missing anything important.Do i

SPPersistedObject and assembly version dependency

  
Hi All, I have implemented some SharePoint solution that uses SPPersistedObject-s, this solution has some DLL files which are versioned. So the problem is that when the DLL version changes, I can't see those object that were written with an old DLL version anymore, SPPersistedObject objects are the same(structure, etc ...) and they are still there, because if I add an old version back this objects are still there and I'm able to read it. Any suggestions, how this can "limitation" can be avoided? Any workaround? Any proper solution?   Best Regards and  Thank You, Mitja

File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF

  
I have Encountered with this problem when i am doing project for mobile application. I have installed sqlce.dev.ENU.ppc.wce5.armv4i.CAB,sqlce.repl.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,NETCFv2.wm.armv4i.cab My Deployment Cab File NewBatchScanCab_Data.CAB with all this following cab's. This Cab is running in another Computer's also but it is prompting error message as below: File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF1C8D2AD3',or one of its dependencies,was not found. I Wanna now why it is prompting this error message.

Cannot load file or assembly 'CLI.implementation, Version=2.0.2693.36850

  
All I wanted to do was update my ATI Catalyst and my video drivers... but no. I had to install a new version of the .NET framework. After installing .NET framework 3.0 from the Microsoft Updates page, I restarted my computer. Upon reaching the desktop, the ATI Catalyst Control Center would not open, giving me the message:     Cannot load file or assembly 'CLI.implementation, Version=2.0.2693.36850, culture=neutral, publickeytoken=90ba9c70f846762e' or one of it's dependencies. The system cannot find the file specified.     I'm really not savvy with this stuff, and I have no idea what to do. I'd like to learn, if not for bettering my knowledge than for the purpose of getting my Catalyst to work again.. Please help!

File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF

  
I have Encountered with this problem when i am doing project for mobile application. I have installed sqlce.dev.ENU.ppc.wce5.armv4i.CAB,sqlce.repl.wce5.armv4i.CAB,sqlce.wce5.armv4i.CAB,NETCFv2.wm.armv4i.cab My Deployment Cab File NewBatchScanCab_Data.CAB with all this following cab's. This Cab is running in another Computer's also but it is prompting error message as below: File or Assembly Name 'System.Data.SqlServerCe,Version=3.5.0.0,Culture=neutral,PublicToken=3BE235DF1C8D2AD3',or one of its dependencies,was not found. I Wanna now why it is prompting this error message.

Could not load file or assembly 'Compliance, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null'

  
We recently upgraded from .NET 1.1 to .NET 3.5. The project was running fine until yesterday when I tried to create a set up project. When I add a new Websetup project and rebuild solution I get error :  Error 79 Could not load file or assembly 'Compliance, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417) Y:\Development_Sites\Development_Server_RW\QMComet\SGEN Compliance Now when I run the project  , I get : Server Error in '/QMComet' Application. Parser Error Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Could not load type 'Jennison.Compliance.Global'.Source Error: Line 1: <%@ Application Codebehind="Global.asax.cs" Inherits="Jennison.Compliance.Global" %> Source File: /QMComet/global.asax    Line: 1     Please help. I wwas able to run the project before I tried to create a set up.   Thanks,Rohit

Assembly versioning best practice question wrt alpha, beta, etc

  
We'd like to employ some best practices with respect to versioning in our assemblies.  Since I'm coming from a Java+Maven+OSGi background, I'll share its way of doing versioning. Versioning in Java is arbitrary; there are no platform-dictated schemes.  However, for quite some time now, versions have the typical form major.minor.revision[.qualifier] where major & minor are pretty self-explanatory, revision is used to indicate very minor updates like bug fixes/hot fixes, etc, and qualifier is used at the publisher's convenience.  Almost always, the major, minor & revision elements are numeric values, but they don't have to be.  Ordering is as you might expect:  major versions are the most signficant element and are compared by the string's order unless their all numeric, in which case they're compared numerically, then minor, then revision, then qualifier, if present.  So, to give an example of the versioning scheme that a newly created library might go through, consider the following versions with descriptions: 1.0.0.A1 -- alpha 1 1.0.0.A2 -- alpha 2 1.0.0.B1 -- beta 1 1.0.0.M1 -- milestone 1 1.0.0.M2 -- milestone 2 1.0.0.RC1 -- release candidate 1 1.0.0.RC2 -- release candidate 2 1.0.0.RELEASE -- golden release to manufacturing, aka "official" release Notice that the version string for the version considered gol

Could not load file or assembly '0 bytes loaded from System, Version=2.0.0.0, Culture=neutral, Publ

  
Hi I have a clickonce deployed application in my machine. When I tried to load the application, 90% of the application window is getting loaded but finally, I get the following error: Could not load file or assembly '0 bytes loaded from System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. An attempt was made to load a program with an incorrect format. I have read somewhere that this error could be caused when something goes wrong with the .net framework in the machine. My machine is having .Net framework 2.0, 3.0 and 3.5. So which framework should I reinstall? The application is developed using .net 2.0. Also, please let me know how the application is partially loading(90%) if the framework is corrupted.? Regards Anoop.
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