Skip to Content.
Sympa Menu

freetds - Re: PHP4.05, Apache 1.3.20, FreeTDS 0.51-0.52 & use of stored procedures

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steve Langasek <vorlon AT netexpress.net>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: Re: PHP4.05, Apache 1.3.20, FreeTDS 0.51-0.52 & use of stored procedures
  • Date: Fri, 29 Jun 2001 09:41:47 -0500 (CDT)


Hi Dmitry,

On Fri, 29 Jun 2001, Dmitry Komarov wrote:

> I have installed FreeTDS on my Linux system to connect to my MS-SQL 6.XX
> server from PHP4 scripts. It works quite well, BUT... When I try to execute
> a stored procedure from my SQL server, the Apache child dies with a
> "Segmentation fault" message in the error_log file. Trivial "SELECT",
> "INSERT" etc queries work just fine. What should be the reason for this?...

> I use the following syntax:

> $result = mssql_query("execute WWWGetInfo @CustId='BnRd', @Lang = 'LV'",
> $connect_id );

> May be I should use another way of calling stored procedures?

I'm really a novice when it comes to MS SQL, but does this work for you?

$result = mssql_query("WWWGetInfo 'BnRd','LV'", $connect_id);

If I understand correctly the intended meaning of your query string, this is
how I would do (and have done) the same thing using FreeTDS+perl.

Regards,
Steve Langasek
postmodern programmer





Archive powered by MHonArc 2.6.24.

Top of Page