Using Web.Config for Legacy .ASP to get A Connection String

[gregory_may]

I have a mixed ASP.NET and legacy ASP application.

Right now, the .ASP pages use a mix of Hard Coded connection strings and an
"Global Included" file. I would like to use the connection string in the
Web.Config for all the Legacy .Asp pages.

Anyone know of a good way to do this? Here is a snip of my Web.Config (from
one system).

I thought about doing a simple text search on "DataConnectionString" and
pulling the "Value", but I thought there may be a better way?

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="dataconnectstring" value="user id=ID;password=Pass;initial
catalog=cat;data source=source;pooling='false'" />

[Bruce Barker]

use the com based xml libray and an xpath to read it.

-- bruce (sqlwork.com)

"gregory_may" <None> wrote in message
news:OF**************@tk2msftngp13.phx.gbl...

I have a mixed ASP.NET and legacy ASP application.

Right now, the .ASP pages use a mix of Hard Coded connection strings and
an "Global Included" file. I would like to use the connection string in
the Web.Config for all the Legacy .Asp pages.

Anyone know of a good way to do this? Here is a snip of my Web.Config
(from one system).

I thought about doing a simple text search on "DataConnectionString" and
pulling the "Value", but I thought there may be a better way?

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="dataconnectstring" value="user id=ID;password=Pass;initial
catalog=cat;data source=source;pooling='false'" />