Solved

How do i connect MySQL on Visual Studio

Posted on 2016-10-03
3
56 Views
Last Modified: 2016-10-11
Hi Experts ,

I want to connect to MySQL to the visual studio to my project and i tried with the following Video link as Guidance Youtube Video . But while installing the MySQL  connector and MySQL Installer from this link http://dev.mysql.com/downloads/installer/ . still am not able to see MySQL on my Server Explorer Data List . Please let me know am done anything wrong .
Capture.PNG
0
Comment
Question by:karthik80c
  • 2
3 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 41827040
Your link is for the MySQL Server install which does not include all the drivers for different programs.  You need the ODBC driver for it to show up on that list.  However, you probably want the .NET connector to use in your program and it won't show up on that list at all because it is not an ODBC driver.  http://dev.mysql.com/downloads/connector/
0
 

Author Comment

by:karthik80c
ID: 41829355
Hi Dave ,

So we need to install ODBC for that . Is that rite Dave
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 41829373
Not completely.  The ODBC driver is a generic driver.  The .NET driver is one that can be compiled into your .NET application.  The ODBC driver will show up in the Data Source window where it can be used by any program that uses ODBC.  The .NET driver will not show up there because is not a stand-alone driver but one that is compiled into your program.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

920 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now