Thanks I will try that. Did this work around fix the problem? I wonder how many other sites have the same problem. You are right when you said that when you add more data sources it gets worst.
rich ----- Original Message ----- From: "Troy Sosamon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 11:55 AM Subject: RE: Oterro odbc and connection pooling Win 2000 Server and Rtango > Rich, > > I had that problem a while ago and traced to the Tango server hanging every > 30 minutes for up to a minute or two. I solved the problem by changing the > datasourcetimeout in the tango settings (t4server.ini file) to 24 hours and > then I restart the Tango server every night. I also found as I added more > datasources, the problem got worse, and if you shorten the datasourcetimeout > it will get really bad. I could never figure out if it was a Tango issue or > an Oterro issue, but this was my workaround. > > I have never messed around with the Connection pooling, so mine os off. I > don't know what it does or if Oterro would even use it. > > Troy Sosamon > > ===== Original Message from [EMAIL PROTECTED] at 7/24/02 8:46 am > >We have been periodically having our tango server hang when it tango app is > >doing a select from a rbase database via the oterro 2.5 odbc driver. The > >odbc driver has an option for connection pooling, What should those settings > >be? > > > >rich > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
