[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Linking MySQL datasource to Visual Studio 2012

Posted on 2013-01-21
11
Medium Priority
?
2,209 Views
Last Modified: 2013-01-29
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?
0
Comment
Question by:flynny
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 18

Expert Comment

by:dj_alik
ID: 38800884
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
 

Author Comment

by:flynny
ID: 38801050
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
 
LVL 18

Expert Comment

by:dj_alik
ID: 38801082
0
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

 

Author Comment

by:flynny
ID: 38812072
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
 
LVL 18

Expert Comment

by:dj_alik
ID: 38813001
i think the problem exists because of 64 bit
0
 

Author Comment

by:flynny
ID: 38814216
OK, so what about using the older 64bit driver?

This did not work either
0
 
LVL 18

Expert Comment

by:dj_alik
ID: 38814456
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
 

Author Comment

by:flynny
ID: 38816026
Ok I saw this but assumed because we are now on 6.6.4 it should be added?
0
 

Author Comment

by:flynny
ID: 38816032
this link suggests it has compatability

http://forums.mysql.com/read.php?47,571576,571576
0
 

Accepted Solution

by:
flynny earned 0 total points
ID: 38816182
Hi,

I have managed to solve the issue.

Downgrading to the 6.5.5 driver allows the connection to appear.
0
 

Author Closing Comment

by:flynny
ID: 38830351
I have managed to correct the issue myself
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

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

In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
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 Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

656 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