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: [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.