Click here to Skip to main content
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 19:20pm
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 OriginalGriff 240
1 Kamal Rocks 184
2 BillWoodruff 173
3 PIEBALDconsult 160
4 CPallini 155
0 OriginalGriff 5,695
1 DamithSL 4,506
2 Maciej Los 4,007
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,180


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2014
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