I tried your SQL statement with the same result. But then I found an
other parameter, that trigger the error.

Then I found my mistake. In the connect statement I use an empty
dialect value. That it was.

Thanks for the help.

Juri

--- In firebird-php@yahoogroups.com, Lester Caine <lester@l...> wrote:
> > $stmt = "Select ROLLE,DBNAMEN from BENUTZER";
>
> > db_connect_id = Resource id #2
> > q_handel = 1
> >
> > Warning: ibase_fetch_row(): supplied argument is not a valid InterBase
> > result resource in /db/www/test-fb.php on line 22
>
> > db_connect_id = Resource id #2
> > q_handel = Resource id #3
> >
> > Warning: ibase_fetch_row(): Dynamic SQL Error SQL error code = -804
> > Incorrect values within SQLDA structure in /db/www/test-fb.php on
line 29
>
> It looks as if the database is being found, but the query is
> not producing valid results.
> Try another query and see if that works.
>
> 'SELECT RDB$CHARACTER_SET_NAME FROM RDB$CHARACTER_SETS'
>
> should always work :)
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services