-
Sep 14th, 2018, 01:59 AM
#1
Thread Starter
Addicted Member
ODBC, ADODB or OLEDB
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
-
Sep 14th, 2018, 07:01 AM
#2
-
Sep 14th, 2018, 08:12 AM
#3
Thread Starter
Addicted Member
Re: ODBC, ADODB or OLEDB
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
-
Sep 14th, 2018, 04:53 PM
#4
Re: ODBC, ADODB or OLEDB
You have to use the mysql connector to connect to mysql
Maybe this will help
https://dev.mysql.com/doc/connector-...asp-roles.html
-
Sep 14th, 2018, 05:49 PM
#5
Re: ODBC, ADODB or OLEDB
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
-
Sep 15th, 2018, 09:55 AM
#6
Thread Starter
Addicted Member
Re: ODBC, ADODB or OLEDB
Thank you so much si_the_geek
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|