[RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP

[Dan Goldberg]

Mine was at 600. I changed to 120.   Hopefully that will fix it.   Dan Goldberg -----Original Message----- From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Walker, Buddy Sent: Thursday, November 09, 2006 8:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP Dan   On Your Web Server Right Click on My Computer      Manage > Computer Management >Services and Applications > Internet Information Services (IIS) Manager     Right Click on Web Sites > Properties      You will see connections mine is set to 120 seconds   Buddy     From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Dan Goldberg Sent: Thursday, November 09, 2006 10:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP   Hi buddy, do you know where you set that in and what it is called??   Thanks   Dan Goldberg     -----Original Message----- From: rbase-l@rbase.com [mailto:rbase-l@rbase.com]On Behalf Of Walker, Buddy Sent: Thursday, November 09, 2006 4:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP You can control the timeout of the queries by manipulating the worker thread settings on the application pool in IIS that governs the website.   Buddy   From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Dan Goldberg Sent: Wednesday, November 08, 2006 8:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP   I am having the same problem and submitted it to RBTI support. I have the same scenario but with Oterro 3.5 unlimited license and it happens to me. So it is not a license issue.   One difference is I use asp instead of php but have the same problems. I used have asp apps that run on sql server without problem on the same server. I think it is an Oterro problem.   I have to use the command   iisreset servername /RESTART   to restart it.   I am hoping they come up with a fix soon...   Dan Goldberg     -----Original Message----- From: rbase-l@rbase.com [mailto:rbase-l@rbase.com]On Behalf Of Radi Shourbaji Sent: Wednesday, November 08, 2006 9:24 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Problems using Oterro 3.5 ODBC from IIS & PHP Importance: High We're using the Oterro 3.5 ODBC drivers to access an R:BASE database from a PHP application running under Windows 2000 / IIS5.  Periodically it seems that the a query will hang, and eventually lockup IIS requiring a restart.  The problem seems to be aggravated when multiple requests are issued to R:BASE via Oterro. So I was wondering:   1) Is there a way to set a timeout to force the request to terminate and return to PHP / IIS if it takes longer than X seconds?   2) In case its a license count issue - is there someway to query Oterro (via ODBC) to check the number of licenses currently in use?   Regards,   Radi Shourbaji Technical Enterprises