ODBC, ADODB or OLEDB

[Peekay]

I need to write an ASP or ASP.NET file to update MySQL database, and I need some guidance on the following if you please:

1. Should I use ASP or ASP.NET (.asp or .aspx) ?
2, Which system data connection should I use - ODBC or OLEDB. I see ADODB is not available on my .NET framework under System.Data.

Thanks
PK

[DataMiser]

ASP.Net with ADO.Net

[Peekay]

Thanks DataMiser.

How would I Set such a connection:

1. There is no ADODB.ADODBConnection in the System.Data framework, like ODBC and OLEDB, or is it not necessary to have that.
2. How would a connection string for ADO look like?
3. Do I need a driver for MySQL for that?

PK

[DataMiser]

You have to use the mysql connector to connect to mysql

Maybe this will help
https://dev.mysql.com/doc/connector-...asp-roles.html

[si_the_geek]

In terms of code I recommend checking the VB.Net section of our Database Development FAQs/Tutorials (at the top of the Database Development forum), particularly Retrieving and Saving Data in Databases

[Peekay]

Thank you so much si_the_geek