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

[Dan Goldberg]

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:[EMAIL PROTECTED]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