Help Troubleshoot "Could not find Type in assembly"

Hot Topic

Currency Symbol Problem
row-based isolation levels
XACT_ABORT
MOVING DATA BETWEEN SERVERS
How to retrieve unary operator for member?
COLUMN SCOPE IN T-SQL STATEMENT
Can't install sql server 2005
32bit SQL 2000 to 64bit SQL 2005
Connecting two cubes
compare two text files

SQL Server

SQL Server Authentication + SSL
How to integrate many authorization database in one RS
The value could not be converted because of a potential loss of data in SSIS package
Basing Report on a Procedure with Cursor
I wrote my own configuration tool to maintain the connection strings in a SQL table
Puzzled by concurrent update
Stored Procedure Problem - Couldn't find forum specifically for SP's
String to Date Conversions
green-bar for list
Query Tool from SQL Server 2K Missing in 2k5 Edition?

Help Troubleshoot "Could not find Type in assembly"

I am attempting to create a CLR Procedure.  I was able to create the assembly, but I am unable to create a procedure on the assembly.  This is the error I receive:

Msg 6505, Level 16, State 1, Procedure DINEServiceProc, Line 2

Could not find Type 'DINEServiceProc' in assembly 'DINEService'

Here is the VB code to create the class:

<code>

Imports System

Imports System.Data

Imports System.Data.Sql

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Partial Public Class DINEServiceProc

<Microsoft.SqlServer.Server.SqlProcedure()> _

Public Shared Sub ServiceProc(ByVal iMsg As String, ByVal iMsgType As String)

Dim conn As SqlConnection

'Create an in-process connection to the instance of SQL Server

conn = New SqlConnection("Context Connection=True")

Dim DINEService As New DINEService

Try

conn.Open()

DINEService.ProcessStartRequest(iMsg, iMsgType)

Catch sqe As SqlException

'Console.WriteLine(sqe.Message)

Return

Finally

conn.Close()

End Try

End Sub

End Class

</code>

And here is the code to create the assembly and the procedure:

<code>

USE [ServiceBrokerTest]

GO

/****** Object: SqlAssembly [DINEService] Script Date: 01/03/2006 10:38:00 ******/

CREATE ASSEMBLY [DINEServiceProc]

AUTHORIZATION [dbo]

FROM 'D:\EHIT\ServiceBroker\DINEService\DINEService\bin\Debug\DINEService.dll'

WITH PERMISSION_SET = SAFE

GO

CREATE PROCEDURE dbo.DINEServiceProc

(

@msg nvarchar(MAX),

@msgType nvarchar(MAX)

)

AS EXTERNAL NAME DINEServiceProc.DINEServiceProc.ServiceProc;

</code>

What am I doing wrong here



Answer this question

Help Troubleshoot "Could not find Type in assembly"

  • mstngslly316

    I had similar problems. I found I was using the wrong case for the namespace. I found the "MSIL Disassembler" helped me solve my problems.

  • Rajan K

    Thanks, for your reply!

    I also use C# and the problem occurred for me as well, you've saved me a lot of time. Wink

    Regards,
    Peter Larsson!


  • Cameron Zawalykut

    As this is a vb assembly I'd say you're falling foul of VB creating a default namespace around your classes. Have a look in ildasm or reflector at your assembly and see if you don't have a namespace in there. In which case the EXTERNAL NAME in your CREATE PROCEDURE statement should look like so: AS EXTERNAL NAME DINEServiceProc.[NamespaceName.DINEServiceProc].ServiceProc.

    Niels

  • Nigel Stratton

    I just had the same problem. It seems C# also does the same thing with the 'hidden' namespace. The documentation and error message should be updated to include this condition.

    -Lukasz



  • techvistas

    I had the same issue, and this was the fix. Thanks for postings!!!

  • Bruno Estrozi

    As nielsb said, you're running into the VB default namespace issue. 

    CREATE PROCEDURE ....

    AS EXTERNAL NAME [DINEServiceProc].[DINEServiceProc.DINEServiceProc].[ServiceProc]

    should work for you.



  • Gangadhar

    Hi

    I just wanted to thank you folks for this one (i.e. The NAMESPACE ).

    I have been battling with this morning. The problem that I found was.. that in the example that I was following, the author has manually compiled the .dll in a directory with a similar name to that of the namespace and warns you in the creation of the assembly to use the fully qualified path to the directory . This is true and worked out fine.

    Where I came unstuck was in the creation of the Stored Procedure by passing the same fully quailified path (minus the c:\ ) INSTEAD of the namespace.

    BTW I was using C#

    regards Steve

  • thegrinch

    Yes, that was it.  Thanks to both of you.
  • Help Troubleshoot "Could not find Type in assembly"
Answer this question