PHP and MSSQL problem with query

[BB101]

I am currently building a web application with PHP, MSSQL and a lot of javascript.

I have a problem on one of my pages.

The query:
exec spCCH_ChapterAta_List 'Hercules01'
Does not run in the PHP, no error is returned, just "Query failed", but it runs in query analyzer; however I can run:
exec spCCH_ChapterAta_List 'BenTest'
Just fine, works in both.

Anyone had any problems like this before?

Thanks

--BB

 

[sleipnir214]

What are you doing to output errors from your query?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

$query = mssql_query($SQL, $this->_DBCon) or (DIE(&quot;ERROR IN <b><pre>&quot;.htmlentities($SQL).&quot;</pre></b><br><b>&quot;.mssql_get_last_message().&quot;</b>&quot);


The error returned from mssql_get_last_message simply says database context changed, which is correct.

Thanks

--BB

 

[sleipnir214]

Just to ask the dumb question....

You have verified that giving that stored procedure an input of 'Hercules01' will return data, right?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

yes, everything works fine in query analyzer, just fails in PHP

--BB

 

[sleipnir214]

I'm stumped, so I'll throw something random out.

Are you using the same user credentials from both PHP and the Query Analyzer?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

yes, this is a rebuild of the original frontend; ASP (ick), to PHP (yum).

--BB

 

[sleipnir214]

You didn't answer my question.

When you login to M$SQL using Query Analyzer, are you using the same userid and password that your PHP code is?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

yes, I am logging in with the same creditials... its not an MSSQL problem, its a PHP problem.

I'm not new to this coding lark, but this has me stumped

--BB

 

[BB101]

server is running 2k, IIS, PHP 4.3.1 under isapi with mssql, pdflib, mysql, gd2.

Worked fine a few days ago.

/me harasses his IT department

--BB

 

[sleipnir214]

What changed a few days ago?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

We had a power cut... otherwise apart from the date its all the same

--BB

 

[sleipnir214]

That's odd.

Have you taken the step of having PHP output the query to a web page, then cutting and pasting that query to QA?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

yes, pasted code into QA works fine!

I've done all the obvious things, I'm stuck!

--BB

 

[sleipnir214]

I'm out of ideas, too.

What's your PHP run environment?
How are you connecting to MSSQL?
What version of MSSQL are you running?


Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

PHP environment:
IIS, PHP 4.3.1 isapi, mssql, pdflib, sockets, gd2

Connecting to mssql through mssql library with PHP

MSSQL version 2000, running on the same box

--BB

 

[sleipnir214]

I'm racking my brain...

I had a similar problem once where a query would run through QA but not through ASP. But it was more than 5 years ago, so I don't remember what my fix was.

I don't run PHP on Win32, but on Linux. Does the MSSQL communication library ship with PHP, or do you need to use one supplied by Mi&cent;ro$oft?

I'm just trying to classify the differences between now QA would query the database and how PHP would.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[BB101]

The mssql library ships with PHP, i don't think microsoft ever got near it (though I could be wrong).

--BB