[freetds] Stored procedure output/return parameters

Gunther Van Butsele gvb at velleman.be
Wed Apr 30 09:29:15 EDT 2008


Hi Guys, 
 
I've been collecting logging information to debug my problem with output
parameters not getting filled in php using the freetds functions.
 
I've attached an archive with every bit of info I could gather:
 
   stored_procedure_creation.sql - The stored procedure itself
   script.php - PHP script that calls the stored procedure
   sql_profiler.log - MS SQL Profiler log entry for the call to the
stored procedure
   tdsdump.log - TDSDUMP log, probably most useful to you
 
Versions used:
 
1) Database server:
Microsoft SQL Server 2000
Microsoft Windows 2000
 
2) Web server:
FreeBSD 6.2-RC1
php5-5.2.5
freetds-msdblib-0.64
php5-mssql-5.2.5
apache-2.2.8

Calling my stored procedure from PHP never fills the output parameter
@Enabled ($canLogin). $canLogin always remains 666.

Hope someone can help finding out what the problem is exactly.

Kind regards,
Gunther
-------------- next part --------------
A non-text attachment was scrubbed...
Name: logging.tar.gz
Type: application/x-gzip
Size: 3634 bytes
Desc: logging.tar.gz
Url : http://lists.ibiblio.org/pipermail/freetds/attachments/20080430/1514b176/attachment.gz 


More information about the FreeTDS mailing list