[PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Robert Hennig
Hi! We use a informix IDS2000 server on a linux machine together with php 4.05 on Apache. As a test we wrote the following script: ?php $conn_id = ifx_connect(unipps,informix,sqLOpen); if (! $conn_id) { echo connection failed; } $ergebnis = ifx_query(select ident_nr from personal,

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Robert Hennig
Hi Paul, thanks for your fast reply. Maybe you could help me again :-) We are working a lot with informix, so we thought to know every Programm, but isql is completely unknown. Is this a special programm? We have executed this select with a sql-editor on the server also as with dbaccess, on

Re: [PHP-DB] Error MSG -410 while executing a select with ifx_query on a informix database on linux

2001-05-22 Thread Paul Gardiner
Hi Robert, isql comes from (I)nformix (S)trutured (Q)uery (L)anguage. It's similar to your sql-editor. I use the SE Database engine and not the Dynamic Server like yourself. Whether this has anything to do with it I don't know but I did run your code on my server just to make sure it ran