[PHP-DB] Informix 9.20 ifx_query SQLCODE=-410

[Tomáš Tominec]

Hi,
I have Informix 9.2 on Solaris and IIS on XP professional.
when I run SQL statement,

$conn_id = ifx_connect ("[EMAIL PROTECTED]", "name", "pwd");

$qry = " SELECT a,b  FROM c ";

if (! $conn_id) {
    printf("Cannot connect to the DB SERVER.");
}
$res = ifx_query($qry,$conn_id);

 I will get error:
  Warning: ifx_query(): Describe fails (E [SQLSTATE=37 000 SQLCODE=-410])


The same SQL statement run corectly with ODBC.

$conn_id = odbc_connect ("odbc_alias", "name", "pwd");

$qry = " SELECT a,b  FROM c ";

if (! $conn_id) {
    printf("Cannot connect to the DB SERVER.");
}
$res = odbc_exec($conn_id,$qry);


Thank's for help.

Tomas

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php