Re: Re: mssql_execute problems...
| From: | Adam Voigt | Date: | Mon, 28 Jul 2003 16:13:16 +0000 |
| Subject: | Re: Re: mssql_execute problems... | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-157200@lists.php.net to get a copy of this message | ||
Umm, try setting TDSVER to 8.0 is all I could say to try.
On Mon, 2003-07-28 at 12:10, T. Rader wrote:
> 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
> >
> >
> >
--
Adam Voigt (adam@cryptocomm.com)
Linux/Unix Network Administrator
The Cryptocomm Group