Informix prep error
| From: | Juraj Hasko | Date: | Thu, 25 Jan 2001 10:04:04 +0000 |
| Subject: | Informix prep error | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-36590@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to develop some intranet system based on Informix DB. Standard
connection works fine but when I try to exec any SQL I've got a error
message.Can someone help me ? I use Ifx IDS 7.3, PHP 4.0.4pl1 on Win2k and
IIS 5.0. If I use connection trough ODBC it works fine. Here is sample of my
code :
$conn = ifx_connect("db@server", "myname", "mypasswd")
or die("Couldn't create connection.");
echo $conn;
$sql = "SELECT * FROM piny ORDER BY klapka"; //line 12
$ifx_prep=ifx_prepare($sql,$conn);
and output is :
Resource id #1
Warning: Describe fails (E [SQLSTATE=37 000 SQLCODE=-410]) in
c:\inetpub\wwwroot\php\bribor.php on line 12
Have you any idea how to solve my problem ?
Thank you in advance.
Ing. Juraj Ha¹ko
System Administrator
CAC LEASING Slovakia, a.s.
<mailto:Juraj.Hasko@cacleasing.sk>
WWW: www.cacleasing.sk <http://www.cacleasing.sk>