473,796 Members | 2,680 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 #1
14 4510
Uli
I would try this:

http://www.mysql.de/products/connector/

Feb 2 '07 #2
Frank Rizzo wrote:
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)?
MySql's own: it's GPL-ed (free) though you then also have to GPL your
own software. OR you have to pay 250$+ per developer for a commercial
license.

Core Lab's: it's commercial, but very inexpensive. They had their
problems in the past but it works fairly well.

Unless you're willing to making your own code GPL licensed, i'd go for
core lab's.

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 2 '07 #3
Please contact MySQL at:

http://www.mysql.com/company/contact/?topic=licensing

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

Please note that if you are using MySQL in a "commercial product" then you
need a commercial license anyway.

However I *think* that they mean if you are distributing your product,
rather than using it in-house. If you are just developing an in-house
system using MySQL and connector/.net I don't *think* you need a commercial
license or to publish your code.

If you are producing an in-house product and you are not distributing it,
the GPL places no burden on you whatsoever (i.e. you do not have to make
your code available). The GPL only insists you make your source code
available if you distribute your product (which to most of us mean, "Sell
it" in all practical terms) - and if this were the case, you'd need a
commercial license for MySQL anyway.

Please check this with MySQL. Unless one of MySQL AB's lawyers is posting
here, none of us is qualified to give you an answer vis-a-vis licensing of
MySQL or connector/.net

HTH
Peter
"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n lwrote in message
news:xn******** *******@news.mi crosoft.com...
Frank Rizzo wrote:
>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)?

MySql's own: it's GPL-ed (free) though you then also have to GPL your
own software. OR you have to pay 250$+ per developer for a commercial
license.

Core Lab's: it's commercial, but very inexpensive. They had their
problems in the past but it works fairly well.

Unless you're willing to making your own code GPL licensed, i'd go for
core lab's.

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 2 '07 #4
For a supposedly free database, they are certainly very expensive. I
understand charging for the database, but why charge for the driver?

Peter Bradley wrote:
Please contact MySQL at:

http://www.mysql.com/company/contact/?topic=licensing

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

Please note that if you are using MySQL in a "commercial product" then you
need a commercial license anyway.

However I *think* that they mean if you are distributing your product,
rather than using it in-house. If you are just developing an in-house
system using MySQL and connector/.net I don't *think* you need a commercial
license or to publish your code.

If you are producing an in-house product and you are not distributing it,
the GPL places no burden on you whatsoever (i.e. you do not have to make
your code available). The GPL only insists you make your source code
available if you distribute your product (which to most of us mean, "Sell
it" in all practical terms) - and if this were the case, you'd need a
commercial license for MySQL anyway.

Please check this with MySQL. Unless one of MySQL AB's lawyers is posting
here, none of us is qualified to give you an answer vis-a-vis licensing of
MySQL or connector/.net

HTH
Peter
"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n lwrote in message
news:xn******** *******@news.mi crosoft.com...
>Frank Rizzo wrote:
>>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)?
MySql's own: it's GPL-ed (free) though you then also have to GPL your
own software. OR you have to pay 250$+ per developer for a commercial
license.

Core Lab's: it's commercial, but very inexpensive. They had their
problems in the past but it works fairly well.

Unless you're willing to making your own code GPL licensed, i'd go for
core lab's.

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 2 '07 #5
Peter Bradley wrote:
Please contact MySQL at:

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.

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.
Please note that if you are using MySQL in a "commercial product"
then you need a commercial license anyway.
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.
However I think that they mean if you are distributing your product,
rather than using it in-house. If you are just developing an
in-house system using MySQL and connector/.net I don't think you need
a commercial license or to publish your code.
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.
If you are producing an in-house product and you are not distributing
it, the GPL places no burden on you whatsoever (i.e. you do not have
to make your code available). The GPL only insists you make your
source code available if you distribute your product (which to most
of us mean, "Sell it" in all practical terms) - and if this were the
case, you'd need a commercial license for MySQL anyway.
in-house distribution is also distribution. Distribution from your
laptop to the server of your customer who uses it in-house is also
distribtion.
Please check this with MySQL. Unless one of MySQL AB's lawyers is
posting here, none of us is qualified to give you an answer vis-a-vis
licensing of MySQL or connector/.net
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.

FB
>
HTH
Peter
"Frans Bouma [C# MVP]" <pe************ ******@xs4all.n lwrote in
message news:xn******** *******@news.mi crosoft.com...
Frank Rizzo wrote:
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)?
MySql's own: it's GPL-ed (free) though you then also have to GPL
your own software. OR you have to pay 250$+ per developer for a
commercial license.

Core Lab's: it's commercial, but very inexpensive. They had their
problems in the past but it works fairly well.

Unless you're willing to making your own code GPL licensed, i'd go
for core lab's.

--
------------------------------------------------------------------------
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 3 '07 #6
Peter Bradley wrote:
Please contact MySQL at:

http://www.mysql.com/company/contact/?topic=licensing

before assuming that using connector/net means that your software has to be
GPL
The GPL is very clear: linking to GPL makes everything GPL.

The question is: what is linking.

From a common sense perspective I would say that use of
MySQL classes in the code is linking and use of a configuration
file, reflection and interfaces is not linking.

The last one I would ask about if that is true is MySQL.
Please note that if you are using MySQL in a "commercial product" then you
need a commercial license anyway.
Wrong.

GPL does not care about what you use the software for.
However I *think* that they mean if you are distributing your product,
rather than using it in-house. If you are just developing an in-house
system using MySQL and connector/.net I don't *think* you need a commercial
license or to publish your code.
All the GPL requirements only applies to distributing.
Please check this with MySQL. Unless one of MySQL AB's lawyers is posting
here, none of us is qualified to give you an answer vis-a-vis licensing of
MySQL or connector/.net
I would suggest checking with ones own lawyer.

MySQL has a rather direct interest in telling people to pay.

Arne
Feb 3 '07 #7
Hi Frank,

Most of the commerial database drivers or components won't be free of
charge. Anyway, you can still look for some over open source sites such as
sourceforge:

#ADO.Net drivers for MySql and PostgreSql
http://sourceforge.net/projects/mysqlnet/

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Feb 5 '07 #8
Steven Cheng[MSFT] wrote:
Most of the commerial database drivers or components won't be free of
charge. Anyway, you can still look for some over open source sites such as
sourceforge:

#ADO.Net drivers for MySql and PostgreSql
http://sourceforge.net/projects/mysqlnet/
You know that is the code MySQL Connector for .NET
was based on and that this version has not been
updated since MySQL tookover ByteFX in 2004 ?

Arne
Feb 6 '07 #9
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.

Regards
Feb 6 '07 #10

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
1671
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
10506
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
2181
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
9830
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
9685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10465
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10242
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
10200
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,...
1
7558
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
6800
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
5453
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5582
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4127
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.