ODBC Error With PHP

[memoran]

I trying to run a php script on a Windows NT 4 sp6a that connects to an odbc datasource and I get the following error message:

Warning: SQL error: [Extended Systems][Advantage ODBC Driver]Unable to do ORDER BY, SQL state S0000 in SQLExecDirect in D:\web\odbc.php on line 13

This is odd, since the query I am performing does not have an order by in the query. The other odd thing is that this page works without any problems on a Windows 2000 machine with the exact same odbc driver and php installation. The next odd item is that the same query works with the same datasource with asp and an ado recordset.

The code for the page is listed below:

<?
$db_conn = odbc_connect("ADSData","","");

if ($db_conn)
{
print("Connection established.<br>");

$Qry = odbc_exec($db_conn, "SELECT * FROM Globlook\Region");


if ($Qry) 
{
  odbc_result_all($Qry);
}

}
else
{
print("There was an error making the database connection.");
}

odbc_close($db_conn);
?>

Does anyone have any suggestions?

Thanks,

Mark
[e-mail]