List Info

Thread: Error running a CLR Stored Proc in SQL Server 2005




Error running a CLR Stored Proc in SQL Server 2005
user name
2006-11-07 14:48:22
I get this message when I run a C# CLR Sotred Procedure:

Msg 6522, Level 16, State 1, Procedure
usp_clr_transform_xml, Line 0
A .NET Framework error occurred during execution of user
defined
routine or aggregate 'usp_clr_transform_xml':
System.IO.FileLoadException: The located assembly's manifest
definition

does not match the assembly reference. (Exception from
HRESULT:
0x80131040)
System.IO.FileLoadException:
   at StoredProcedures.usp_clr_transform_xml(SqlXml
inputXml, SqlXml
inputTransXml)


I have droped the stored procedures associated to the
assembly and
droped the assembly.  I then redeployed the assembly back
into SQL
Server.  I have no problems with my sqlexpress running on my
desktop,
this is only an issue when I deploy to our multiuser
servers.


Any help would be appreciated.


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the
Google Groups "C# Community" group.
To post to this group, send email to csharpgooglegroups.com
To unsubscribe from this group, send email to
csharp-unsubscribegooglegroups.com
For more options, visit this group at http
://groups-beta.google.com/group/csharp?hl=en
-~----------~----~----~----~------~----~------~--~---

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )