Not able to connect to datasource

Posted by Sairam under ASP.NET on 12/2/2011 | Points: 10 | Views : 1187 | Status : [Member] | Replies : 3
I've created a new .aspx webpage. I created a field with dropdown box control. While trying to run the code I find the following error
Here is the detail of my error stack trace


ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.]
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +1420519
System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() +67
System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure() +22
System.Web.UI.WebControls.SqlDataSource.CreateConnection(String connectionString) +11
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +117
System.Web.UI.WebControls.ListControl.OnDataBinding(EventArgs e) +97
System.Web.UI.WebControls.ListControl.PerformSelect() +34
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +74
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +66
System.Web.UI.WebControls.ListControl.OnPreRender(EventArgs e) +29
System.Web.UI.Control.PreRenderRecursiveInternal() +103
System.Web.UI.Control.PreRenderRecursiveInternal() +175
System.Web.UI.Control.PreRenderRecursiveInternal() +175
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2496

I've been struggling for 2 days to fix this.

Here is teh detail of dataprovider form web.config file
<connectionStrings>
<add name="value" connectionString="value"
providerName="Microsoft.SqlServer.Client" />
</connectionStrings>

you can help me fix this

My SQL server is SQL server 2008 express edition

sairam


Responses

Posted by: Hmanjarawala on: 12/2/2011 [Member] Bronze | Points: 25

Up
0
Down
Change ProviderName="System.Data.SqlClient"

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Sairam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sairam on: 12/2/2011 [Member] Starter | Points: 25

Up
0
Down
IT is found to give a different result.

Ive sql server express

What are services that I need to start as it is sql connectivity issue now

sairam

Sairam, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Varung on: 12/3/2011 [Member] Starter | Points: 25

Up
0
Down
change connectionstring attribute value to
Data Source=SQLDevelopment; Initial Catalog=your database name; User Id=sql2008; Password=######;");

G.Varun

Sairam, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response