Hi Robert,
Your test code is correct although you could do with an ifx_close($conn_id);
at the end.
Have you tried running isql(assuming you've got it) and just trying to run
the query from there?
Regards,
- Paul -
"Robert Hennig" <[EMAIL PROTECTED]> wrote in message
9ednu0$p93$[EMAIL PROTECTED]">news:9ednu0$p93$[EMAIL PROTECTED]...
> 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]
>
>
--
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]
