<div>
I believe you want that to be a sub and not a function. 
 
Currently Confirmation looks like a scalar function from the SQL side.
</div>

<div>
Hey Kyle... 
I was able to get it to resolve by changing things to NVARCHAR 
 

<pre><code class="code-1 nolinks" id="code-20-42096100-1">CREATE FUNCTION [dbo].[HelloEveryware] (@user NCHAR(100), @token NCHAR(100), @PID NCHAR(100),@ProspectID NCHAR(100))
RETURNS NCHAR(255) WITH EXECUTE AS CALLER
AS EXTERNAL NAME [HelloEveryware].[HelloEveryware.PassIn].[Confirmation];
</code></pre>
 
Now I am getting the message at the end on this select... 

<pre><code class="code-1 nolinks" id="code-20-42096100-2">Select dbo.HelloEveryware( 'User', 'Token', 'PID', 'ProspectID')
</code></pre>
 
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
</div>

<div>
you have to grant permissions on the assembly: 
 
eg: 

<pre><code class="code-1 nolinks" id="code-20-42096106-1">grant external access assembly to [user]
grant external access assembly to sa
</code></pre>
</div>

<div>
Kyle, 
&nbsp;This assembly is in... 
SELECT * FROM [TangoCRMCTCGGV5].sys.assemblies 
 
When I run this... 
GRANT EXTERNAL ACCESS ASSEMBLY TO lbrister 
 
I get this message 
Permissions at the server scope can only be granted when the current database is master 
 
When I run from master... error as well?
</div>

<div>
Ensure CLR is enabled: 
 

<pre><code class="code-10 nolinks" id="code-20-42096144-1">sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO

sp_configure 'show advanced options', 0;
GO
RECONFIGURE;
GO
</code></pre>
 
ensure your project is built with external access (or safe) and that the assembly was created that way. &nbsp;(You can right click -&gt; script assembly).
</div>

<div>
Ran all of that.. 
When I do a select on sys.assemblies I get... 
helloeveryware, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil 
SAFE_ACCESS 
 
When I resistall the assembly and function and run I am still getting... 
&nbsp;Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
 
Then I try and grant permissions... and get this. 
Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself.
</div>

<div>
I'll try in the morning when I return to my desk
</div>

<div>
Sorry for the very late get back... actually took my first vacation in 5 years.
</div>

<div>
<div class="content wysiwyg-content">
I have an assembly I added to SQL 
It has 4 parameters in the vb code that are all string 
 
 
In SQL Server I added the assembly... 
But when I try and run this... 
CREATE PROCEDURE [dbo].[HelloEveryware] (@user VARCHAR(100), @token VARCHAR(100), @PID VARCHAR(100),@ProspectID VARCHAR(100) ) 
--RETURNS BIT WITH EXECUTE AS CALLER 
AS EXTERNAL NAME [HelloEveryware].[HelloEveryware.PassIn].[Confirmation]; 
 
I get this message 
Msg 6552, Level 16, State 3, Procedure HelloEveryware, Line 1 
CREATE PROCEDURE for &quot;HelloEveryware&quot; failed because T-SQL and CLR types for parameter &quot;@user&quot; do not match. 
 
the VB side of this is... 
 
Partial Public Class PassIn 
&nbsp; &nbsp; &lt;Microsoft.SqlServer.Server.SqlFunction&gt; 
&nbsp; &nbsp; Public Shared Function Confirmation(user As String, token As String, PID As String, ProspectID As String) As Int32
</div>
</div>

I have an assembly I added to SQL 
It has 4 parameters in the vb code that are all string


In SQL Server I added the assembly...
But when I try and run this...
CREATE PROCEDURE [dbo].[HelloEveryware] (@user VARCHAR(100), @token VARCHAR(100), @PID VARCHAR(100),@ProspectID VARCHAR(100) )
--RETURNS BIT WITH EXECUTE AS CALLER
AS EXTERNAL NAME [HelloEveryware].[HelloEveryware.PassIn].[Confirmation];

I get this message
Msg 6552, Level 16, State 3, Procedure HelloEveryware, Line 1
CREATE PROCEDURE for "HelloEveryware" failed because T-SQL and CLR types for parameter "@user" do not match.

the VB side of this is...

Partial Public Class PassIn
 <Microsoft.SqlServer.Server.SqlFunction>
 Public Shared Function Confirmation(user As String, token As String, PID As String, ProspectID As String) As Int32

T-SQL and CLR parameter strings

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

An assembly language (or assembler language) is a low-level programming language for a computer or other programmable device in which there is a very strong (generally one-to-one) correspondence between the language and the architecture's machine code instructions. Each assembly language is specific to a particular computer architecture, in contrast to most high-level programming languages, which are generally portable across multiple architectures, but require interpreting or compiling. Assembly language is converted into executable machine code by a utility program referred to as an assembler; the conversion process is referred to as assembly, or assembling the code.