Visual Web Developer 2010 Express - connect to MySQL

  • Thread starter Thread starter Alan T
  • Start date Start date
A

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.
 
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.
Click to expand...

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 !
 
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.
Click to expand...

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)
 
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)
Click to expand...

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
 
Back
Top