Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.sqlserver.programming > #31302

Re: Create function: Could not find type xxx in assembly yyyy (msg

Show all headers | View raw

On Sunday, December 6, 2009 at 10:16:01 AM UTC-6, Frans wrote:
> Hi Erland,
> 
> the error message (My.SQLserver) is from another try.
> 
> This is the create function statement now:
> CREATE FUNCTION fnGetLastStepcompleted
> (
> 	@DossierID int
> )
> RETURNS INT 
> 
> AS EXTERNAL NAME [UDF_CLR].[UserDefinedFunctions].GetLastStepCompleted
> GO
> 
> Message: Could not find Type 'UserDefinedFunctions' in assembly 'UDF_CLR'.
> 
> 
> The Visual Studio 2008 package:
> 
> Public Class UserDefinedFunctions
>      Public Shared Function GetLastStepCompleted(ByVal DossierID As Integer) 
> As SqlString
>         Dim svc As New NotaflowClientService.ClientService
>         Dim D As New NotaflowClientService.Dossier
>         D = svc.GetDossier(DossierID, True)
>         Return (D.LastStepCompleted.ToString)
>     End Function
> 
> End Class
> 
> I debug and the UDF_CLR Assemblie is created.
> 
> It looks like syntax to me, but maybe it's something else.
> Help is appreciated.

I have the same issue. funtion built from Visualstudio 2008. Did you find a resolution to the issue?

Back to microsoft.public.sqlserver.programming | Previous | Next — Next in thread | Find similar

Thread

Re: Create function: Could not find type xxx in assembly yyyy (msg swetha.mandanapu@gmail.com - 2016-10-12 07:50 -0700
  Re: Create function: Could not find type xxx in assembly yyyy (msg Michael Cole <invalid@invalid.com> - 2016-10-13 09:06 +1100
    Re: Create function: Could not find type xxx in assembly yyyy (msg Erland Sommarskog <esquel@sommarskog.se> - 2016-10-13 13:42 +0000
      Re: Create function: Could not find type xxx in assembly yyyy (msg Michael Cole <invalid@invalid.com> - 2016-10-14 09:36 +1100

csiph-web