Hi, I just started to get interested in ASP.NET (C#) and I want to know the simplest way to connect to a mySQL database called "test" and display a list of names from a table called "names".

Thanks for the help.

 ODBC 2.50 Local database:

"Driver={mySQL};Server=localhost;Option=16834;Data base=mydatabase;"

 ODBC 2.50 Remote database:

"Driver={mySQL};Server=data.domain.com;Port=3306;O ption=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"

 ODBC 3.51 Local database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword;OPTION=3;"

 ODBC 3.51 Remote database:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=data.domain.com;PORT=3306;DATABASE= myDatabase;USER=myUsername;PASSWORD=myPassword;OPT ION=3;"

 OLE DB, OleDbConnection (.NET)
 Standard:

"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

Gokulan Ethiraj

Could you possibly give me an example of code that shows the use of
OLE DB, OleDbConnection (.NET)
 Standard:

"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

Thanks