[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