• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 659
  • Last Modified:

Net platform connection for MySQL

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
adamtrask
Asked:
adamtrask
  • 3
  • 3
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
Here are the MySQL connectors: http://www.mysql.com/products/connector/   A number of people have found the ODBC connector easier to use.
0
 
adamtraskAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
adamtraskAuthor Commented:
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
 
Dave BaldwinFixer of ProblemsCommented:
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
 
adamtraskAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now