Visual Web Developer 2010 Express - connect to MySQL

[Alan T]

Hi,
I cannot find VWD newsgroup so I post the message here.

Just downloaded VWD 2010, would like to know the steps to connect to MySQL
5.
I have downloaded MySQL ODBC driver and added into System -> DSN already.

 

[Mr. Arnold]

Hi,
I cannot find VWD newsgroup so I post the message here.

Just downloaded VWD 2010, would like to know the steps to connect to MySQL
5.
I have downloaded MySQL ODBC driver and added into System -> DSN already.

<http://www.google.com/#hl=en&source..._tge8lqCwCgAAAKoEBU_QVG0K&fp=f11974faf5e3db50>

 

[Arne Vajhøj]

I cannot find VWD newsgroup so I post the message here.

Just downloaded VWD 2010, would like to know the steps to connect to MySQL
5.
I have downloaded MySQL ODBC driver and added into System -> DSN already.

Don't use the ODBC driver.

Use the MySQL connector for .NET.

You connect to MySQL similar to how you connect to any database
using ADO.NET.

Arne

PS: Also be sure to read the license for MySQL ODBC driver
and ADO.NET provider !

 

[Man T]

Don't use the ODBC driver.

Use the MySQL connector for .NET.

You connect to MySQL similar to how you connect to any database
using ADO.NET.

Hi,

I just created the MySQL connection from Database explorer for MySQL.
Sorry if this is too elementary:
I want to display the field values of a table into a dropdown list, eg. name
of employee for selection,
what steps I need to do? This will be done in asp.net (VWD 2010 Express
edition)

 

[Arne Vajhøj]

I just created the MySQL connection from Database explorer for MySQL.
Sorry if this is too elementary:
I want to display the field values of a table into a dropdown list, eg. name
of employee for selection,
what steps I need to do? This will be done in asp.net (VWD 2010 Express
edition)

More or less like for any other database.

The main difference being that database specific classname will
start with MySql and not Sql or SqlCe or Oracle or ....

Arne