«

Upon reading through my ASP.NET book, I've learned how to place the
connection string in both locations in my application. Just due to habit, I
naturally want to place my SQL Server connection string in the asax
file...but are there really advantages to having in one file over the other?

Thanks

Your web.config file is generally considered a better place because it's a
simple text file that is easily updated without needing to recompile
anything and changes go into effect immediately.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com



"D. Shane Fowlkes" <> wrote in message
news:%...
> Upon reading through my ASP.NET book, I've learned how to place the
> connection string in both locations in my application. Just due to habit,
I
> naturally want to place my SQL Server connection string in the asax
> file...but are there really advantages to having in one file over the
other?
>
> Thanks
>
>

I agree.

I use the web.config file because in our environment I
have to move an application from development to staging
(for testing) and then up to production. So rather than
making the change in the asax file and recompiling every
time before pushing the application up to the next stage I
just open the web.config and make the change.

I guess it's all just preference, whatever you feel most
comfortable in doing, but I vote for web.config

Jeremy

>-----Original Message-----
>Your web.config file is generally considered a better
place because it's a
>simple text file that is easily updated without needing
to recompile
>anything and changes go into effect immediately.
>
>--
>I hope this helps,
>Steve C. Orr, MCSD, MVP
>http://Steve.Orr.net
>Hire top-notch developers at http://www.able-
consulting.com
>
>
>
>"D. Shane Fowlkes" <> wrote
in message
>news:%...
>> Upon reading through my ASP.NET book, I've learned how
to place the
>> connection string in both locations in my application.
Just due to habit,
>I
>> naturally want to place my SQL Server connection string
in the asax
>> file...but are there really advantages to having in one
file over the
>other?
>>
>> Thanks
>>
>>
>
>
>.
>