iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
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:
<add name="RPW" connectionString="Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.50.240)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=STGSAFR)));User Id=expr_master;Password=Frontier_6;" providerName="Oracle.ManagedDataAccess.Client"/>
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. atSystem.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) at System.Web.UI.WebControls.SqlDataSource.GetDbProviderFactory() atSystem.Web.UI.WebControls.SqlDataSource.GetDbProviderFactorySecure() at System.Web.UI.WebControls.SqlDataSource.CreateConnection(String connectionString) atSystem.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() atISNet.WebUI.DataSourceInfo.EnsureDataBound() at ISNet.WebUI.DataSourceInfo.set_RequiresDataBinding(Boolean value) at ISNet.WebUI.WebGrid.WebGrid.?(Boolean) at ISNet.WebUI.WebGrid.WebGrid.() atISNet.WebUI.WebGrid.WebGrid.OnInitializeDataSource(Object dataSource) at ISNet.WebUI.WebGrid.WebGrid.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() atSystem.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() atSystem.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() atSystem.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() atSystem.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Any assistance would be great.
Thanks.
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-providerhttp://blogs.msdn.com/b/dotnetinterop/archive/2006/03/17/connecting-asp-net-2-0-gridview-to-oracle.aspxHope this helps.Regards,Hans K.
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname