Can I open a database connection in my GLOBAL.ASA file?

[michaaal]

Can I use my GLOBAL.ASA file to open a database connection before each page
loads? Would someone mind posting a very simple example? I tried to make
it work but couldn't. Thanks!

[Roji. P. Thomas]

You can, But NEVER do that.

Acquire resources late and release early.

Bu opening a connection and making every pages to reuse it
you are creating a bottlenect by forcing your pages to use the same
connection.
and you will not get the benefit of connection pooling.

Open the connection only when you need a DB access and close it immediately.



--
Roji. P. Thomas
SQL Server Programmer ;)
________________________
"michaaal" <res0gyio@verizon.net> wrote in message
news:%235rUJl%23sDHA.3144@tk2msftngp13.phx.gbl...

> Can I use my GLOBAL.ASA file to open a database connection before each

page

> loads? Would someone mind posting a very simple example? I tried to make
> it work but couldn't. Thanks!
>
>

[Jeff Cochran]

On Wed, 26 Nov 2003 00:55:38 -0600, "michaaal" <res0gyio@verizon.net>
wrote:

>Can I use my GLOBAL.ASA file to open a database connection before each page
>loads?

Sure. And *every* page would open it, even if it didn't need a
database connection. You could really bog down a decent site that
way. :)

Open a connection when needed, close and destroy the object as soon as
you're through with it. In fact, you can go further and use an
IF/THEN to only open the connection if there's a reason on the page.
I see a lot of pages open a connection, then test the data returend
from a query string only to find they reject the request. The
connection gets opened but never used.

Jeff

[Aaron Bertrand [MVP]]

> Can I use my GLOBAL.ASA file to open a database connection before each
page

> loads?

No. You could open a connection object that stays open for the life of the
session (and often session.timeout minutes afterward), but this is very
wasteful and inefficient. See [url]http://www.aspfaq.com/2053[/url] for reasons.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]