Hey,
I am creating a asp.net web page and need to connect it to a mysql database. I have downloaded both the .net connector and the odbc connector but neither of them seem to be working.

Does anyone know a simple example of connecting a asp.net page to a mysql database using c#??

Thanks

.NET
Driver={mySQL};Server=myServerAddress;Port=3306;Op tion=131072;Stmt=; Database=myDataBase; User=myUsername;Password=myPassword;

ODBC:
Driver={MySQL ODBC 5.1 Driver};Server=myServerAddress;Port=3306;Database= myDataBase;User=myUsername; Password=myPassword;Option=3;

@alexsqlforums:
i know what to do from inside the pages.but can you please tell me how to connect the database( i mean from server explorer in visual studio 2005). i cannot find the mysql server in the system dsn even after installing the connector.i am using mysql odbc connector.
please help me out.