IIS disconnect from MS-SQL Server not instant

Hi,
I am seeing a strange issue occur on IIS when connecting to an MSSQL
database using both ASP and JAVA.

We have an application that uses both a client front end and a web
based data input application. The application stops users connecting
to both the web application and the client application simultaneously.
The problem is when a user switches from the Web to the Client
application they must wait around 60 seconds for their user to be
logged out from the database. This is causing the client some
considerable delays when switching applications.

Using the test asp script at the end of this post I connected to and
disconnected from an MSSQL database. The result was that the database
connection for my username was not dropped from MSSQL for about 60
seconds after the page execution completed.

I then tried IIS on a different machine and got the same results.

Finally I tried switching to native VBS using cscript to see if it was
the ADO object. The code is at the bottom of this post. When this is
run my username connects to the database and almost instantly
disconnects. Please can somebody advise on what we need to do to IIS
to fix this problem.

Regards,

Richard Ward
Software Support Engineer
Warwick International Computing Systems

ASP:
<% @Language=VBScript%>
<% Option Explicit %>
<%
Dim Objconn

set ObjConn = Server.CreateObject("ADODB.Connection")
ObjConn.open "Provider=sqloledb;Data Source=SQLSERVER;Initial
Catalog=TESTDB;Integrated Security=SSPI"

objConn.close
Set objConn = nothing
%>


VBS:
Dim Objconn

set ObjConn = CreateObject("ADODB.Connection")
ObjConn.open "Provider=sqloledb;Data Source=SQLSERVER;Initial
Catalog=TESTDB;Integrated Security=SSPI"

objConn.close
Set objConn = nothing

Hi Ken,
Thanks for the info. It was the Resource pooling that was doing it.

Regards,


Richard Ward
Software Support Engineer
Warwick International Computing Systems