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 > -27001 Read error occurred during connection attempt

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-28-04, 05:21
pdraycott pdraycott is offline
Registered User
 
Join Date: Oct 2004
Posts: 5
-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
Reply With Quote
  #2 (permalink)  
Old 10-28-04, 09:25
pathri pathri is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 10-28-04, 09:27
artemka artemka is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 10-28-04, 09:57
pdraycott pdraycott is offline
Registered User
 
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!
Reply With Quote
  #5 (permalink)  
Old 11-03-04, 09:39
pdraycott pdraycott is offline
Registered User
 
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?
Reply With Quote
  #6 (permalink)  
Old 11-04-04, 07:09
gurey gurey is offline
Registered User
 
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.
Reply With Quote
  #7 (permalink)  
Old 11-05-04, 10:27
pdraycott pdraycott is offline
Registered User
 
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
Reply With Quote
  #8 (permalink)  
Old 11-10-04, 08:22
pdraycott pdraycott is offline
Registered User
 
Join Date: Oct 2004
Posts: 5
Help

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

Cheers,

Paul
Reply With Quote
  #9 (permalink)  
Old 11-12-04, 01:14
pathri pathri is offline
Registered User
 
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
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