[freetds] Problem with CS_PARAM_RESULT (c API) and MSSQL2k
Leonid O Volkov
wolkow at rosnet.net
Fri Jun 3 10:52:40 EDT 2005
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
$ rpm -qa|fgrep freetds
freetds-0.63-1
freetds-devel-0.63-1
client OS and hardware architecture:
2.6.11-1.27_FC3smp #1 SMP Tue May 17 20:38:05 EDT 2005 x86_64 GNU/Linux
FedoraCore 3
or
2.4.18-18.7.xsmp #1 SMP Wed Nov 13 19:01:42 EST 2002 i686
Redhat 7.3
build:
test.c - see in attach
$ gcc -c test.c
$ gcc test.o -lct -ltds -lsybdb -ldl -ltdssrv -o test
connect to MSSQL 2000
$ ./test mssql2000
Connect to mssql2000 succeed.
declare @REASON integer exec BUGPROC @REASON out
CS_STATUS_RESULT
Fetch done successfully.
CS_CMD_SUCCEED
ct_result returned CS_CMD_DONE.
switch (ret) = CS_END_RESULTS.
result=1
connect to MSSQL 7.0
$ ./test mssql7
Connect to mssql7 succeed.
declare @REASON integer exec BUGPROC @REASON out
CS_STATUS_RESULT
Fetch done successfully.
CS_PARAM_RESULT !!!!!
reason=99 !!!!!
All done processing rows.
CS_CMD_SUCCEED
ct_result returned CS_CMD_DONE.
switch (ret) = CS_END_RESULTS.
result=1
By means of what can I get CS_PARAM_RESULT by using MSSQL2k ?
--
Leonid O Volkov Rosnet JSC (+7 095)7813293
http://wolkow.rosnet.ru wolkow at rosnet.ru
nic-hdl: LOV1-RIPN, LOV1-RIPE
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test.c
Type: text/x-csrc
Size: 7849 bytes
Desc: not available
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20050603/bd1d5af5/attachment.bin
More information about the FreeTDS
mailing list