Re: mssql_execute problems...
| From: | T. Rader | Date: | Mon, 28 Jul 2003 16:10:48 +0000 |
| Subject: | Re: mssql_execute problems... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-157199@lists.php.net to get a copy of this message | ||
Any takers on this?
"T. Rader" <thoth@monkeymedic.com> wrote in message
news:20030725181011.56828.qmail@pb1.pair.com...
> Hey,
>
> System: RH9, Apache 1.3.27, PHP 4.3.2, FreeTDS 0.61 connecting to a Win2K
> Server, MSSQL Server 2K
>
> Problem: mssql_execute hangs when run. The script just never comes back.
> The code is as follows:
> $macn = mssql_connect("SERVER", "UID", "PWD");
> mssql_select_db("DB");
> $stmt = mssql_init("dbo.Grade2_GET", $macn);
> $result = mssql_execute($stmt);
>
> I have compiled PHP with the --with-mssql option so it does find the
> functions. Also, the Stored Proc will run just fine if executed via
> mssql_query(). But, I have some stored procedures that have output
> parameters and thus I need to use mssql_execute(). I have searched rather
> extensively on the 'net, and have seen a couple of posts about people
saying
> that it works correctly for them, but I am unable to get it to work. I
have
> even gone as far as to try the nightly build of FreeTDS (0.62) just to
see.
> Also, my env for TDSVER = 7.0 per documentation
>
> Does anyone have any ideas? I am currently stumped and cannot seem to
find
> any answers via research...
>
> TIA,
> Tom
>
>
>