.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

SQL 2000 Connection string problem on hosting server

Posted By: Anup     Posted Date: October 14, 2009    Points:2   Category :ASP.Net

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...

Author: Faizal             
Posted Date: October 15, 2009     Points: 5   

You can populate data into hosting server in 2 ways

1) Take the backup (.bak) file and restore the .bak file into hosting server (If you are using 3party hosting every hosting company control panel provide this interface to restore backup file)

2) Generate the sql script and run this script to your production database

Regarding your 2nd question

You have to assign the server pointing to your hosting database in your web.config file or where ever you wrote the connection string. Connection string format will be the same as your local db but the value will be changed..

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend