MSS Stored procedure call "Must declare @p0"
Posted: Fri 06 Oct 2017 16:00
SQL Server : 2016
I am evaluating the driver and hoping to move to DEVART ODBC driver from SQL Server ODBC driver (V13) to improve performance of application.
The following code works fine with SQL Server ODBC driver, but not with DEVART.
Im using ODBC to call a stored procedure as follows
At SQLExecDirect, I get message
"[Devart][ODBC][Microsoft SQL Server]Must declare the scalar variable "@p0"."
Im not using a @p0.
Any ideas on what might cause this.
Thanks
Daniel
I am evaluating the driver and hoping to move to DEVART ODBC driver from SQL Server ODBC driver (V13) to improve performance of application.
The following code works fine with SQL Server ODBC driver, but not with DEVART.
Im using ODBC to call a stored procedure as follows
Code: Select all
SQLAllocStmt(..)
SQLBindParameter return value (OUTPUT)
SQLBindParameter X 3 for INPUT PARAMS
SQLBindParameter for last OUTPUT parameter
SQLExecDirect("{? = call MYPROC(?,?,?,?)}");
"[Devart][ODBC][Microsoft SQL Server]Must declare the scalar variable "@p0"."
Im not using a @p0.
Any ideas on what might cause this.
Thanks
Daniel