ksfok
asked on
Publish ASP.NET 2 web site with SqlEXpress in App_Data
I have a dev database with memberships and roles created in SqlServer 2005 developer. Now I need to deploy the said database with an ASP.NET 2.0 web site to a remote web server where no production SqlServer license is available. Can I create an App_Data folder in the dev web site, detach the said database mdf/log, place the mdf/log in the App_Data folder, and publish the site as with a SqlExpress datbase? Please advise. Thanks.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I know how to declare connectionstring for a database on a sqlserver instance, but forgot how to do it for a database stored in App_Data. Please help. Thanks.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Please kindly confirm this:
Driver={SQL Native Client};Server=.\SQLExpres
Is the above to be entered exactly as it is in the connectionstring without a SQLExpress instance installed as in my case? Anything else to do additionally?
Thanks.
Driver={SQL Native Client};Server=.\SQLExpres
Is the above to be entered exactly as it is in the connectionstring without a SQLExpress instance installed as in my case? Anything else to do additionally?
Thanks.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASP.NET
The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications
128K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
1) The database must be placed in App_Data.
2) Can multiple databases be placed in App_Data?
3) How can I declare connection strings in Web.config?
4) How many connections are allowed?
Thanks