[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Net platform connection for MySQL

Posted on 2012-09-08
6
Medium Priority
?
649 Views
Last Modified: 2012-09-08
I am wondering if there is a special Net connection for Mysql which can be used as a class in C# or ASP.Net.

I mean a connection tailored for MySQL and not a generic one.
Ideally I would also like a tutorial that shows how to install such a connection.


Thanks
0
Comment
Question by:adamtrask
  • 3
  • 3
6 Comments
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 38379702
Here are the MySQL connectors: http://www.mysql.com/products/connector/   A number of people have found the ODBC connector easier to use.
0
 

Author Comment

by:adamtrask
ID: 38379706
Thank you Dave,
Does it need to be installed in a special way?
I will also assume that once it's installed I treat it like a class,  the same way I would use ODBC, correct?
0
 
LVL 84

Expert Comment

by:Dave Baldwin
ID: 38379727
You need to download the .NET code and look at the directions.  The ZIP file contains 811 files of source code, images, and other stuff.  It becomes part of your project I believe.

ODBC connectors (drivers) must be installed so they will show up in Windows Data Sources.
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 

Author Comment

by:adamtrask
ID: 38380081
I downloaded the Net connection and it only had an installation file - no zip.
 I ran it nonetheless but have no idea what driver it placed in my Visual Studio 2010.

Visual Studio 2010 comes with ODBC already installed, and I was expecting a different driver for MYSQL, one tailored for it , the same way SQLClient is optimized for MS SQL Server.

adam
0
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 total points
ID: 38380125
Connector/Net 6.5.4 http://www.mysql.com/downloads/connector/net/ comes in two Windows ZIP Archives and one MSI.  Connector/ODBC 5.1.11 http://www.mysql.com/downloads/connector/odbc/ comes in several different versions for Windows and is the specific ODBC driver for MySQL.  All ODBC connections require application specific drivers to go with them.  SQL Native Client provides the ODBC for MS SQL.  Microsoft Office supplies the drives for Excel and Access.  There are other drivers for Oracle and PostgreSQL.
0
 

Author Closing Comment

by:adamtrask
ID: 38380227
Thank you Dave for the explanation.
I was under the impression that ODBC was a class that provided all the required routines for connection to MySql.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question