Results 1 to 10 of 10
  1. #1
    Join Date
    Feb 2003
    Posts
    24

    Unanswered: Informix 9.3x SQLCode=908 in RedHat Linux 7.3

    Good day!

    I have a problem connecting to Informix 9.3x server running on RedHat Linux 7.3 using IConnect and/or ODBC. The error message is SQLCODE= -908. I have checked the service status using 'netstat -a | grep tcp' command to verify the connection but no ESTABLISHED status appeared only LISTEN. I have verified /etc/service with sqlhosts and also with client service.

    Please help me regarding this problem. Any reply is greatly appreciated.

    Thank you.

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    Are you connecting locally or thru a windows machine ?

    First try to connect locally via dbaccess and your
    configured TCP databaseserver name.
    Does this work ?

    If yes, you might check the connection from the windows
    pc thru the 'ilogin.exe' program that is deliverd with
    I-Connect or I-CSDK.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  3. #3
    Join Date
    Feb 2003
    Posts
    24
    I'm connecting from a windows2000 machine. Dbacess is working locally.


    ------Server services: IDS entry in /etc/services

    on_tweety 14001/tcp #IDS 9.30

    ------$INFORMIXDIR/etc/sqlhosts


    demo_on onipcshm on_hostname on_servername
    demo_se seipcpip se_hostname sqlexec

    tweety onsoctcp albatross on_tweety


    ------Client services: Entry in C:\winnt\system32\drivers\etc\service

    on_tweety 14001/tcp #IDS 9.30

    I'd also use DBPing to check the connection but it resulted with the "An Error Occured on (Open Database): SQLCA(-908)". The same result also with Ilogin/IConnect.


    Best regards,

    Manny

  4. #4
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    Please check the name of the services-file on the WIN PC.
    I don't know if the following is a typo:

    ------Client services: Entry in C:\winnt\system32\drivers\etc\service

    The name of the file has to be 'services' not 'service'.

    Then you might verify if the IFMX databaseserver is listening on
    the configured TCP port. This could be done via 'telnet':

    telnet <hostname> <port_number>

    The following indicates that the IFMX server is listening on
    the port:
    Trying...
    Connected to chicago.
    Escape character is '^]'.

    This indicates that the IFMX server is NOT listening on the port:
    Trying...
    telnet: connect: Connection refused

    You should perform this test on the Linux machine and also from
    the WIN PC.

    Make also sure that your 'setnet32' settings are appropriate.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  5. #5
    Join Date
    Feb 2003
    Posts
    24

    Informix 9.3x SQLCode=908 in RedHat Linux 7.3

    This is the result of the command netstat -a | grep tcp

    [informix@albatross informix]$ netstat -a | grep tcp
    tcp 0 0 *:32768 *:* LISTEN
    tcp 0 0 albatross:32769 *:* LISTEN
    tcp 0 0 *:mysql *:* LISTEN
    tcp 0 0 *:sunrpc *:* LISTEN
    tcp 0 0 *:x11 *:* LISTEN
    tcp 0 0 *:10000 *:* LISTEN
    tcp 0 0 albatrossn_tweety *:* LISTEN
    tcp 0 0 *:ssh *:* LISTEN
    tcp 0 0 *:telnet *:* LISTEN
    tcp 0 0 albatross:smtp *:* LISTEN
    tcp 0 20 albatross:ssh duffy:1082 ESTABLISHED

    The service on_tweety is listening why is it that i still can't connect.

    When using telnet to test for the service, from the client and within the server, I get the message Connection refused.

    Does Informix Dynamic Server Version 9.30.UC1 have a bug in socket TCP connection?

  6. #6
    Join Date
    Feb 2003
    Posts
    24

    Informix 9.3x SQLCode=908 in RedHat Linux 7.3

    This is the result of the command netstat -a | grep tcp

    [informix@albatross informix]$ netstat -a | grep tcp
    tcp 0 0 *:32768 *:* LISTEN
    tcp 0 0 albatross:32769 *:* LISTEN
    tcp 0 0 *:mysql *:* LISTEN
    tcp 0 0 *:sunrpc *:* LISTEN
    tcp 0 0 *:x11 *:* LISTEN
    tcp 0 0 *:10000 *:* LISTEN
    tcp 0 0 albatrossn_tweety *:* LISTEN
    tcp 0 0 *:ssh *:* LISTEN
    tcp 0 0 *:telnet *:* LISTEN
    tcp 0 0 albatross:smtp *:* LISTEN
    tcp 0 20 albatross:ssh duffy:1082 ESTABLISHED

    The service on_tweety is listening why is it that i still can't connect.

    When using telnet to test for the service, from the client and within the server, I get the message Connection refused.

    Does Informix Dynamic Server Version 9.30.UC1 have a bug in socket TCP connection?

  7. #7
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    I'm not aware of a bug in this area.

    There seems to be something wrong with your
    network configuration.

    Stop your IFMX databaseserver and change your
    sqlhosts entry:

    old:
    ----
    tweety onsoctcp albatross on_tweety

    new:
    ------
    tweety onsoctcp localhost on_tweety

    After this, re-start your IFMX databaseserver and execute the
    telnet test again:

    telnet localhost on_tweety

    Does this work ?

    If yes, I guess something is wrong in your TCP configuration,
    however I'm not a network specialist to be able to tell you
    what is excactly wrong.

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  8. #8
    Join Date
    Feb 2003
    Posts
    24

    Informix 9.3x SQLCode=908 in RedHat Linux 7.3

    The result is still the same, connection refused.

    I have tried to check for ipchains and created a rule to accept from port on_tweety and still yield the same result.

    Regards

  9. #9
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152

    Re: Informix 9.3x SQLCode=908 in RedHat Linux 7.3

    Originally posted by manny_er
    The result is still the same, connection refused.

    I have tried to check for ipchains and created a rule to accept from port on_tweety and still yield the same result.

    Regards
    Ok, try the following small perl program which opens a
    socket and waits for incoming messages.
    You start the program on one terminal and on the
    other terminal you can use telnet to connect to this
    socket, i.e.:

    telnet localhost 14001

    Then you can enter strings which should be printed
    to stdout by the Perl TCP server program.

    If you get the "connection refused" error, something is
    wrong with your network connection.
    If this work, you should call IFMX tech support because
    there seems to be something wrong with informix.

    ************************************************** *************************
    #!/usr/bin/perl -w

    use strict;
    use IO:ocket;

    my $server = undef;
    my $client = undef;
    my $portnum = 14001;

    # -----------------
    # create the socket
    # -----------------
    $server = IO:ocket::INET->new(LocalPort => $portnum,
    Type => SOCK_STREAM,
    Reuse => 1,
    Listen => SOMAXCONN)
    || die "Could not start TCP-Server on Port [$portnum], Error [$@]\n";

    print "Server listening on port [$portnum]\n";

    # --------------------------
    # wait for incoming requests
    # and echo them to stdout
    # --------------------------
    while ($client = $server->accept())
    {
    while (<$client>)
    {
    print;
    }
    }

    ************************************************** *************************

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

  10. #10
    Join Date
    Feb 2003
    Posts
    24

    Thank you.

    Hello everybody,

    To those who have help me with my problem thank you for the effort and the experience you have shared to me. I appreciated all the help, a lot.

    Best regards,

    Manny

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •