Click here to Skip to main content
13,149,731 members (53,907 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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
Rate this: bad
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.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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

Solution 3

I used the Mysql connector 6.6.4 from the below link[^]

It's working well now..

Thank you all

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.170924.2 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2017
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