connectionstrin g in global.asax or web.config?

[Bob]

Hi,

i was wondering whether i would use global.asax or web.config for the
connectionstrin g to the database. I put this in global.asax.

Sub Application_Sta rt
Application("Co nnect") = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\mydb. mdb;"
End Sub

In web.config, i added:
<appSettings>
<add key="newres" value"Provider= Microsoft.Jet.O LEDB.4.0;Data
Source=c:\mydb. mdb;"/>
</appSettings>
What's the best way (speed, resources ..) according to you?

Thanks
bob

[Yves. L.]

the best place is your *configuration* file; i.e web.config

YvesL
Bob wrote:

Hi,

i was wondering whether i would use global.asax or web.config for the
connectionstrin g to the database. I put this in global.asax.

Sub Application_Sta rt
Application("Co nnect") = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\mydb. mdb;"
End Sub

In web.config, i added:
<appSettings>
<add key="newres" value"Provider= Microsoft.Jet.O LEDB.4.0;Data
Source=c:\mydb. mdb;"/>
</appSettings>
What's the best way (speed, resources ..) according to you?

Thanks
bob

--
Regards,
YvesL

[Jason Hales]

It's much easier to put in web.config. That way you don't need to
recompile each time the connection string changes. Just edit
web.config and away you go

The downside is that web.config is an xml file which is humanly
readable so any passwords will be visible anyone that can access your
web site's content files locally

IIS will not serve up the web.config file though -
http://mywebsite.com/web.config will result in an server error

Bear in mind that MS Access is not particulartly scalable as a database
if you're epecting many concurrent visitors
Bob wrote:

Hi,

i was wondering whether i would use global.asax or web.config for the
connectionstrin g to the database. I put this in global.asax.

Sub Application_Sta rt
Application("Co nnect") = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\mydb. mdb;"
End Sub

In web.config, i added:
<appSettings>
<add key="newres" value"Provider= Microsoft.Jet.O LEDB.4.0;Data
Source=c:\mydb. mdb;"/>
</appSettings>
What's the best way (speed, resources ..) according to you?

Thanks
bob

[John Timney \(MVP\)]

use web.config, thats what its for. If your worried about security then
ecnypt it......

http://weblogs.asp.net/scottgu/archi...09/434893.aspx

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
http://www.johntimney.com/blog
"Bob" <gtdbdwrote in message
news:OI******** ********@TK2MSF TNGP03.phx.gbl. ..

Hi,

i was wondering whether i would use global.asax or web.config for the
connectionstrin g to the database. I put this in global.asax.

Sub Application_Sta rt
Application("Co nnect") = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\mydb. mdb;"
End Sub

In web.config, i added:
<appSettings>
<add key="newres" value"Provider= Microsoft.Jet.O LEDB.4.0;Data
Source=c:\mydb. mdb;"/>
</appSettings>
What's the best way (speed, resources ..) according to you?

Thanks
bob

[Bob]

Thanks all

"John Timney (MVP)" <x_****@timney. eclipse.co.uksc hreef in bericht
news:CL******** *************** *******@eclipse .net.uk...

use web.config, thats what its for. If your worried about security then
ecnypt it......

http://weblogs.asp.net/scottgu/archi...09/434893.aspx

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
http://www.johntimney.com/blog
"Bob" <gtdbdwrote in message
news:OI******** ********@TK2MSF TNGP03.phx.gbl. ..

>Hi,

i was wondering whether i would use global.asax or web.config for the
connectionstri ng to the database. I put this in global.asax.

Sub Application_Sta rt
Application("C onnect") = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=c:\mydb .mdb;"
End Sub

In web.config, i added:
<appSettings >
<add key="newres" value"Provider= Microsoft.Jet.O LEDB.4.0;Data
Source=c:\mydb .mdb;"/>
</appSettings>
What's the best way (speed, resources ..) according to you?

Thanks
bob

[Mark Rae]

"John Timney (MVP)" <x_****@timney. eclipse.co.ukwr ote in message
news:CL******** *************** *******@eclipse .net.uk...

use web.config, thats what its for.

Agreed.

If your worried about security then ecnypt it......

Bear in mind that this will (almost certainly) not be possible on a public
site hosted by a 3rd-party ISP, as the account they give you to upload your
files will (almost certainly) not have sufficient privileges to run
aspnet_regiis, even if you somehow manage to pop a command window...:-)

[John Timney \(MVP\)]

Good point - forgot that bit :)

I assume that everyone hosts their own stuff on old laptops adn defunct kit
like I do........

--
--
Regards

John Timney (MVP)
VISIT MY WEBSITE:
http://www.johntimney.com
http://www.johntimney.com/blog
"Mark Rae" <ma**@markNOSPA Mrae.comwrote in message
news:%2******** **********@TK2M SFTNGP03.phx.gb l...

"John Timney (MVP)" <x_****@timney. eclipse.co.ukwr ote in message
news:CL******** *************** *******@eclipse .net.uk...

>use web.config, thats what its for.

Agreed.

>If your worried about security then ecnypt it......

Bear in mind that this will (almost certainly) not be possible on a public
site hosted by a 3rd-party ISP, as the account they give you to upload
your files will (almost certainly) not have sufficient privileges to run
aspnet_regiis, even if you somehow manage to pop a command window...:-)