SAC
Sun Oct 30 10:48:22 CST 2005
Thanks!
"Stefan B Rusynko" <sbr_enjoy@hotmail.com> wrote in message
news:efKOfTT3FHA.3600@TK2MSFTNGP12.phx.gbl...
> Dim Conn_Name
> Conn_Name = Application("Hubbell_ConnectionString")
> set Conn = Server.CreateObject("ADODB.Connection")
> Conn.Open Conn_Name
>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> To find the best Newsgroup for FrontPage support see:
>
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
> _____________________________________________
>
>
> "SAC" <sac@abc.com> wrote in message
news:Ou16CbS3FHA.3136@TK2MSFTNGP09.phx.gbl...
> | Here's the Application_OnStart event in my global.asa that FP made when
I
> | imported an Access db:
> |
> | Sub Application_OnStart
> | '==FrontPage Generated - startspan==
> | Dim FrontPage_UrlVars(1)
> | '--Project Data Connection
> | Application("Hubbell_ConnectionString") = "DRIVER={Microsoft Access
Driver
> | (*.mdb)};DBQ=URL=HubbellWeb_Data.mdb"
> | FrontPage_UrlVars(0) = "Hubbell_ConnectionString"
> | Application("Hubbell_ConnectionTimeout") = 15
> | Application("Hubbell_CommandTimeout") = 30
> | Application("Hubbell_CursorLocation") = 3
> | Application("Hubbell_RuntimeUserName") = ""
> | Application("Hubbell_RuntimePassword") = ""
> | '--
> | Application("FrontPage_UrlVars") = FrontPage_UrlVars
> | '==FrontPage Generated - endspan==
> | End Sub
> |
> | Would "Hubbell_ConnectionString" be the Connection String?
> |
> | If not, where is the Application Collection?
> |
> | Thanks.
> |
> |
> |
> |
> | "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message
> | news:e2bF7RQ3FHA.3136@TK2MSFTNGP09.phx.gbl...
> | > The global.asa file is just a script with different Application-level
> | event
> | > handlers in it. Usually, a Connection String is cached in the
Application
> | > Collection. So, either look for one there, or put one there.
> | >
> | > --
> | > HTH,
> | >
> | > Kevin Spencer
> | > Microsoft MVP
> | > .Net Developer
> | > A watched clock never boils.
> | >
> | > "SAC" <sac@abc.com> wrote in message
> | > news:ec%23uDQL3FHA.3600@TK2MSFTNGP12.phx.gbl...
> | > > In using vbscript, what's the syntax for pointing to the db
connection
> | > > that's made in the global.asa? Do I use it like I would using a
system
> | > > dsn?
> | > >
> | > > Normally I've used a system dsn and used:
> | > > rsName.ActiveConnection = "dsn=(dsnName)"
> | > >
> | > > But I don't know how to use the global.asa connection info.
> | > >
> | > > Thanks.
> | > >
> | > >
> | > >
> | >
> | >
> |
> |
>
>