Requested resource is in use message

[sgsang]

Hi All.&nbsp;&nbsp;Am new to this forum, but need your expertise.&nbsp;&nbsp;I'm serving web pages that dynamically query an Access 2000 database using input from forms.<br><br>Sometimes the server responds to the request by stating &quot;requested resource is in use&quot;.&nbsp;&nbsp;<br><br>I've checked the FAQs and don't see a resolution to this.&nbsp;&nbsp;Am wondering if I need to set some session timeout attribute in the database or the website.<br><br>Any help would be greatly appreciated.<br><br>Thanks.

 

[DougP]

So lets see some of your code,<br>and the line where the error occurs <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.

 

[sgsang]

Hi Doug.<br><br>If you're referring to the source code behind the html page, it simply says something like:<br><br>&lt;html&gt;<br>Requested resource is in use.<br>&lt;html&gt;<br><br>There's no indication of an error or event ID number.<br>------------------<br><br>I suspect it has to do with the ODBC setup for the DSN.&nbsp;&nbsp;I just increased the number of threads from 3 to 20 and I have connection pooling enabled for 60 seconds, but maybe something else needs to be configured.<br><br>Or<br><br>Maybe it has to do with the web site settings on our NT 4.0 server. The Properties for the site, under the Home Directory tab has a checkbox where one can choose to &quot;Run in a separate memory space (isolated process)&quot;.&nbsp;&nbsp;<br><br>I may be way off on all this, but something is restricting use of the database over the web.<br><br>Should I have asked instead what settings others who serve databases over the web do?<br>-------------------<br>Lastly, if you were referring to the ASP connection object,<br>we're using something like the following:<br><br>set conn = server.createObject (&quot;ADODB.Connection&quot<br>set conn.open &quot;Database&quot;, &quot;&quot;,&quot;&quot;<br>set rs.server.createObject(&quot;ADODB.Recordset&quot<br>sql = &lt;query here&gt;<br>rs.Open sql, conn, 3,3<br><br><br>Any advice on this would be greatly appreciated.<br><br>Thanks,<br>sgsang

 

[sgsang]

Correction:<br><br>ASP source code should have read:<br><br>set conn = server.createObject (&quot;ADODB.Connection&quot<br>conn.open &quot;Database&quot;, &quot;&quot;,&quot;&quot;<br>set rs.server.createObject(&quot;ADODB.Recordset&quot<br>sql = &lt;query here&gt;<br>rs.Open sql, conn, 3,3

 

[sgsang]

Found issue was with Microsoft's IIS settings and the way caching&nbsp;&nbsp;ISAPI applications was being handled when ASP pages are executed.<br><br>Here's the MS Knowledge Base article, FYI:<br><A HREF="

http://support.microsoft.com/support/kb/articles/Q182/0/59.ASP?LN=EN-US&SD=gn&FR=0"

TARGET="_new">

http://support.microsoft.com/support/kb/articles/Q182/0/59.ASP?LN=EN-US&SD=gn&FR=0</A><br><br>