Click here to Skip to main content
11,718,589 members (84,592 online)
Rate this: bad
good
Please Sign up or sign in to vote.
Hi all

Can u please tell me how do i connect Mysql database with visual studio 2010 express edition..

Thank you
Posted 18-Dec-12 18:20pm
Code-Hunt7.1K
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

MySQL Connector/NET will not work in the Express Version of Microsoft Studio due to limitations within the express products. In order to use Data sources based in server architecture Non-"Express" versions must be used. Connectivity to even Microsoft's Own MSSQL will not work, aside from local limited "Compact" or "Express" versions.
This is a limitation of the Express editions of Visual Studio. They offer very limited designer support for databases. For example, you can't connect to a standard SQL Server database using the Visual Studio designers using an Express edition, only a "user instance" database.

You can still work with MySQL databases via code using the .NET Framework.

While I'm guessing this isn't the answer you were hoping for, I hope that knowing that you're running into a limitation of the Express edition helps save you some time searching around for the cause of the behavior.
Thanks...
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

I used the Mysql connector 6.6.4 from the below link

http://dev.mysql.com/downloads/connector/net/[^]

It's working well now..

Thank you all
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 651
1 OriginalGriff 210
2 F-ES Sitecore 185
3 Jochen Arndt 160
4 Maciej Los 130
0 OriginalGriff 535
1 Maciej Los 529
2 Richard MacCutchan 440
3 CHill60 415
4 F-ES Sitecore 415


Advertise | Privacy | Mobile
Web04 | 2.8.150901.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100