p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

Go Back   p2p.wrox.com Forums > ASP.NET and ASP > ASP.NET 2.0 > Visual Web Developer 2005
Reload this Page SQL 200 Connection String Problem
I forgot my password Register Now
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.

Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old October 15th, 2009, 03:13 AM
Registered User
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 7%
Activity: 7% Activity: 7% Activity: 7%
 
Join Date: Oct 2009
Posts: 5
Thanks: 1
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...
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #2 (permalink)  
Old October 15th, 2009, 03:37 AM
Friend of Wrox
Points: 1,882, Level: 17
Points: 1,882, Level: 17 Points: 1,882, Level: 17 Points: 1,882, Level: 17
Activity: 7%
Activity: 7% Activity: 7% Activity: 7%
 
Join Date: May 2004
Location: India
Posts: 563
Thanks: 0
Thanked 14 Times in 14 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #3 (permalink)  
Old October 15th, 2009, 03:56 AM
Registered User
Points: 24, Level: 1
Points: 24, Level: 1 Points: 24, Level: 1 Points: 24, Level: 1
Activity: 7%
Activity: 7% Activity: 7% Activity: 7%
 
Join Date: Oct 2009
Posts: 5
Thanks: 1
Thanked 0 Times in 0 Posts
Default
Thnx I got the files...........Should I copy both files (.mdf & .ldf) on my hosting server?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
  #4 (permalink)  
Old October 15th, 2009, 05:21 AM
Friend of Wrox
Points: 1,882, Level: 17
Points: 1,882, Level: 17 Points: 1,882, Level: 17 Points: 1,882, Level: 17
Activity: 7%
Activity: 7% Activity: 7% Activity: 7%
 
Join Date: May 2004
Location: India
Posts: 563
Thanks: 0
Thanked 14 Times in 14 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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Reddit!
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forsale Playstation 3 60GB = $200 Nokia N95 = $200 ogun23 Intro Programming 0 September 16th, 2007 11:21 AM
SQL connection string naeem.net SQL Server ASP 0 July 10th, 2007 03: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 01:35 AM
problem 2 connecting SQL Server 200 using ASP.NET nagen111 ADO.NET 5 February 16th, 2005 01:26 AM



All times are GMT -4. The time now is 02:35 AM.

Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
© 2008 Wiley Publishing, Inc