IIS/Informix Errors
| From: | (Allen Ripperden) | Date: | Mon, 03 Jan 2000 05:28:42 +0000 |
| Subject: | IIS/Informix Errors | ||
| Groups: | php.version4 | ||
| Request: | Send a blank email to php-version4+get-8821@lists.php.net to get a copy of this message | ||
Informix extension is giving errors. ODBC seem works.
I am using Informix 7.3 Workgroup and I get the same errors with PHP
3.0.11.
Here's the source:
printf("PHP Version %s", phpversion());
print("<BR><BR> Informix ID:");
/* informix */
$Conn_id = ifx_connect("test@server", "test", "test");
print($Conn_id."<BR><BR>");
$users = ifx_query("select * from users", $Conn_id);
ifx_htmltbl_result($users, "border=\"1\"");
ifx_free_result($users);
/* ifx_close($Conn_id); */
/* odbc */
$Conn_id = odbc_connect("test", "test", "test");
$result = odbc_exec($Conn_id, "select * from users order by userid");
odbc_result_all($result, "border=1");
odbc_free_result($result);
/*odbc_close($Conn_id); */
OUTPUT:
PHP Version 4.0b3
Informix ID:Resource id #1
Warning: Describe fails (E [SQLSTATE=37 000 SQLCODE=-410]) in
C:\Inetpub\wwwroot\php\iftest.php on line 17
Warning: Supplied argument is not a valid Informix Result resource in
C:\Inetpub\wwwroot\php\iftest.php on line 18
Warning: Supplied argument is not a valid Informix Result resource in
C:\Inetpub\wwwroot\php\iftest.php on line 19
DATA from odbc
The SQLSTATE of 37 is a prepare error, but the manual doesn't show
using a prepare for a simple query.
Any help is appreciated.
Thanks,
Allen