I am running ASP and an SQL-server. I have set simultanious calls to 15 and the timeout to 30 min. My problem is that since it is a quite big intranet, there is often more than 15 ppl who visits the same page within 30 minutes. In global.asa I have declared:
Set Session("Databas") = Server.CreateObject("ADODB.Connection")
And then, when accessing the database I use:
xxxx = Session("Databas").Execute(string)
and when done I use:
Set xxxx = Nothing
What can I do to end the database call. I tried closing the "databas" session but that only leads to an error message when I go to another ASP page.