In VS 2010 I use these steps to connect to SQL Server database:
- in server explorer window,Right Click on Data Connections
- Click Add Connection
- in choose data source window ,select SQL Server
- click continue, button
- "Add Connection" window will appear
- in the server name text box type ".\sqlexpress"
- in the select or enter database name type"Person"
- Click Test Connection — i see "test connection successed"
- Finally Click OK Button
At step 9 I see this error: "Unable ti find the requested .Net Framework Data Provider It May not be Installed"
Best Answer
There is a self terminating node in the machine.config file. Removing it solved the issue.
machine.config is found in
You could have a multitude of config files based on how many versions of the framework are installed, including 32 and 64 bit variants.
Above file remove
<DbProviderFactories/>
empty tag.For additional reading Obtaining a DbProviderFactory (ADO.NET)
I hope this will help to you.