473,805 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Which MySQL Provider.

I've been given a project to work with which involves connecting to
MySQL from .NET 2.0 app. I've googled looked and there is a metric ton
of different MySQL ADO.NET providers from different people.

Is there a consensus on which one is the most stable, more or less
supported and has good support for the standard MySQL features (e.g.
stored procs)?

Regards.
Feb 2 '07
14 4513
Frans Bouma [C# MVP] <pe************ ******@xs4all.n lwrote:
>http://www.mysql.com/company/contact/?topic=licensing

before assuming that using connector/net means that your software has
to be GPL

err... it's very simple:
if you reference/link/use a GPL-ed piece of code in your own code, your
code HAS TO BE licensed under the GPL as well. Read the GPL, it's very
simple.
Read though here: http://www.gnu.org/licenses/gpl.txt

It seems to me that if the GNU licensed .NET provider is distributed unaltered
and in binary form, and reference to the license is made, it can be used BY a
commercial product without issue. Consider putting the provider into a
component install package, such as might be the case for a one-click
application. Install binaries only and the commercial application simply
utilitizes them.

It is very clear in the license that any modifications or extensions must be
distributed with source code and also under the GPL. However, USE by a
commercial application does NOT constitute a modification or extension.

As always, consult legal advice, as nobody [especially me] here is qualified
to offer it.
I don't know the MySql license through and through, but the GPL is
pretty clear: if you create a commercial application, you can still use
the GPL-ed software, as long as you GPL your own software as well.
Use? No. Modify or extend, yes.

--
Thomas T. Veldhouse
Key Fingerprint: D281 77A5 63EE 82C5 5E68 00E4 7868 0ADC 4EFB 39F0
Feb 7 '07 #11
Frank Rizzo <no**@none.netw rote:
Frans Bouma [C# MVP] wrote:
> I can tell you, Mysql's lawyers are very keen on this. So stay on the
safe side: either use a commercial provider or use another database.

They certainly are. I was contacted by one today.
How did they get hold of you? Seems no**@none.net wouldn't lead directly to
you ;-)

--
Thomas T. Veldhouse
Key Fingerprint: D281 77A5 63EE 82C5 5E68 00E4 7868 0ADC 4EFB 39F0
Feb 7 '07 #12
Thomas T. Veldhouse wrote:
Frans Bouma [C# MVP] <pe************ ******@xs4all.n lwrote:
http://www.mysql.com/company/contact/?topic=licensing

before assuming that using connector/net means that your software
has >to be GPL

err... it's very simple:
if you reference/link/use a GPL-ed piece of code in your own code,
your code HAS TO BE licensed under the GPL as well. Read the GPL,
it's very simple.

Read though here: http://www.gnu.org/licenses/gpl.txt
I have, you're wrong.
It seems to me that if the GNU licensed .NET provider is distributed
unaltered and in binary form, and reference to the license is made,
it can be used BY a commercial product without issue.
Nonsense, it's released under the GPL, which is simple: IF you use it,
your software has to be GPL-ed as well. IF they would have used the
LGPL, it would be different. Though that's not the case.

That they distribute it in binary form isn't important, they also
distribute it in sourcecode form if you want to, that's what GPL means
as well: if you distribute a GPL-ed licensed product, you have to
provide the sourcecode if asked.
Consider
putting the provider into a component install package, such as might
be the case for a one-click application. Install binaries only and
the commercial application simply utilitizes them.
that's what linking means in the license. You link to the binary
compiled form, and then the license also is in effect.
It is very clear in the license that any modifications or extensions
must be distributed with source code and also under the GPL.
However, USE by a commercial application does NOT constitute a
modification or extension.
WRONG. The GPL isn't different for this particular provider. What you
say here is WRONG, and can hurt people badly if they follow it. Sorry
if I correct you so harshly, but it's best that people who read your
reply know that what you've said is WRONG.
As always, consult legal advice, as nobody [especially me] here is
qualified to offer it.
Well, I've discussed this matter more than enough with MySql AG to
know what I'm talking about. It's even worse than you might imagine,
read on ->

We wanted to target Mysql in our o/r mapper. So we needed to build
against the Mysql provider. We didnt want to make our stuff GPL-ed so
we considered buying a license for the provider so we could compile our
code against the provider.

However, as we provide a middleware layer, our users develop software
with it, and thus also need a provider instance. If they opt for the
GPL-ed version, THEIR software still has to be GPL-ed. MySql AG told me
this without fuzzy words.

Because we said that might be a problem, they answered: "You can
become a VAR".

err... we're not a store to sell MySql stuff, we just provide support
for their database. As the commercial MySql provider license is
expensive (250+ euro per developer), we opted for a much cheaper
variant, the core-lab one.

It's beyond me why on earth a database vendor would ask money for a
connector to their database. Because: no connector, no database usage.
MySql is, to my knowledge, the only one who asks money for their
connector.

So my advice is always: use a different database: firebird, postgresql
etc.. Not only are these databases better than MySql, you also have a
truly free database at hand without hidden costs nor GPL mess.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Feb 8 '07 #13
Frans Bouma [C# MVP] wrote:
You can get away by not doing that IF you don't distribute your
application. However, as soon as you distribute your application to
whatever (that is: even another machine!), you ARE violating the
license.
With licensing issues, 'I think' is not enough. You have to be sure.
GPL is a distribution license, as many others.
This means that if developer A writes a piece of code and uses a
GPL-ed ADO.NET provider, and the software is never distributed by A to
whatever other system (that also includes a co-workers box, that's also
distribution), then A doesn't have to GPL his software. As soon as A
does distribute the code, he will have to license his own code as GPL,
that's the license he has to obey to to be able to USE the gpl-ed
ado.net provider.
in-house distribution is also distribution. Distribution from your
laptop to the server of your customer who uses it in-house is also
distribtion.
Wrong.

http://www.gnu.org/licenses/gpl-faq....alDistribution

Arne
Feb 9 '07 #14
Frans Bouma [C# MVP] wrote:
Well, I've discussed this matter more than enough with MySql AG to
know what I'm talking about. It's even worse than you might imagine,
read on ->

We wanted to target Mysql in our o/r mapper. So we needed to build
against the Mysql provider. We didnt want to make our stuff GPL-ed so
we considered buying a license for the provider so we could compile our
code against the provider.
The provider is GPL.

If you build against it, then it make sense to call it linking.

If you used a configuration file and Ixxxx all the way, then
I would not consider it linking.

I can not guarantee that MySQL's lawyers would not.
It's beyond me why on earth a database vendor would ask money for a
connector to their database. Because: no connector, no database usage.
MySql is, to my knowledge, the only one who asks money for their
connector.
So my advice is always: use a different database: firebird, postgresql
etc.. Not only are these databases better than MySql, you also have a
truly free database at hand without hidden costs nor GPL mess.
Libraries are usual LGPL for godo reasons.

I think MySQL should drop the dual license crap and bet on making
money on support like Redhat, JBoss etc..

But they decide the license for their code.

Arne
Feb 9 '07 #15

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
5860
by: Dave | last post by:
I have a MS sql 2000 db that needs to sync with a Mysql db. When a password is changed in the MS SQL table, I need to make sure that the same value is updated in the Mysql db. I dont have any control of the gui that is initiating this event. So, I was thinking a trigger might be an alternate route. I just dont know how to get the username and password values that have just been updated from MS sql to Mysql.
4
7459
by: The Bear | last post by:
Has anyone successfully used MySQL with C#? I'm having problems using the Update command Here is the code snippet. I am able to connect to the database. However when I try to update the database with the changes in the dataset I get the following error: An unhandled exception of type 'System.InvalidOperationException' occurred
5
10071
by: Steven Blair | last post by:
Hi, Trying to make a connection and getting the following error: "The 'MySQLProv' provider is not registered on the local machine." MySQl is installed and working, I also went to ODBC settings and created a new System Data Source for MySQl. (MySQL ODBC 3.51 Driver) Is it my responsibilty to set the provider name, or is this held somewhere
5
13567
by: Tim Bücker | last post by:
Hello. I am trying to get a connection to MySQL using OleDb but it seems that I am making something wrong. I´ve found this source in the net but it doesn´t work for me: System.Data.OleDb.OleDbConnection con; con=new System.Data.OleDb.OleDbConnection(""); con.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=test;"; con.Open();
4
1673
by: jaYPee | last post by:
I am new to mysql and wondering which one is the best for accessing mysql. I have read this article from mysql website: At present, one can access MySQL using the following 3 interfaces supported by MySQL. The ODBC.NET Solution - MyODBC Driver. Using MySQL Native .NET Providers. Using the OLEDB.NET Solution - MyOLDDB Provider
5
7379
by: asadikhan | last post by:
Hi, I am trying to configure my asp.net application to work with MySQL using Connector/NET and I wish to use connection pooling. What is the best way to do this? This is what I have so far: MySqlConnection myConnection; MySqlDataAdapter myDataAdapter;
2
10507
by: zMisc | last post by:
I am using VB.NET 1.1 and cannot connect to a MySQL (v5) database. I've done the following: 1) Create a DSN for MyODBC. 2) Connect using: Driver=MySQL ODBC 3.51 Driver; Server=localhost; Data Source=test; UID=test; PWD=pwd; OPTION=3 When I run my app, I get this error: An OLE DB Provider was not specified in
6
2185
by: webonomic | last post by:
"The connection name 'LocalSqlServer' was not found in the applications configuration or the connection string is empty." I get the error above. It tells me the error is in Line 120: <profile> Line 121: <providers> Line 122: <add name="AspNetSqlProfileProvider" connectionStringName="LocalSqlServer" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral,...
1
9833
by: Carmine [www.thetotalsite.it] | last post by:
Hi, I am using ASP.Net 2.0 with the MySQL Connector .Net 5.1.2.2. I added these lines to the web.config to make the connector.net able to handle the SqlConnection object (and so to bind it to a grinview/formview etc.): <DbProviderFactories> <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data,
0
10363
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10369
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10109
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9186
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7649
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6876
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5678
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3847
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3008
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.