Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5
This is the forum to discuss the Wrox book Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter Kit by David Sussman, Alex Homer; ISBN: 9780764588075
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Wrox's ASP.NET 2.0 Visual Web Developer 2005 Express Edition Starter ISBN: 978-0-7645-8807-5 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 February 25th, 2006, 02:03 PM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP.Net 2.0 Visual Web Developer 2005 Express Ed

My question is once that I've got the example website working, I want to move it to a server. I used SQL 2005 Express for the development machine but the server is running SQL 2k. How do I convert the connection string so that when I copy the site to the new server it will find the SQL Svr 2k and work? In the past I did things with DSN's and am not sure how to proceed here.

thanks for any help you can give.
Reply With Quote
  #2 (permalink)  
Old February 26th, 2006, 03:13 AM
Authorized User
 
Join Date: Jan 2006
Location: , , .
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You just remove the section User Instance=true from the connection string. Then copy the database .mdf and .ldf files into the data directory of your server (probably something like Program Files\Microsoft SQL Server\80\MSSQL\Data for SQL Server 2000), and attach the database using the SQL Server Enterprise manager utility. You cannot just "copy the site" if the target database server is using SQL Server 2000 - you must attach the database files using Enterprise Manager or the equivalent T-SQL Script.
Reply With Quote
  #3 (permalink)  
Old February 26th, 2006, 12:36 PM
Authorized User
 
Join Date: Feb 2006
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks. I'll try that.

Chris

Quote:
quote:Originally posted by alexhomer
 You just remove the section User Instance=true from the connection string. Then copy the database .mdf and .ldf files into the data directory of your server (probably something like Program Files\Microsoft SQL Server\80\MSSQL\Data for SQL Server 2000), and attach the database using the SQL Server Enterprise manager utility. You cannot just "copy the site" if the target database server is using SQL Server 2000 - you must attach the database files using Enterprise Manager or the equivalent T-SQL Script.
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
Visual Web Developer 2008 Express jjc9809 Visual Web Developer 2008 2 December 23rd, 2008 12:06 PM
Visual Web Developer 2005 Express Edition - Limits snew BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 7 November 15th, 2007 01:00 PM
visual web developer express & net.2003 pirate_king ASP.NET 1.0 and 1.1 Basics 0 July 9th, 2007 12:08 AM
Microsoft Visual Web Developer 2005 Express Editio FT BOOK: ASP.NET Website Programming Problem-Design-Solution 10 April 24th, 2006 01:25 AM
SQL Server 2005 Express with Visual Web Developer steffteo SQL Server 2005 1 March 19th, 2006 04:28 PM



All times are GMT -4. The time now is 11:54 PM.


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