System.Data.SQLClient

[jimmyjoe]

Hi,

I'm attempting to configure the SQLDataSource Control in the dev environment
of vs 2005. I've made a data connection in the server explorer to the
target database on another server. I also have a 2nd connection setup in
webconfig. Same database.

In the "Configure Data Source" dialog in the drop downlist used to connect
to the database, I have two entries
1. TestOne (web.config)
2. McCartney.TestOne.dbo (data connection)

When I try to select 1 I receive the following error message:
"The data provider 'System.Data.SqlClient' could not be found in the system
configuration. Unable to find the requested .Net Framework Data Provider.
It may not be installed."

#2 works fine.

I've reinstalled the .net framework.

I've found the following in machine.config:
<section name="system.data.sqlclient"
type="System.Data.Common.DbProviderConfigurationHandler, System.Data,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />"

I have the following code in web.config:
<connectionStrings>
<add name="TestOne"
connectionString="McCartney;Database=TestOne;Integrated
Security=SSPI;Persist Security Info=False"/>
providerName="System.Data.SqlClient" />
</connectionStrings>

So the system is not reading the web.config file for some reason. I know
the code in the web.config works because I've tried a simpler connection.

XP Pro sp2
..net v2.0.50727

Any one have any ideas??

thanx....