Global.asa Problem

[Tony]

I have recently upgraded to IIS6 and was not experiencing these problems in
IIS5. The global.asa reads:
<SCRIPT LANGUAGE='VBScript' RUNAT='Server'>

'EventName Description
'Session_OnStart Runs the first time a user runs any page in your
application
'Session_OnEnd Runs when a user's session times out or quits your
application
'Application_OnStart Runs once when the first page of your application is
run for the first time by any user
'Application_OnEnd Runs once when the web server shuts down

' Global Variables
'Dim Session("DB") ' Database Object
'Dim Session("bLocal") ' Is a local client or not

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''
'''''''''''''''''''''''''''''
' Main Subroutines
'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''
'''''''''''''''''''''''''''''
Sub Session_OnStart
Set Session("DB") = Server.CreateObject("ADODB.Connection")
Session("DB").Open("OSC")
'CheckLocal
End Sub

Sub Session_OnEnd
******Session("DB").Close
End Sub

Where is **** is at is where the event log says there is a problem please
help.

Thanks,

Tony

[Alan]

I don't know what you're specific problem is, but you shouldn't be opening
and caching a connection in the session. You should be opening and closing
it as required in your code - you're just wasting resources otherwise.
You've probably used this approach because it looks nice and neat, but you
can still achieve the same thing with some thoughtful coding without
resorting to the spaghetti mess of connections and recordsets seen in a lot
of ASP code.

Food for thought.

Cheers,

Alan

"Tony" <tony@optics.arizona.edu> wrote in message
news:uy#QSTfYDHA.1280@tk2msftngp13.phx.gbl...

> I have recently upgraded to IIS6 and was not experiencing these problems

in

> IIS5. The global.asa reads:
> <SCRIPT LANGUAGE='VBScript' RUNAT='Server'>
>
> 'EventName Description
> 'Session_OnStart Runs the first time a user runs any page in your
> application
> 'Session_OnEnd Runs when a user's session times out or quits your
> application
> 'Application_OnStart Runs once when the first page of your application

is

> run for the first time by any user
> 'Application_OnEnd Runs once when the web server shuts down
>
> ' Global Variables
> 'Dim Session("DB") ' Database Object
> 'Dim Session("bLocal") ' Is a local client or not
>
>

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''

> '''''''''''''''''''''''''''''
> ' Main Subroutines
>

'''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''

> '''''''''''''''''''''''''''''
> Sub Session_OnStart
> Set Session("DB") = Server.CreateObject("ADODB.Connection")
> Session("DB").Open("OSC")
> 'CheckLocal
> End Sub
>
> Sub Session_OnEnd
> ******Session("DB").Close
> End Sub
>
> Where is **** is at is where the event log says there is a problem please
> help.
>
> Thanks,
>
> Tony
>
>

[Adrian Forbes - MVP]

Don't waste any time looking into this. OLEDB does what
you are trying to do under the covers. When you close a
connection it is not actually closed but put into a pool,
so if another process creates one and a suitable
connection is in the pool it gets the pooled version.

Doing what you are doing stops OLEDB managing the pool and
OLEDB is doing a better job of it than your code is. What
would happen when 1000 users all access your site? They
get 1000 permanent connections, where if you let oledb
handle pooling you will have all 1000 users serviced by
maybe 5 or 10 connections instead.

Open a connection in your code when you need it, and close
it right after.

>-----Original Message-----
>I have recently upgraded to IIS6 and was not experiencing

these problems in

>IIS5. The global.asa reads:
><SCRIPT LANGUAGE='VBScript' RUNAT='Server'>
>
>'EventName Description
>'Session_OnStart Runs the first time a user runs

any page in your

>application
>'Session_OnEnd Runs when a user's session times

out or quits your

>application
>'Application_OnStart Runs once when the first page of

your application is

>run for the first time by any user
>'Application_OnEnd Runs once when the web server

shuts down

>
>' Global Variables
>'Dim Session("DB") ' Database Object
>'Dim Session("bLocal") ' Is a local client or not
>
>''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''

''''''''''''''''''

>'''''''''''''''''''''''''''''
>' Main Subroutines
>''''''''''''''''''''''''''''''''''''''''''''''''' '''''''''

''''''''''''''''''

>'''''''''''''''''''''''''''''
>Sub Session_OnStart
> Set Session("DB") = Server.CreateObject

("ADODB.Connection")

> Session("DB").Open("OSC")
> 'CheckLocal
>End Sub
>
>Sub Session_OnEnd
> ******Session("DB").Close
>End Sub
>
>Where is **** is at is where the event log says there is

a problem please

>help.
>
>Thanks,
>
>Tony
>
>
>.
>