Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 25th, 2006, 02:03 PM
Authorized User
 
Join Date: Feb 2006
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.
 
Old February 26th, 2006, 03:13 AM
Authorized User
 
Join Date: Jan 2006
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.
 
Old February 26th, 2006, 12:36 PM
Authorized User
 
Join Date: Feb 2006
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.





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 8th, 2007 11:08 PM
Microsoft Visual Web Developer 2005 Express Editio FT BOOK: ASP.NET Website Programming Problem-Design-Solution 10 April 24th, 2006 12:25 AM
SQL Server 2005 Express with Visual Web Developer steffteo SQL Server 2005 1 March 19th, 2006 04:28 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.