MSSQL_QUERY sometimes returns "Query failed in..."

capweb

Running on Windows XP, FreeTDS, PHP

I can successfully run my php script from a Linux box with FreeTDS and PHP but when I attempt to run it on my XP box with FreeTDS and PHP the query statements randomly come up with "Query failed...". Typically the first one or two queries succeed but after than they typically fail. I cannot figure out any rhyme or reason for the failures. If I comment out the first one or two queries then most of the time the ones below will work. Haven't found anything googling around that seems to be the reason.

Given the randomness of the failures it seems to me that it might be some resource issue but I cannot narrow it down.

Thanks
Rodney

PHP script:

$link=mssql_connect("idxserver", "myusername", "mypassword");

$result=mssql_query( "SELECT COUNT(*) FROM IDX_CFF;");
while( $row = mssql_fetch_row( $result)){
echo "IDX_CFF row count: ".$row[0]." ";
}

$result=mssql_query( "SELECT COUNT(*) FROM IDX_KEEPLIST;");
while( $row = mssql_fetch_row( $result)){
echo "IDX_KEEPLIST row count: ".$row[0]." ";
}

$result=mssql_query( "SELECT COUNT(*) FROM IDX_RES_NS;");
while( $row = mssql_fetch_row( $result)){
echo "IDX_RES_NS row count: ".$row[0]." ";
}

$result=mssql_query("SELECT COUNT(*) FROM IDX_MLT_NS;");
while( $row = mssql_fetch_row( $result)){
echo "IDX_MLT_NS row count: ".$row[0]." ";
}

$result=mssql_query( "SELECT COUNT(*) FROM IDX_LAND_NS;");
while( $row = mssql_fetch_row( $result)){
echo "IDX_LAND_NS row count: ".$row[0]." ";
}

mssql_close($link);

sneakyimp

Do you have a more detailed error message? Does it always fail on the same query? Are you sure that you have set up your DB properly on the windows machine?

capweb

sneakyimp;10903067 wrote:
Do you have a more detailed error message? Does it always fail on the same query? Are you sure that you have set up your DB properly on the windows machine?

This is the error message (not much here):

Warning: mssql_query() [function.mssql-query]: Query failed in C:\cwc\idxteam\site\idxload\freetds.php on line 99

The database is on a machine in N.C.. I am writing code to access the database. If I run the exact same php script on my production Linux box is works just fine. Since the failure is "random" it seems to me to be a resource issue but I have not found anything on the web to point me to the issue.

Weedpacket

capweb wrote:
(not much here):

What the DBMS did respond with (seeing as it wasn't a result set) should be available in [man]mssql_get_last_message[/man].

capweb

Weedpacket;10903106 wrote:
What the DBMS did respond with (seeing as it wasn't a result set) should be available in [man]mssql_get_last_message[/man].

Thanks Weedpacket.

That is what I thought but there is nothing returned by mssql_get_last_message.

The following is php script and it is followed by the results of the script.

[INDENT]<?
$link=mssql_connect("idxserver", "capital!web", "phillips?rodney");

$result=mssql_query( "SELECT COUNT(*) FROM IDX_CFF", $link);
if(!$result)
{
[INDENT] die('MSSQL error: ' . mssql_get_last_message());[/INDENT]}
$row = mssql_fetch_row( $result);
echo "IDX_CFF row count: ".$row[0]." ";
mssql_free_result($result);

$result=mssql_query( "SELECT COUNT(*) FROM IDX_KEEPLIST", $link);
if(!$result)
{
[INDENT] die('MSSQL error: ' . mssql_get_last_message());[/INDENT]}
$row = mssql_fetch_row( $result);
echo "IDX_KEEPLIST row count: ".$row[0]." ";
mssql_free_result($result);

$result=mssql_query( "SELECT COUNT(*) FROM IDX_RES_NS", $link);
if(!$result)
{
[INDENT] die('MSSQL error: ' . mssql_get_last_message());[/INDENT]}
$row = mssql_fetch_row( $result);
echo "IDX_KEEPLIST row count: ".$row[0]." ";
mssql_free_result($result);

$result=mssql_query("SELECT COUNT(*) FROM IDX_MLT_NS", $link);
if(!$result)
{
[INDENT] die('MSSQL error: ' . mssql_get_last_message());[/INDENT]}
$row = mssql_fetch_row( $result);
echo "IDX_KEEPLIST row count: ".$row[0]." ";
mssql_free_result($result);

mssql_close($link);
?>[/INDENT]

Results:

[INDENT]IDX_CFF row count: 1870
IDX_KEEPLIST row count: 26943

Warning: mssql_query() [function.mssql-query]: Query failed in C:\cwc\idxteam\site\idxload\freetds.php on line 22
MSSQL error: [/INDENT]