Informix 9.20 ifx_query SQLCODE=-410
| From: | Tom� Tominec | Date: | Fri, 10 Oct 2003 10:46:40 +0000 |
| Subject: | Informix 9.20 ifx_query SQLCODE=-410 | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30957@lists.php.net to get a copy of this message | ||
Hi,
I have Informix 9.2 on Solaris and IIS on XP professional.
when I run SQL statement,
$conn_id = ifx_connect ("dbname@ol_srv", "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