Click here to Skip to main content
15,885,216 members
Please Sign up or sign in to vote.
4.00/5 (1 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

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...
 
Share this answer
 
 
Share this answer
 
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
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900