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

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

X-Received	by 10.13.218.197 with SMTP id c188mr372946ywe.144.1476283804017; Wed, 12 Oct 2016 07:50:04 -0700 (PDT)
X-Received	by 10.157.52.205 with SMTP id t13mr198750otd.8.1476283803960; Wed, 12 Oct 2016 07:50:03 -0700 (PDT)
Path	csiph.com!feeder.erje.net!2.us.feeder.erje.net!news.glorb.com!f6no218983qtd.0!news-out.google.com!w143ni788itb.0!nntp.google.com!l13no321607itl.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.programming
Date	Wed, 12 Oct 2016 07:50:03 -0700 (PDT)
In-Reply-To	<71FD2003-4B18-47D2-A11F-69CEECC48D3C@microsoft.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=161.51.0.52; posting-account=O7iXpAoAAAC1OotNA8U4ELnLf7TRgBUX
NNTP-Posting-Host	161.51.0.52
References	<AB84A7E2-4598-455F-826C-095B7C9488D7@microsoft.com> <Xns9CD99E44284B8Yazorman@127.0.0.1> <71FD2003-4B18-47D2-A11F-69CEECC48D3C@microsoft.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<ebb47c7e-3497-4d5b-866c-12576bab0382@googlegroups.com> (permalink)
Subject	Re: Create function: Could not find type xxx in assembly yyyy (msg
From	swetha.mandanapu@gmail.com
Injection-Date	Wed, 12 Oct 2016 14:50:03 +0000
Content-Type	text/plain; charset=UTF-8
Xref	csiph.com microsoft.public.sqlserver.programming:31302

Show key headers only | 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