SQL Stored Procedure with VARBINARY Parameter


#1

I have been having a ton of issues trying to run stored procedures with parameters. I created a extremely simple test stored procedure:

PROCEDURE [dbo].[APP_TEST]

(@test VARBINARY(18))

AS
BEGIN

	SELECT @test

END

And I get this error:

“message”: “Failed to call database stored procedure.\nCDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Implicit conversion from data type char to varbinary is not allowed. Use the CONVERT function to run this query.”

I get this error no matter what value I use as the test parameter including letting it default to NULL. It runs without error in SQL server managment Studio

Any help is appreciated.