Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > ASP.NET 4 General Discussion
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 4 General Discussion For ASP.NET 4 discussions not relating to a specific Wrox book
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 4 General Discussion section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 9th, 2015, 09:14 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2015
Location: California foothills
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Deployment Problems

I have created a web site (with help from Professional ASP.NET 4 in C# and VB) and it works fine on my local machine. When I tried to deploy to the server at my hosting company I ran into problems. It appears that VS defaults to creating the Provider databases in SqlExpress. When I tried to deploy, I got errors saying that SqlExpress wasn't installed on the server. How do I tell VS that it needs to use SQL 2008 in release, but SqlExpress in debug for the Provider databases?
Reply With Quote
  #2 (permalink)  
Old October 9th, 2015, 11:51 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have the same question so looking forward to the answer
Reply With Quote
  #3 (permalink)  
Old October 10th, 2015, 04:48 AM
Imar's Avatar
Wrox Author
Points: 71,164, Level: 100
Points: 71,164, Level: 100 Points: 71,164, Level: 100 Points: 71,164, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,955
Thanks: 79
Thanked 1,556 Times in 1,533 Posts
Default

Hi there,

You'll need to update your web.config and have your connection strings on the server point to a different database serve.

You can use Web Publish Config Transformations (https://msdn.microsoft.com/en-us/lib...vs.100%29.aspx) to create different versions of web.config for local development and deployment to a server.

Hope this helps,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #4 (permalink)  
Old October 10th, 2015, 02:46 PM
Registered User
Points: 8, Level: 1
Points: 8, Level: 1 Points: 8, Level: 1 Points: 8, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2015
Location: California foothills
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, I already have different web.config files for the two environments. I think the problem I'm having is how to change the connection strings specifically for the provider databases created by VS, as opposed to the database I've created for my data. But I will look at the documents you suggest, as I'm sure there is information in there I can use.

Thanks!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Permission Problems on Deployment Hank_Marietta BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 August 22nd, 2007 01:29 PM
Deployment Problems rssimmons BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 1 August 12th, 2007 11:05 PM
deployment p2pMember ASP.NET 2.0 Basics 0 June 7th, 2007 02:12 AM
Deployment problems drb2k2 ASP.NET 2.0 Basics 2 May 9th, 2006 05:15 AM
Deployment regbnvl BOOK: Professional VB 2005 ISBN: 0-7645-7536-8 0 May 7th, 2006 05:44 PM



All times are GMT -4. The time now is 07:26 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.