Can I use database commands in my Global.ASA file?

[michaaal]

Can I use database commands in my Global.ASA file like this...?

Sub Session_OnStart
Public adoCon
Dim recset
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("parts.mdb")
Set recset = Server.CreateObject("ADODB.Recordset")
End Sub

I already tried it, but I had problems. However, I read somewhere that it
could be done. Does anyone have any experience in doing this?

(My goal is to have the database opened at the start of each of my web pages
without having to type in the commands.)

Thanks!!

[Foo Man Chew]

> Public adoCon

> Dim recset
> Set adoCon = Server.CreateObject("ADODB.Connection")
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("parts.mdb")
> Set recset = Server.CreateObject("ADODB.Recordset")

What are you trying to do? Create a recordset object in a session variable,
or just execute a SQL command? It is not clear from your code what you are
trying to do, nor is it clear what "had problems" means...

> (My goal is to have the database opened at the start of each of my web

pages

> without having to type in the commands.)

No, this is a VERY BAD idea. There are several links here that *should*
convince you that opening and closing the database in each page makes more
sense (and really isn't much work having to "type in" commands; use an
#include!), if you read them with an open mind.

[url]http://www.aspfaq.com/show.asp?id=2053[/url]

[Bob Barrows]

michaaal wrote:

> Can I use database commands in my Global.ASA file like this...?
>
> Sub Session_OnStart
> Public adoCon
> Dim recset
> Set adoCon = Server.CreateObject("ADODB.Connection")
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("parts.mdb")

Don't use ODBC. Use the native Jet OLEDB provider instead
([url]www.able-consulting.com/ado_conn.htm[/url])

adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" & _
Server.MapPath("parts.mdb")

> Set recset = Server.CreateObject("ADODB.Recordset")
> End Sub
>
> I already tried it, but I had problems.

What problems? how can we help if you don't tell us the error messages you
received?

My guess is that you need to grant Modify permissions for the folder
containing the database to the IWAM account.

> However, I read somewhere
> that it could be done. Does anyone have any experience in doing this?
>
> (My goal is to have the database opened at the start of each of my
> web pages without having to type in the commands.)
>

This is a bad goal to have if you want your web server to perform
efficiently:
[url]http://www.aspfaq.com/show.asp?id=2053[/url]
[url]http://www.aspfaq.com/show.asp?id=2424[/url]

HTH,
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[michaaal]

Just wanted to say thanks, guys. The comments you provided were very
objective and informative.