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

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.

Thnx I got the files...........Should I copy both files (.mdf & .ldf) on my hosting server?

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.