DSN connectivity issue for Informix server

ramkumarm83 · #1 (**permalink**) 11-15-09, 12:58

Hi All,

I am trying to test the DSN connectivity from my desktop to informix server(Unix machine).
I have installed Informix connect in my desktop an tried from ilogin demo.

I am getting sqlcode -908 error when I connect.

I have searched many forum and found that this issue will be sort out if i set the INFORMIXCONTIME duration to 100 sec in informix server. But I am not able to set this environment variable.

May I know how to set this varaible or any way to resolve this problem??

Could any one advise me please ?

Many Thanks,
Ram

ceinma · #2 (**permalink**) 11-17-09, 12:36

1) test if your connectivity with your database is OK with a simple TELNET connection:

Code:

telnet <database_ip> <database_port>
$ telnet codsrv222 55010
Trying 172.30.252.222...
Connected to codsrv222.
Escape character is '^]'.

Here the port is open and this log will appear in your informix MESSAGES:

Code:

$ onstat -m
...
15:19:22  listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt.

2) On the ILogin inform all fields.
and remember, the INSTANCE name is CASE SENSITIVE.
SERVER = $INFORMIXSERVER (DBSERVERNAME)
protocol: onsoctcp
servicename = port (on my telnet example = 55010)
database = sysmaster

ramkumarm83 · #3 (**permalink**) 11-17-09, 15:56

Thank you very much ceinma..

Now I am able to connect the db from my desktop.

I used DBALIASENAME before instead of DBSERVERNAME.

Thank you for your valuable information..

Cheers,
Ram

Internet Services

Web Development

Digital Marketing

Consumer Tech