ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]+client win+server iif2000 on sun 
Author Message
 ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]+client win+server iif2000 on sun

Hi at all,
I installed php on win2000 iis5 (as CGI). My server is IIF2000
(9.21UC4) and it is installed on sun solaris machine.
If I try to connect to the server with this script:
<?php
print "Hi, I try to connect...<br>";

print "Result='".$conn_id."'<br>";
if (!$conn_id) {
        ifx_textasvarchar(1);      // use "text mode" for blobs
        $res_id = ifx_query("select * from utenti", $conn_id);
        if (! $res_id) {
                  printf("Can't select orders : %s\n<br>%s<br>\n", ifx_error());
                  ifx_errormsg();
                  die;
        }
        ifx_htmltbl_result($res_id, "border=\"1\"");
        ifx_free_result($res_id);
        ifx_close($conn_id);
        print "End of connection<br>";
Quote:
}

?>
the response is:
"Hi, I try to connect...

Warning: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829] in
D:\Ricerca\php\prove\informix.php on line 3
Result=''

Warning: Supplied argument is not a valid IFX link resource in
D:\Ricerca\php\prove\informix.php on line 7

Warning: printf(): too few arguments in
D:\Ricerca\php\prove\informix.php on line 9"

Could anyone help me?????

Thanks in advance
Bye
Stefano



Fri, 19 Mar 2004 23:38:00 GMT
 ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]+client win+server iif2000 on sun

What version of Informix Connect did you install in the NT box?

Have you configured the host/server information with setnet32?

Have you tested the connection with ilogin demo?

Quote:
----- Original Message -----


Sent: Monday, October 01, 2001 9:38 AM
Subject: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]+client win+server

iif2000 on sun

Hi at all,
I installed php on win2000 iis5 (as CGI). My server is IIF2000
(9.21UC4) and it is installed on sun solaris machine.
If I try to connect to the server with this script:
<?php
print "Hi, I try to connect...<br>";

print "Result='".$conn_id."'<br>";
if (!$conn_id) {
ifx_textasvarchar(1);      // use "text mode" for blobs
$res_id = ifx_query("select * from utenti", $conn_id);
if (! $res_id) {
     printf("Can't select orders : %s\n<br>%s<br>\n", ifx_error());
    ifx_errormsg();
    die;
}
ifx_htmltbl_result($res_id, "border=\"1\"");
ifx_free_result($res_id);
ifx_close($conn_id);
print "End of connection<br>";
}
?>
the response is:
"Hi, I try to connect...

Warning: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829] in
D:\Ricerca\php\prove\informix.php on line 3
Result=''

Warning: Supplied argument is not a valid IFX link resource in
D:\Ricerca\php\prove\informix.php on line 7

Warning: printf(): too few arguments in
D:\Ricerca\php\prove\informix.php on line 9"

Could anyone help me?????

Thanks in advance
Bye
Stefano



Sat, 20 Mar 2004 00:51:36 GMT
 ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]+client win+server iif2000 on sun
Hi Fernardo,
I have installed connect with ddw 2.00 tc3. I'm looking at about in
setnet utility and the esql version is 2.30 tc1x5.
I've configurated the host/server information and ilogin works fine.
Quote:

> What version of Informix Connect did you install in the NT box?

> Have you configured the host/server information with setnet32?

> Have you tested the connection with ilogin demo?

> ----- Original Message -----


> Sent: Monday, October 01, 2001 9:38 AM
> Subject: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829]+client win+server
> iif2000 on sun

> Hi at all,
> I installed php on win2000 iis5 (as CGI). My server is IIF2000
> (9.21UC4) and it is installed on sun solaris machine.
> If I try to connect to the server with this script:
> <?php
> print "Hi, I try to connect...<br>";

> print "Result='".$conn_id."'<br>";
> if (!$conn_id) {
> ifx_textasvarchar(1);      // use "text mode" for blobs
> $res_id = ifx_query("select * from utenti", $conn_id);
> if (! $res_id) {
>      printf("Can't select orders : %s\n<br>%s<br>\n", ifx_error());
>     ifx_errormsg();
>     die;
> }
> ifx_htmltbl_result($res_id, "border=\"1\"");
> ifx_free_result($res_id);
> ifx_close($conn_id);
> print "End of connection<br>";
> }
> ?>
> the response is:
> "Hi, I try to connect...

> Warning: ifx_connect : E [SQLSTATE=IX 001 SQLCODE=-1829] in
> D:\Ricerca\php\prove\informix.php on line 3
> Result=''

> Warning: Supplied argument is not a valid IFX link resource in
> D:\Ricerca\php\prove\informix.php on line 7

> Warning: printf(): too few arguments in
> D:\Ricerca\php\prove\informix.php on line 9"

> Could anyone help me?????

> Thanks in advance
> Bye
> Stefano



Sat, 20 Mar 2004 14:36:28 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQLSTATE=IX 001 SQLCODE=-1829 -- Unable to load locale categories

2. E [SQLSTATE = IX 001 SQLCODE = -1829

3. Sqlcode = -1829

4. RV: SQLCODE=-1829

5. SQLCODE=-1829

6. SQLCODE=-1829

7. Wrong values in sqlca.sqlcode, SQLCODE, and SQLSTATE

8. How to trap MS SQL Server SQLCode and SQLState for exception handling

9. Retrieving SQLState or SQLCode

10. ct_diag and ct_con_pros to retreive SQLCA, SQLCODE, SQLSTATE

11. Sun Informix Client and Sun Solaris Server

12. com.ibm.db2.jcc.c.SQLException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC:


 
Powered by phpBB® Forum Software