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 :
'Configure data source' on a SqlDataSource to connect
to my SQL server 2000 (version 8, SP4) on another server,
and select '.NET Framework provider for SQL server' (SqlClient),
and do 'Test connection',
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.
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.
.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!