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

[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", $conn_id);
if(! $ergebnis)
{
  echo "selection failed";
}

ifx_htmltbl_result($ergebnis, "border=\"2\"");
ifx_free_result($ergebnis);
echo $ergebnis;
echo $conn_id;
?>

The connect seems to work, because we get a syntax error if we use a wrong
field-name in the select. We receive the following error when executing this
script:

Warning: Describe fails (E [SQLSTATE=37 000 SQLCODE=-410]) in
/v/u/robert/public_html/datenbank.php on line 8

(line 8 is the line $ergebnis = ifx_query("select ident_nr from personal",
$conn_id);)

What wents wrong?

Robert






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]