This workaround does fix the hanging problem, but it creats another one. Now I have to figure out to force Tango to disconnect from the database so I can do maintance on it.
Troy ===== Original Message from [EMAIL PROTECTED] at 7/24/02 12:53 pm >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/ ================================================ 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/
