Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2009
    Posts
    3

    Unanswered: DSN connectivity issue for Informix server

    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

  2. #2
    Join Date
    Apr 2007
    Location
    Jundiai / SP - Brasil
    Posts
    311
    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
    ________________________________________
    César Inacio Martins
    Jundiai / SP - Brasil
    http://www.imartins.com.br/informix - em Português
    http://www.imartins.com.br/informix - English (translated by Google).
    ________________________________________

  3. #3
    Join Date
    Aug 2009
    Posts
    3
    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

Posting Permissions

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