Answer 1

These 2 MS websites below state that the System.Data.SqlClient can be used for Microsoft SQL Server 7.0 or a later.

However, in VWD 2010 design view on default.aspx, when I do :

I get a pop-up box stating

        'This server version is not supported. You must have MS SQL server 2005 or later.'

In this first website with ADO.NET code example, i don't see the Provider.

http://msdn.microsoft.com/en-us/library/dw70f090.aspx

SqlClient
The code in this example assumes that you can connect to the Northwind sample database on Microsoft SQL Server 7.0 or a later version.

http://msdn.microsoft.com/en-us/library/a6cd7c08.aspx

.NET Framework Data Provider for SQL Server (SqlClient)

To use the .NET Framework Data Provider for SQL Server, you must have access to SQL Server 7.0 or later versions.

Any assistance would be appreciated!
 

Answer 2

Hi , i am not fimiliar to Sql 2000 and VWD 2010 working together or neither i  ever tryed it , but why not upgrade to SSMStudio 2008 http://www.microsoft.com/express/database/ ??

Then you can just import your old database to SSMS 2008 i hope .

Here is connections string for Sqlserver 2000

http://www.connectionstrings.com/sql-server   http://www.connectionstrings.com/sql-server

in C# codebehing add this

using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)
        {
using (SqlConnection cnn = new SqlConnection("Persist Security Info=True;Data Source=datasource;database=; User ID=userid;password=password"))
            {
                cnn.Open();
                using (SqlCommand cmd = new SqlCommand(" SELECT [name] FROM sys.Tables ", cnn))
        }

if you want it in VB.net code then use this program

http://www.developerfusion.com/tools/convert/csharp-to-vb/

Hope this helps