Stored procedure output/return parameters
"Gunther Van Butsele" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds
logging.tar.gz
(application/x-gzip, 3.5 KB) - not displayed