Yes I do.. Iam not sure whats going on here. because when I use the same page from test server hitting the same sql box it release after about a...

I am sorry I missed it when I did Cope and Paste. Also I need this line. The other thing I did was I changes the command time out to...

Here is the code. Sorry I am sorry I have replace the server name and userid with xxx. I am sure you understand.

But here is the code

connect="DRIVER=SQL Server;SERVER=xxxxx;UID=xxx;PWD=xx;DATABASE=xxx"

' ======================================================================

set objconn=server.CreateObject("ADODB.Connection")

objconn.Open...

Yes stored Procedure does execute properly and it does what it needed to do.

But the conneciton status goes to sleeping and it does stays that way for seceral hours.Any help...