Linking MySQL datasource to Visual Studio 2012

Hi All,

A simple question, but I can't seem to find anything useful on google.

I am struggling to create a connection to a MySQL db using visual studio web express 2012.


I found one answer on yahoo saying it was not to be added until 5.5.6.

Now I'm running MySQL server 5.5

and have the Net connector 6.1.6 installed on my machine.

I have added the reference to the MySQL.Data to the site, but when I go to

Database Explorer -> New Connection -> Select other data source and look at the dropdown MySQL is not appearing?

ANything I am doing wrong here?
flynnyAsked:
Who is Participating?
 
flynnyConnect With a Mentor Author Commented:
Hi,

I have managed to solve the issue.

Downgrading to the 6.5.5 driver allows the connection to appear.
0
 
dj_alikCommented:
Can you try to  update your .net connector
to  Connector/Net 6.6.4:
http://dev.mysql.com/downloads/connector/net/

Connector/Net 6.6.4 must be work on 32 bit... machine
0
 
flynnyAuthor Commented:
Ok,

I have removed the old version and installed the new 6.6.4 version onto my machine.

Now the only issue is I am running on a 64bit machine.

Will this be anissue?

The item in the dropdown is still not appearing. Do I need to refresh in visual studio?
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
dj_alikCommented:
0
 
flynnyAuthor Commented:
Hi,

Many thanks for the reply.

I have done the following but still it is not appearing in the dropdown selector?

1. Rebooted Machine
2. Uninstalled the MySQL 6.6.4 Net Driver
3. Reinstalled the driver.
4. Launched Visual Studio 2012 Express and tried to connect to the db.

I have attached a screenshot of the dropdown.

Is there anything else I can try please?
screenshot.jpg
0
 
dj_alikCommented:
i think the problem exists because of 64 bit
0
 
flynnyAuthor Commented:
OK, so what about using the older 64bit driver?

This did not work either
0
 
dj_alikCommented:
sorry
see the answer
mySQL DataSource on Visual Studio 2012
We'll be adding support for VS 2012 in Connector/NET 6.5.5 and later 6.6.x version
http://stackoverflow.com/questions/12684047/mysql-datasource-on-visual-studio-2012
0
 
flynnyAuthor Commented:
Ok I saw this but assumed because we are now on 6.6.4 it should be added?
0
 
flynnyAuthor Commented:
this link suggests it has compatability

http://forums.mysql.com/read.php?47,571576,571576
0
 
flynnyAuthor Commented:
I have managed to correct the issue myself
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.

All Courses

From novice to tech pro — start learning today.