global.asa file

[-D-]

I want to use a query to active directory that holds a user name, group role
and group region and stores those values as session variables in the global.asa
so the values can be used throughout the application for multiple users. I
need to plug the query to active directory into the global.asa file and setup
the session variables. I'm not too familiar with the global.asa file and
wondering if someone has done something like this. Would the basic layout be
like the following: <!--#include file='Connections/DBConn.asp' --> <script
language='vbscript' runat='server'> sub Application_onStart ...code...(place
the code for the query here and then set the session variables equal to the
recordset values...username, role and region) end sub </script> Thanks for
any help. -D-

[Julian Roberts]

What errors are you getting?

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[-D-]

I hadn't plugged in the code yet. I am trying to understand how to implement
the code correctly within the global.asa file. I'm new to using a global.asa
file and wanted to know if how I was setting up the file was correct? Whether
I should I use: sub Application_onStart or sub Session_onStart I hope my
question makes sense. Thanks for your help, -D-

[Julian Roberts]

Code looks OK. Give it a whirl and see what happens. Sesion_onstart might
just do the trick.

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Julian Roberts]

Here's an example of mine

<script language="VBScript" runat="Server">
Sub Application_OnStart
Application("ConnString") = "Provider=SQLOLEDB.1;Password=xxx;Persist
Security Info=True;User ID=xxx;Initial Catalog=xxx_xxx;Data Source=xxx"
'do stuff
End Sub
</script>


--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004