Webgrid throwing exception connection to Oracle Database

Hans — Thu, 04 Sep 2014 23:02:35 GMT

Hello,

I apologize for any inconvenience this problem may have caused you.

I tried to find the solution based on your error message from another source & community / forum.

I came up with a couple of solution you might try:
1. Please make sure that you have installed Oracle Data Access Components.
2. Please try to check that the correct assembly was installed in the GAC.
3. Please try to add the following DbProviderFactory entry to the web.config.

<system.data>	<DbProviderFactories>
		<add name="Oracle Data Provider for .NET"
		invariant="Oracle.DataAccess.Client"
		description="Oracle Data Provider for .NET"
		type="Oracle.DataAccess.Client.OracleClientFactory,
		Oracle.DataAccess,
		Version=2.111.6.20,
		Culture=neutral,
		PublicKeyToken=89b483f429c47342" />
 	</DbProviderFactories>
</system.data>

And another possible solution is remove the "Managed" word in the provider name.

From:
connectionString="DATA SOURCE=10.3.10.101:1521/dataconn;PASSWORD=password;PERSIST   SECURITY INFO=True;USER ID=DataConn" providerName="Oracle.ManagedDataAccess.Client"

To:
connectionString="DATA SOURCE=10.3.10.101:1521/dataconn;PASSWORD=password;PERSIST     SECURITY INFO=True;USER ID=DataConn" providerName="Oracle.DataAccess.Client

Here’s the source links that I found regarding this issue:
http://forums.asp.net/t/1734918.aspx?Unable+to+find+the+requested+Net+Framework+Data+Provider+It+may+not+be+installed+
http://stackoverflow.com/questions/17528252/odp-net-error-unable-to-find-the-requested-net-framework-data-provider
http://blogs.msdn.com/b/dotnetinterop/archive/2006/03/17/connecting-asp-net-2-0-gridview-to-oracle.aspx

Hope this helps.

Regards,
Hans K.

Webgrid throwing exception connection to Oracle Database

gareth.durant@frontiersoftware.com.au — Thu, 04 Sep 2014 01:17:58 GMT

I have a webgrid control on my page that is using SqlDataSource to connect to an Oracle database.

The connection string to the oracle database is setup in the web.config, as seen below:

The SqlDataSource is defined as:

<asp:SqlDataSource ID="sqlRPWReports" runat="server" ConnectionString="<%$ ConnectionStrings:RPW %>" SelectCommand="SELECT * FROM [RPWReportHeader] ORDER BY ReportName" ProviderName="<%$ ConnectionStrings:RPW.ProviderName %>" ></asp:SqlDataSource>

The Webgrid is defined as :

<ISWebGrid:WebGrid ID="WebGrid1" runat="server" DataSourceID="sqlRPWReports" Height="350px" UseDefaultStyle="True" OnInit="WebGrid1_Init" OnButtonClick="WebGrid1_RebindData" Width="100%" DefaultStyleMode="Win7"> <LayoutSettings AllowAddNew="No" ColumnFooters="Yes" AllowDelete="No" AllowColumnMove="Yes" AllowEdit="No" AllowExport="Yes" AllowFilter="No" AllowGrouping="Yes" AllowSelectColumns="Yes" AllowSorting="Yes" EditOnClick="False"> </LayoutSettings> <RootTable DataKeyField="ReportId"> <SortedColumns> </SortedColumns> <Columns> <ISWebGrid:WebGridColumn Caption="Report Id" Visible="false" DataMember="ReportId" Name="ReportId" EditType="NoEdit" Width="150px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Report Name" DataMember="ReportName" Name="ReportName" Width="150px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Owner" DataMember="Owner" Name="Owner" Width="150px"> </ISWebGrid:WebGridColumn> <ISWebGrid:WebGridColumn Caption="Category" DataMember="Category" Name="Category" Width="150px"> </ISWebGrid:WebGridColumn> </Columns> </RootTable> </ISWebGrid:WebGrid>

When running the page I get the following exception:

chris21 ExpressReports encountered a fatal error causing process to stop - error is : System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed. at
System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() at
System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure() at System.Web.UI.WebControls.SqlDataSource.CreateConnection(String connectionString) at
System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments,
DataSourceViewSelectCallback callback) at ISNet.WebUI.DataSourceInfo.PerformSelect() at ISNet.WebUI.WebGrid.WebGridDataSourceInfo.PerformSelect() at ISNet.WebUI.DataSourceInfo.DataBind() at
ISNet.WebUI.DataSourceInfo.EnsureDataBound() at ISNet.WebUI.DataSourceInfo.set_RequiresDataBinding(Boolean value) at ISNet.WebUI.WebGrid.WebGrid.?(Boolean) at ISNet.WebUI.WebGrid.WebGrid.() at
ISNet.WebUI.WebGrid.WebGrid.OnInitializeDataSource(Object dataSource) at ISNet.WebUI.WebGrid.WebGrid.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Any assistance would be great.

Thanks.

Intersoft Community - WebGrid Enterprise - Webgrid throwing exception connection to Oracle Database

Webgrid throwing exception connection to Oracle Database

Webgrid throwing exception connection to Oracle Database