Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    2

    Unanswered: ODBC problem with Informix SE 7.25

    Hi,
    I need to connect an Informix SE database from MS windows 2000 ODBC, the server is : Redhat Linux 8.0, Informix SE 7.25. The client tool is: Informix connect 2.7. When I use DBping application to connect to the server, always encounter below error message:
    SQLSTATE = IX000
    SQLCODE = -25596

    ************************************************** *******
    The sqlhosts on the server:
    /usr/informix7/etc/sqlhosts

    #demo_on onipcshm on_hostname on_servername
    local seipcpip LS10 sqlexec
    remotedb sesoctcp LS10 sqlexecd
    ************************************************** ********
    The environment variable for user Informix on the server:

    LS10-~,2:16pm> env |grep INFOR
    LS10_DB=INFORMIX
    INFORMIXDIR=/usr/informix7
    INFORMIXSERVER=remotedb
    INFORMIXTERM=terminfo
    INFORMIXSQLHOSTS=/usr/informix7/etc/sqlhosts
    DBIF_TYPE=INFORMIXSE
    ************************************************** ********
    /etc/services

    # Local services
    sqlexecd 1536/tcp # Informix service
    ************************************************** ********
    LS10-/etc,2:18pm> hostname
    LS10
    LS10-/etc,2:20pm>
    ************************************************** ********
    The configuration in the Iconnect "Native connect page"

    username "informix"
    password "password"
    Informix server "remotedb"
    Hostname "LS10"
    service "sqlexecd"
    Protocol "sesoctcp"
    Database "data"
    ************************************************** ********
    Also add the informix service in clilent PC C:\winnt\system32\drivers\etc\services:
    sqlexecd 1536/tcp #Informix
    ************************************************** ********

    Anybody has any idea with this problem?

    Thanks
    Levin

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Levin,

    Please test in /etc/services the line of service do not be last.
    Check many files "services" exist and check %INFORMIXDIR% in W2000.

    Gustavo.

  3. #3
    Join Date
    Oct 2004
    Posts
    2

    Unhappy

    Hi,Gustavo
    Thanks for your reply!
    This is because the win2000 INFORMIXSERVER environment setup problem, I added this environment on win2000 ,then this error dispeared.
    But after that another error code came in like:
    sqlcode=-908

    I searched the forum and found this error may related to the network/socket problem. I run: telnet 127.0.0.1 1536 on the server, it can connect, no problem. But if I run: telnet 192.168.1.4 1536, it display connection refused by the server. Seems the port 1536 is only listenning local host but not for network connection. How to deal this wierd problem?

    Thanks!!
    Levin

Posting Permissions

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