Wrox Programmer Forums
|
Visual Web Developer 2005 Discuss creating ASP.NET 2.0 sites with Microsoft's Visual Web Developer 2005. If your question is more specific to a piece of code than the Visual tool, see the ASP.NEt 2.0 forums instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Web Developer 2005 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 October 15th, 2009, 02:13 AM
Authorized User
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2009
Posts: 72
Thanks: 17
Thanked 0 Times in 0 Posts
Default SQL 200 Connection String Problem

Hi,


I am using vwd 2005 & SQL Server 2000.

Now I got 2 problems -

1. How to Copy the SQL Server 2000 Database on Hosting Server(What i mean is where to search SQL 2000 Database file on my local PC)?

2.What Connection String to Use (should work on Hosting Server)?


Thanx in Advance....

Pls help me...
 
Old October 15th, 2009, 02:37 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Data files are generally stored in Data folder:

Microsoft SQL Server\MSSQL.2\MSSQL\Data

You can also check the database file path in SQL database

Right click on database --> select properties --> Under files you can get the path of mdf and ldf files.

Regarding connection strings, please check the following URL:
http://www.connectionstrings.com/sql-server
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.
 
Old October 15th, 2009, 02:56 AM
Authorized User
Points: 410, Level: 7
Points: 410, Level: 7 Points: 410, Level: 7 Points: 410, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2009
Posts: 72
Thanks: 17
Thanked 0 Times in 0 Posts
Default

Thnx I got the files...........Should I copy both files (.mdf & .ldf) on my hosting server?
 
Old October 15th, 2009, 04:21 AM
Friend of Wrox
 
Join Date: May 2004
Posts: 642
Thanks: 0
Thanked 43 Times in 42 Posts
Default

Yes.

You can also take the backup of database and restore.
http://msdn.microsoft.com/en-us/library/ms177429.aspx

Please check the following links to restore database:
http://articles.techrepublic.com.com...1-1041267.html
http://technet.microsoft.com/en-us/l.../cc966495.aspx
__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL connection string naeem.net SQL Server ASP 0 July 10th, 2007 02:17 PM
Problem with AGGREGATE FUNCTIONS in SQL SERVER 200 vikiboye SQL Server 2005 1 February 20th, 2006 12:07 PM
Problem with SQL SERVER Connection String Non Linear BOOK: Beginning ASP 3.0 3 October 20th, 2005 12:35 AM
problem 2 connecting SQL Server 200 using ASP.NET nagen111 ADO.NET 5 February 16th, 2005 01:26 AM





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