[freetds] Problem with CS_PARAM_RESULT (c API) and MSSQL2k
James K. Lowden
jklowden at freetds.org
Sat Jun 4 13:48:06 EDT 2005
Leonid O Volkov wrote:
> Hello, I am new in this list.
>
> I have problem with returning CS_PARAM_RESULT
> from exec stored procedure for MSSQL2k (in MSSQL7.0 no problem):
>
> "declare @REASON integer exec BUGPROC @REASON out"
>
> CREATE procedure BUGPROC
> @REASON int output
> as
> set nocount on
> set @reason = 99
> return 1
> GO
>
> I have FreeTDS version 0.63
...
> By means of what can I get CS_PARAM_RESULT by using MSSQL2k ?
As Frediano said, with SQL Server 2000 you can't get output parameter
values from a language command like "declare @REASON integer exec BUGPROC
@REASON out". Beginning actually with IIRC SP3 of SQL Server 7.0, the
server no longer returns the parameter output values to the client when a
stored procedure is invoked that way. You have to use the RPC functions
instead.
Have a look at these:
$ ls src/ctlib/unittests/r*
src/ctlib/unittests/rpc_ct_param.c
src/ctlib/unittests/rpc_ct_setparam.c
HTH.
--jkl
More information about the FreeTDS
mailing list