If not, have you restarted visual studio since you installed the mysql connector? If you have I am not sure I will be able to help you anymore since I am unable to install the connector to toy with the settings. You might want to hit up mysql's forum to
receive better advice than I am capable of giving.
lordplazikov...
Member
195 Points
319 Posts
MySql + ASP.NET
Jun 24, 2011 06:22 PM|LINK
Hi guys,
I want to program a website with ASP.net and a MySql DB.
Now I have installed the Mysql Workbench and the MySql connector for .net.
When I want to make a new connection with a database there is no datasource MySql.
I'm using the Microsoft Visual Developper 2010 express, is that a problem or have I did something else wrong?
thanks !
bouwob2
Participant
1099 Points
237 Posts
Re: MySql + ASP.NET
Jun 24, 2011 06:24 PM|LINK
Have you added the MySql.Data.dll assembly as a reference to your project?
lordplazikov...
Member
195 Points
319 Posts
Re: MySql + ASP.NET
Jun 24, 2011 06:36 PM|LINK
and how should I do that?
I'm now working with the wizard, my version of Visual Studio has an integrated Databaseview.
bouwob2
Participant
1099 Points
237 Posts
Re: MySql + ASP.NET
Jun 24, 2011 06:40 PM|LINK
Right click on the folder named refrences and add a reference. then find the dlll and add it into the project.
Yopu may want to read through this page for some starter steps
http://www.christianasp.net/usingmysql50withaspnet-part1.aspx
lordplazikov...
Member
195 Points
319 Posts
Re: MySql + ASP.NET
Jun 24, 2011 06:48 PM|LINK
The dll isn't in te reference list.
bouwob2
Participant
1099 Points
237 Posts
Re: MySql + ASP.NET
Jun 24, 2011 06:51 PM|LINK
You have to browse to it.
lordplazikov...
Member
195 Points
319 Posts
Re: MySql + ASP.NET
Jun 24, 2011 06:56 PM|LINK
Ok thanks I've found it, but still no MySql datasource in the wizardlist.
Thanks that you're helping me.
bouwob2
Participant
1099 Points
237 Posts
Re: MySql + ASP.NET
Jun 24, 2011 07:17 PM|LINK
Have you walked through this howto?
http://dev.mysql.com/doc/refman/5.0/en/connector-net-visual-studio-making-a-connection.html
I believe you have and are not seeing MySQL......
If not, have you restarted visual studio since you installed the mysql connector? If you have I am not sure I will be able to help you anymore since I am unable to install the connector to toy with the settings. You might want to hit up mysql's forum to receive better advice than I am capable of giving.
evanorue
Contributor
4839 Points
1306 Posts
Re: MySql + ASP.NET
Jun 25, 2011 02:09 AM|LINK
You only need to create new database if you don't see the wizard that allow you to choose that only find it in tools.
when you create the database you can populate tables. stored procedures, etc, and then you can export that database.
But i think VS 2008 or 2010 have MySql so only need to find it.
tell me if you can fix your problem, I'll help you if not!
good Luck!
evanorue@gmail.com |Blog
lordplazikov...
Member
195 Points
319 Posts
Re: MySql + ASP.NET
Jun 25, 2011 10:29 AM|LINK
I've found the solution.
I've uninstalled Visual developper 2010 express and MySQL Workbench and the connector.
Then I installed Visual Studio 2010 proffessional and the workbench and connector.
And now MySql Database is in the wizardlist.
Thanks all for helping me finding a solution.