If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Informix 9.3x SQLCode=908 in RedHat Linux 7.3

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-19-03, 21:11
manny_er manny_er is offline
Registered User
 
Join Date: Feb 2003
Posts: 24
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.
Reply With Quote
  #2 (permalink)  
Old 02-20-03, 05:48
eherber eherber is offline
Registered User
 
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
***********************************************
Reply With Quote
  #3 (permalink)  
Old 02-20-03, 20:37
manny_er manny_er is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 02-21-03, 02:38
eherber eherber is offline
Registered User
 
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
***********************************************
Reply With Quote
  #5 (permalink)  
Old 02-23-03, 21:22
manny_er manny_er is offline
Registered User
 
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?
Reply With Quote
  #6 (permalink)  
Old 02-23-03, 21:22
manny_er manny_er is offline
Registered User
 
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?
Reply With Quote
  #7 (permalink)  
Old 02-25-03, 03:26
eherber eherber is offline
Registered User
 
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
***********************************************
Reply With Quote
  #8 (permalink)  
Old 02-28-03, 04:51
manny_er manny_er is offline
Registered User
 
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
Reply With Quote
  #9 (permalink)  
Old 03-01-03, 05:22
eherber eherber is offline
Registered User
 
Join Date: Aug 2002
Location: Bonn/Germany
Posts: 152
Re: Informix 9.3x SQLCode=908 in RedHat Linux 7.3

Quote:
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
***********************************************
Reply With Quote
  #10 (permalink)  
Old 04-07-03, 22:31
manny_er manny_er is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On