Return
-
Title
ODBC Error Microsoft SQL Server Native Client 10 Must declare the scalar variable -
Description
Trying to load test a store procedure but running into issues with parameters
Error ODBC Error (37000, 89) - [Microsoft][SQL Server Native Client 10.0][Must declare the scalar variable "@in_PROPERTY_ID] -
Resolution
When running a SQL test using an ODBC connection, we should change the parameters to '?' manually.
(ie in the SQL Statement window, change the @ParamName to “?” - see screenshot attached)
-
Attachments