Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2004
    Posts
    5

    Unanswered: -27001 Read error occurred during connection attempt

    Hi,

    We are using Informix Dynamic Server 2000 on SCO Openserver 5.

    We keep getting -27001 Read error occurred during connection attempt error messages every couple of days. We use an IIS5 web server to connect to Informix using the Informix Iconnect ODBC driver (2.81).

    I have tried to sort this out myself, but I have failed.

    In the onconfig file there are 2 nettype lines :-

    NETTYPE ipcshm,1,200,CPU # Configure poll thread(s) for nettype
    NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype

    I think the tlitcp line doesn not have sufficient poll threads. We have about 50-100 people who access the informix database through a web page.
    Should i increase the number to 100?

    Cheers,

    paul

  2. #2
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52

    -27001 Read error occurred during connection attempt

    Hi Paul,
    In the NETTYPE there are only 20 concurrent users configured. You can increase it to 100-250 to handle your 50-100 users. The configuration would be like
    NETTYPE tlitcp,1,200,NET



    Bye.
    zxczxczc

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    Do you get this error on the server or on the client side?

    You can try increasing the poll threads and see if that helps

  4. #4
    Join Date
    Oct 2004
    Posts
    5
    I have now changed the nettype to
    NETTYPE tlitcp,1,200,NET

    I will see if this cures the error. Thanks to pathri and artemka!

  5. #5
    Join Date
    Oct 2004
    Posts
    5
    After changing the NETTYPE parameters, the system stayed up a couple of days without the error message, but I have receivied it again and had to 'KICK' informix again. Any other suggestions?

  6. #6
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi Paul,

    Please test the sqlhosts files if the connection is "tlitcp" or "ontlitcp".
    I think that is "ontlitcp"

    Gustavo.

  7. #7
    Join Date
    Oct 2004
    Posts
    5
    Hi,

    These are the only 2 entrys in our sqlhosts file.


    ol_wgs oltlitcp scosysv sqlturbo
    ol_wgs_shm olipcshm scosysv srv_agent

    We connect using olsoctcp in the ODBC connection using Informix connect.

    To be honest I am not sure what all the different protocols are that you can choose in Informix connect.

    Cheers,

    Paul

  8. #8
    Join Date
    Oct 2004
    Posts
    5

    Help

    Could anyone help with the above as informix keeps freezing on me.

    Cheers,

    Paul

  9. #9
    Join Date
    Apr 2004
    Location
    zxczxczxc
    Posts
    52
    Hi,
    Post it in the IIUG you could get some good responses.
    go to www.iiug.org and register .


    Bye.
    zxczxczc

Posting Permissions

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