FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Lowden, James K wrote:
> >> Any one can tell me if there some bug on freetds 0.63 invoking a
> >> stored procedure on MSSQL?. i' ve developed an application in C
> >>
> >>     
> > It seems you're using a NULL parameter for a column with a weird
> > datatype, and we don't determine the size correctly.  :-/
> >
> >   
> >> what is the solution?.  
> >>     
> >
> > Use a different datatype, I think.  
> >
> > --jkl
> >
> >   
> 
> So it has nothing to do with the problems posted half a year 
> ago and did 
> not get any reply on?
> 
> this one:
> 
> Hello.
> I have some trouble passing (var)char data to and from stored 
> procedures.
> 
> I made a page that describes the problem and all i did in detail, 
> including the files and logs, at 
> http://kb.vankoperen.nl/freetds-problems.html
> 
> I am not entirely sure it is a problem of FreeTDS or perhaps 
> of PHP, So 
> if this is a mispost please do excuse my ignorance.
> 

I added a test
http://freetds.cvs.sourceforge.net/*checkout*/freetds/freetds/phptests/r
pc2.php?revision=1.1. Currently is not working so I suspect a problem.

> 
> Here is a short version of the text:
> 
> 
> Installed FreeTDS-0.63 on a RHEL4 box with Apache-2.0.55 and 
> PHP-5.1.2, 
> connecting to a server running win2003 server standard edition and 
> sqlserver 8.00.818. It all runs fine, untill i want to pass Character 
> data to or from a storedprocedure.
> 
> I am not sure this is a known problem (i think not, no info 
> on it on the 
> net at all) and if parhaps anyone else has it, but here it is.
> 
> FreeTDS.conf:
> [global]
>         tds version = 8.0
>         text size = 20000
> 
> [TDS]
>         host = 192.168.5.251
>         port = 2433
>         tds version = 8.0
>         dump file = /var/log/freetds.log
>         dump file append = yes
>         debug level = 99
> 
> 
> Using the standard mssql_init / mssql_bind / mssql_execute 
> structure to 
> pass the data (see the kb page for the exact scripts)
> 
> 
> 1:
> Inputting an INT4 is no problem:
> 
>     # ./sptest1.php
>     test1= 35
>     retval = 350
> 

I don't understand why but current version seems unable to report return
value....

> 2:
> Inputting a VARCHAR however always fails:
> 
>     # ./sptest2.php
> 
>     Warning: mssql_bind(): Unable to set parameter in 
> /var/lib/asterisk/agi-bin/sptest2.php on line 19
> 
>     Warning: mssql_execute(): message: Procedure 'sp_Test2' expects 
> parameter '@test1', which was not supplied. (severity 16) in 
> /var/lib/asterisk/agi-bin/sptest2.php on line 24
> 
>     Warning: mssql_execute(): stored procedure execution failed in 
> /var/lib/asterisk/agi-bin/sptest2.php on line 24
>     Last message from SQL : Procedure 'sp_Test2' expects parameter 
> '@test1', which was not supplied.
> 

I didn't get this problem.

> 
> 3:
> Outputting an INT4 is no problem:
>     # ./sptest3.php
>     test1= 10
>     retval = 3
> 
> 
> 4:
> Outputting a VARCHAR is extremely strange,
> sometimes its okay:
> 
>     # ./sptest4.php
>     test1= xyz45678
>     retval = 4
> 
> but sometimes not:
> 
>     # ./sptest4.php
>     Warning: mssql_execute(): Error converting client characters into 
> server's character set. Some character(s) could not be converted. 
> (severity 16) in /var/lib/asterisk/agi-bin/sptest4.php on line 24
> 
>     Warning: mssql_execute(): stored procedure execution failed in 
> /var/lib/asterisk/agi-bin/sptest4.php on line 24
>     Last message from SQL : Changed database context to 'IVR'.
> 
> And thats the same script executing, mind you. nothing changing, just 
> randomly succeeding and failing.
> 

Is not random it depends on string you pass, if string cannot be
translated is expected.

> Now, if i cut off the output to 13 characters or less:
>     mssql_bind($proc, "@test1", &$test1, SQLVARCHAR, TRUE, FALSE, 13);
> then it will not fail.

Probably cause invalid characters appear after 13th character.

> It will only fail (sometimes) when the data cutoff is bigger (even if 
> the returned data is small!)
> 
> I suspect some buffer problem here ?
> 

Could you provide some examples?

> 
> I have, simply put, no idea what is going on here.
> Any tips or assistance is very welcome.
> 

We have some problems actually
- it seems that PHP (I used version 5.1) is not able to get results from
store procedure... not fine
- when you pass an invalid sequence libTDS send an invalid request...
not good either, server close connection.. it should automatically
cancel request

> 
> 
> Yours gratefully,
> E.B. van Koperen.
> 
> ps. tds version used: freetds-0.63
> 

Usually my steps to resolve a problem are
1- analize the problem
2- reproduce it with a test
3- make the test works
4- repeat steps 1-3 until happy
5- backport if possible (and easy). We should release 0.64 and
developing on CVS HEAD started some months ago so I cannot promise a
backport to 0.63 but I would solve the problem for 0.64.

freddy77