Session variables 1

[smash81]

Hello,
I would like to know if i can have one connection object created for a particular session so that i dont have to keep connecting to the database whenever any data is needed.please tell me how i can do this.

 

[vasah20]

Storing a connection object at Session level is a VERY bad idea.

What happens is that you open a connection for each session, and when those sessions timeout you would close the session.

I won't go into the details here,
see

http://www.learnasp.com/learn/nodbsession.asp

for more information.

Something to keep in mind is that if you are using Access, it will typically fail around 10 concurrent connections, sometimes it will even fail at 3. If you do session level connections, be prepared for your DB to fail on you.

If you are still interested in doing session level connections, just use normal session variable notation.
eg:
set Session("mySessionLevelConnection&quot = Server.CreateObject(...)

and so on.

hope this helps
leo