No rows found

[Anon]

Hi,
I'm running a LAMP server and I want to access with ODBC to a MSSQL Server7. The connection works, but I have problem with executing a SELECT statement. I tried odbc_do , odbc_exec and odbc_execute but the odbc_result_all function always says no rows found.
If I do an insert, update or delete the database is changed. So the connection is OK.

My code:
...
$querry="SELECT * FROM test";
if($result=odbc_do($conn_id, $querry))
{
odbc_result_all($result);
echo "freeing result";
odbc_free_result($result);
}
...

Does anyone know where the error is?

Christof

[matto]

see the 2nd posting in php.net - odbc_result_all:

<quote>
As some people stated in the ODBC overview, some buggy drivers always return the number of rows to be -1. AFAIK the only way to help this situation is to count the rows by calls to odbc_fetch_into or odbc_fetch_row and then build the table yourself.
</quote>

this happens often 🙁

is the returned integer -1 or is it 0?
if -1, this is the solution.
if 0 -> ???

[Anon]

hi,

I can't get it to work. I tried it with odbc_fetch_row and odbc_fetch_into but there is still no result.
The function odbc_num_rows returns -1, so you're right.
If I try it with something like this:

if ( odbc_fetch_into( $result_id, &$row )){
echo $row[1]."\n";
echo $row[2]."\n";
}
else {
echo "nothing";
}

There is always nothing. The same with fethc_row.
Do you have some more hints for me, please.

Thaks,
Christof