[freetds] stored procedure execution failed in PHP
German Anguiano Bayardo
ganguiano at villadealvarez.gob.mx
Wed Oct 15 14:49:40 EDT 2008
Hi all !
I have Apache2 + PHP5 + FreeTDS + mssql.so running in Ubuntu Server 8.04
We have a website, using PHP scripts wich connects to a SQL Server to
fetch information.
The site was created by another person, not me. And he doesn't use
Unix/Linux, only Microsoft, so all test he has done is
using IIS and MS SQL Server. And says everything works fine.
But in this server, Linux + Apache, We have some problems.
In the main page, he runs a stored procedure and when loading the page
we get:
"stored procedure execution failed in XXXXX"
you can see the page at: https://tesoreria.villadealvarez.gob.mx
and in freetds.log, the only message that looks strange to me is this:
12:23:02.010478 setting column 2 NULL bit
12:23:02.010491 tds_submit_query(): state is PENDING
12:23:02.010506 tds_client_msg: #20019: "Attempt to initiate a new SQL
Server operation with results pending.". Connection state is now 1.
12:23:02.010601 Sending packet
I have PHP 5 , Apache 2 and FreeTDS version 0.63
Any ideas ? I'm new to FreeTDS and is the first time I set up a Linux
server to work with SQL Server.
Thanks for ypur help.
More information about the FreeTDS
mailing list