PHP with MSSQL (error) help!

Atiq

I am using php with MSSQL.

I am trying to run a procedure from php script.

When i ran the same procedure from Query Analyzer it returned 14 rows.

But when i tried to run it from php script and tried to get the total number of rows back i got this error:

Fatal error: Call to a member function on a non-object in c:\program files\apache group\apache\htdocs\cms\overall_score_pdf.php on line 8

Please note that i am using adodb . This is my code:

$ADODB_FETCH_MODE = ADODB_FETCH_NUM;
$record1 = $DB_CONNECTION->Execute('SP_Overall_Result');
$TOTAL_RECORDS = $record1->RecordCount();
echo "total=".$TOTAL_RECORDS; (this is line 8 in my script)
exit;

This code is working with all other procedures but not with this . In SQL Server this procdure took 58 seconds to give results.

melody

This error means that php is not loading the mssql extensions. Taken from the manual at :

http://php.us.themoes.org/manual/en/ref.mssql.php

Installation

The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini.

To get these functions to work, you have to compile PHP with --with-mssql[=DIR], where DIR is the FreeTDS install prefix. And FreeTDS should be compiled using --enable-msdblib.

If you installed a precompiled package, you may not have to install again. Add extension=php_mssql.dll to the php.ini file and restart your computer. If you still get the same message, you might have to compile the source or download a binary which has already been compiled with SQL Server functions.

Hope this helps. :-)

Melody

Atiq

I have solved the problem.

The procedure was taking too long time to execute and my php.ini setting for mssql.timeout was set to 60sec .

So as procedure was not resplonding in 60 sec so i was getting the error.

I increased the time to 500 and now i am getting the out put.

Thanks for help any way.

Regards,

Atiq