How can I reference an include page from global.asa?

[Dave]

I have different database connections that I use for DEV and PROD versions
of our web app.

I want to put the database connection string in one location so I only have
to change it once when we push live.

So I put it in an include file and reference it in all my asp pages as:
<!--#include file="includes/db_conn.inc"-->

But this will not work with the global.asa page.

How can I reference an include page from global.asa?

[Mike Brind]

"Dave" <da*******@newsgroup.nospamwrote in message
news:OB**************@TK2MSFTNGP02.phx.gbl...

I have different database connections that I use for DEV and PROD versions
of our web app.

I want to put the database connection string in one location so I only
have to change it once when we push live.

So I put it in an include file and reference it in all my asp pages as:
<!--#include file="includes/db_conn.inc"-->

But this will not work with the global.asa page.

How can I reference an include page from global.asa?

Don't store the connection string in an include. Store it in the global.asa
as an appplication variable:

Sub Application_OnStart
Application("connStr") = "Provider=<provider>;Data Source=<datasource>"
End Sub

--
Mike Brind

[Dave]

Yes. That works much better.

Thanks

"Mike Brind" <pa*******@hotmail.comwrote in message
news:eB**************@TK2MSFTNGP03.phx.gbl...

>
"Dave" <da*******@newsgroup.nospamwrote in message
news:OB**************@TK2MSFTNGP02.phx.gbl...

>I have different database connections that I use for DEV and PROD
versions of our web app.

I want to put the database connection string in one location so I only
have to change it once when we push live.

So I put it in an include file and reference it in all my asp pages as:
<!--#include file="includes/db_conn.inc"-->

But this will not work with the global.asa page.

How can I reference an include page from global.asa?

Don't store the connection string in an include. Store it in the
global.asa as an appplication variable:

Sub Application_OnStart
Application("connStr") = "Provider=<provider>;Data Source=<datasource>"
End Sub

--
Mike Brind

[Steven Cheng[MSFT]]

Hello Dave,

Another option is create a lightweight COM component and use it to return
connectionstring, this can help hidden the connectionstring in COM object
instead of put the clear text in global.asa or other page file. You can use
VB to create a activex component conveniently. And in your page or
global.asa you just need to create the COM object and query for
connectionstring. e.g.

=============

<%
dim obj
dim connstr

obj = Server.CreateObject("mycomponent")
connstr = obj.GetConnectionString()
%>

==========

Hope also helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.