Using System.Data.Common.DbProviderFactory with Mono

View: New views
7 Messages — Rating Filter:   Alert me  

Using System.Data.Common.DbProviderFactory with Mono

by dr_d00m :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

I am trying to create an application which should be designed for common database connectivity. Therefore I used the System.Data.Common.DbProviderFactory. I created my application in Visual Studio and then tried to run it under Mono. I also tested it with Moma which gave me the go-ahead in any cases. In .Net everything worked fine but under Mono it threw a weired exception.

Unhandled Exception: System.Configuration.ConfigurationErrorsException: Failed to find or load the registered .Net Framework Data Provider. () ()
  at System.Data.Common.DbProviderFactories.GetFactory (System.Data.DataRow providerRow) [0x00000]
  at System.Data.Common.DbProviderFactories.GetFactory (System.String providerInvariantName) [0x00000]
  at Connectivity.DBLoader.Load () [0x00000]


I tried to google this one but without any success.

The code looks like this:

...
using System.Data.OracleClient;
using System.Data.Common;
...

DbProviderFactory factory = DbProviderFactories.GetFactory(providerString);              
                using (conn = factory.CreateConnection())
                {
                    conn.ConnectionString = ConnectionParameter;
                    conn.Open();  
               
                    // Here the data from the database is processed.

                    conn.Close();
                }


Is there anything I did not consider or is it impossible to procede like this under Mono in general?

Thanks in advance for any help.

Best regard,

dr_d00m

Re: Using System.Data.Common.DbProviderFactory with Mono

by Veerapuram Varadhan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

Can you file a bug and attach a sample console app using similar
providerstring?  It would be easier to track and solve this through
bugzilla.

Thanks,

V. Varadhan

On Thu, 2008-02-28 at 04:19 -0800, dr_d00m wrote:

> Hello,
>
> I am trying to create an application which should be designed for common
> database connectivity. Therefore I used the
> System.Data.Common.DbProviderFactory. I created my application in Visual
> Studio and then tried to run it under Mono. I also tested it with Moma which
> gave me the go-ahead in any cases. In .Net everything worked fine but under
> Mono it threw a weired exception.
>
> Unhandled Exception: System.Configuration.ConfigurationErrorsException:
> Failed to find or load the registered .Net Framework Data Provider. () ()
>   at System.Data.Common.DbProviderFactories.GetFactory (System.Data.DataRow
> providerRow) [0x00000]
>   at System.Data.Common.DbProviderFactories.GetFactory (System.String
> providerInvariantName) [0x00000]
>   at Connectivity.DBLoader.Load () [0x00000]
>
> I tried to google this one but without any success.
>
> The code looks like this:
>
> ...
> using System.Data.OracleClient;
> using System.Data.Common;
> ...
>
> DbProviderFactory factory = DbProviderFactories.GetFactory(providerString);              
>                 using (conn = factory.CreateConnection())
>                 {
>                     conn.ConnectionString = ConnectionParameter;
>                     conn.Open();  
>                
>                     // Here the data from the database is processed.
>
>                     conn.Close();
>                 }
>
> Is there anything I did not consider or is it impossible to procede like
> this under Mono in general?
>
> Thanks in advance for any help.
>
> Best regard,
>
> dr_d00m
>

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

Re: Using System.Data.Common.DbProviderFactory with Mono

by dr_d00m :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I posted the bug as Bug 365911 to bugzilla.novell.com

Thanks for any further help.


Veerapuram Varadhan wrote:
Hi,

Can you file a bug and attach a sample console app using similar
providerstring?  It would be easier to track and solve this through
bugzilla.

Thanks,

V. Varadhan

On Thu, 2008-02-28 at 04:19 -0800, dr_d00m wrote:
> Hello,
>
> I am trying to create an application which should be designed for common
> database connectivity. Therefore I used the
> System.Data.Common.DbProviderFactory. I created my application in Visual
> Studio and then tried to run it under Mono. I also tested it with Moma which
> gave me the go-ahead in any cases. In .Net everything worked fine but under
> Mono it threw a weired exception.
>
> Unhandled Exception: System.Configuration.ConfigurationErrorsException:
> Failed to find or load the registered .Net Framework Data Provider. () ()
>   at System.Data.Common.DbProviderFactories.GetFactory (System.Data.DataRow
> providerRow) [0x00000]
>   at System.Data.Common.DbProviderFactories.GetFactory (System.String
> providerInvariantName) [0x00000]
>   at Connectivity.DBLoader.Load () [0x00000]
>
> I tried to google this one but without any success.
>
> The code looks like this:
>
> ...
> using System.Data.OracleClient;
> using System.Data.Common;
> ...
>
> DbProviderFactory factory = DbProviderFactories.GetFactory(providerString);              
>                 using (conn = factory.CreateConnection())
>                 {
>                     conn.ConnectionString = ConnectionParameter;
>                     conn.Open();  
>                
>                     // Here the data from the database is processed.
>
>                     conn.Close();
>                 }
>
> Is there anything I did not consider or is it impossible to procede like
> this under Mono in general?
>
> Thanks in advance for any help.
>
> Best regard,
>
> dr_d00m
>

_______________________________________________
Mono-list maillist  -  Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list

Re: Using System.Data.Common.DbProviderFactory with Mono

by dr_d00m :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

I started this thread about a month ago and I still do not know how to handle the problem.
I checked it with the new 1.9 version, but with the same result.
Is there anybody who recognized my bug report?
Or is it just a stupid mistake I made using Mono?

I would be glad if anybody could give me a small hint about this...

Thanks,

dr_d00m


Hi,

I posted the bug as Bug 365911 to bugzilla.novell.com

Thanks for any further help.


Veerapuram Varadhan wrote:
Hi,

Can you file a bug and attach a sample console app using similar
providerstring?  It would be easier to track and solve this through
bugzilla.

Thanks,

V. Varadhan

On Thu, 2008-02-28 at 04:19 -0800, dr_d00m wrote:
> Hello,
>
> I am trying to create an application which should be designed for common
> database connectivity. Therefore I used the
> System.Data.Common.DbProviderFactory. I created my application in Visual
> Studio and then tried to run it under Mono. I also tested it with Moma which
> gave me the go-ahead in any cases. In .Net everything worked fine but under
> Mono it threw a weired exception.
>
> Unhandled Exception: System.Configuration.ConfigurationErrorsException:
> Failed to find or load the registered .Net Framework Data Provider. () ()
>   at System.Data.Common.DbProviderFactories.GetFactory (System.Data.DataRow
> providerRow) [0x00000]
>   at System.Data.Common.DbProviderFactories.GetFactory (System.String
> providerInvariantName) [0x00000]
>   at Connectivity.DBLoader.Load () [0x00000]
>
> I tried to google this one but without any success.
>
> The code looks like this:
>
> ...
> using System.Data.OracleClient;
> using System.Data.Common;
> ...
>
> DbProviderFactory factory = DbProviderFactories.GetFactory(providerString);              
>                 using (conn = factory.CreateConnection())
>                 {
>                     conn.ConnectionString = ConnectionParameter;
>                     conn.Open();  
>                
>                     // Here the data from the database is processed.
>
>                     conn.Close();
>                 }
>
> Is there anything I did not consider or is it impossible to procede like
> this under Mono in general?
>
> Thanks in advance for any help.
>
> Best regard,
>
> dr_d00m
>

_______________________________________________
Mono-list maillist  -  Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list


Re: Using System.Data.Common.DbProviderFactory with Mono

by Veerapuram Varadhan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,
On Fri, 2008-03-28 at 05:15 -0700, dr_d00m wrote:
> Hi,
>
> I started this thread about a month ago and I still do not know how to
> handle the problem.
> I checked it with the new 1.9 version, but with the same result.
> Is there anybody who recognized my bug report?
> Or is it just a stupid mistake I made using Mono?
>
As with any software, bugs are part of it and we sincerely appreciate
your efforts to help us clean these bugs.  While we appreciate your
efforts in helping us by reporting bugs, we also seek some kinda
understanding that bugs are handled according to some priorities and
sometimes they may not attract immediate attention.

> I would be glad if anybody could give me a small hint about this...
Anyway, your bug will be handled soon and more follow through on
bugzilla.

Thanks,

V. Varadhan

> Thanks,
>
> dr_d00m
>
>
> dr_d00m wrote:
> >
> > Hi,
> >
> > I posted the bug as Bug 365911 to bugzilla.novell.com
> >
> > Thanks for any further help.
> >
> >
> >
> > Veerapuram Varadhan wrote:
> >>
> >> Hi,
> >>
> >> Can you file a bug and attach a sample console app using similar
> >> providerstring?  It would be easier to track and solve this through
> >> bugzilla.
> >>
> >> Thanks,
> >>
> >> V. Varadhan
> >>
> >> On Thu, 2008-02-28 at 04:19 -0800, dr_d00m wrote:
> >>> Hello,
> >>>
> >>> I am trying to create an application which should be designed for common
> >>> database connectivity. Therefore I used the
> >>> System.Data.Common.DbProviderFactory. I created my application in Visual
> >>> Studio and then tried to run it under Mono. I also tested it with Moma
> >>> which
> >>> gave me the go-ahead in any cases. In .Net everything worked fine but
> >>> under
> >>> Mono it threw a weired exception.
> >>>
> >>> Unhandled Exception: System.Configuration.ConfigurationErrorsException:
> >>> Failed to find or load the registered .Net Framework Data Provider. ()
> >>> ()
> >>>   at System.Data.Common.DbProviderFactories.GetFactory
> >>> (System.Data.DataRow
> >>> providerRow) [0x00000]
> >>>   at System.Data.Common.DbProviderFactories.GetFactory (System.String
> >>> providerInvariantName) [0x00000]
> >>>   at Connectivity.DBLoader.Load () [0x00000]
> >>>
> >>> I tried to google this one but without any success.
> >>>
> >>> The code looks like this:
> >>>
> >>> ...
> >>> using System.Data.OracleClient;
> >>> using System.Data.Common;
> >>> ...
> >>>
> >>> DbProviderFactory factory =
> >>> DbProviderFactories.GetFactory(providerString);              
> >>>                 using (conn = factory.CreateConnection())
> >>>                 {
> >>>                     conn.ConnectionString = ConnectionParameter;
> >>>                     conn.Open();  
> >>>                
> >>>                     // Here the data from the database is processed.
> >>>
> >>>                     conn.Close();
> >>>                 }
> >>>
> >>> Is there anything I did not consider or is it impossible to procede like
> >>> this under Mono in general?
> >>>
> >>> Thanks in advance for any help.
> >>>
> >>> Best regard,
> >>>
> >>> dr_d00m
> >>>
> >>
> >> _______________________________________________
> >> Mono-list maillist  -  Mono-list@...
> >> http://lists.ximian.com/mailman/listinfo/mono-list
> >>
> >>
> >
> >
>

_______________________________________________
Mono-list maillist  -  Mono-list@...
http://lists.ximian.com/mailman/listinfo/mono-list

Re: Using System.Data.Common.DbProviderFactory with Mono

by ssamayoa :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> As with any software, bugs are part of it and we sincerely appreciate
> your efforts to help us clean these bugs.  While we appreciate your
> efforts in helping us by reporting bugs, we also seek some kinda
> understanding that bugs are handled according to some priorities and
> sometimes they may not attract immediate attention.

I cant belive that nobody else has this problem!

Re: Using System.Data.Common.DbProviderFactory with Mono

by hannes_a :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I have a similar problem with ASP.NET site to connect to oracle on mono.
Same error message with mono 1.9.1 Oracle 11g 64 bit on openSuse 10.3 64 bit
Since weeks Im playing around without success.
Does anyone use mono on linux with oracle ?

ssamayoa wrote:
> As with any software, bugs are part of it and we sincerely appreciate
> your efforts to help us clean these bugs.  While we appreciate your
> efforts in helping us by reporting bugs, we also seek some kinda
> understanding that bugs are handled according to some priorities and
> sometimes they may not attract immediate attention.

I cant belive that nobody else has this problem!