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

[Dan Goldberg]

I do not have that. Do you have iis 5 or 6??   Dan -----Original Message----- From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Walker, Buddy Sent: Thursday, November 09, 2006 9:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP Dan   You may want to check the number of worker threads you have and how long to stay alive.      Here is what we have set and it seems to help.      Right Click on My Computer      Manage > Computer Management >Services and Applications > Internet Information Services (IIS) Manager      Applications > MailingListWSPool > Properties       Recycling tab > Check Recycle worker processes (in minutes)   5     Performance Tab > Idle timeout Check Shutdown worker processes after idle for (time in minutes) 2                                  Web garden > Maximum Number of worker processes: 10       Rarely do I have to restart IIS.       We reboot all of our window servers once a week.   Buddy       From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Dan Goldberg Sent: Thursday, November 09, 2006 11:47 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Problems using Oterro 3.5 ODBC from IIS & PHP   Mine was at 600. I changed to 120.   Hopefully that will fix it.   Dan Goldberg -----Original Message----- From: rbase-l@rbase.com [mailto:rbase-l@rbase.com]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