dcsimg
Results 1 to 6 of 6

Thread: ODBC, ADODB or OLEDB

  1. #1

    Thread Starter
    Addicted Member Peekay's Avatar
    Join Date
    Sep 2006
    Location
    Witbank, South Africa
    Posts
    134

    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

  2. #2
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    12,567

    Re: ODBC, ADODB or OLEDB

    ASP.Net with ADO.Net

  3. #3

    Thread Starter
    Addicted Member Peekay's Avatar
    Join Date
    Sep 2006
    Location
    Witbank, South Africa
    Posts
    134

    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

  4. #4
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    12,567

    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

  5. #5
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    40,345

    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

  6. #6

    Thread Starter
    Addicted Member Peekay's Avatar
    Join Date
    Sep 2006
    Location
    Witbank, South Africa
    Posts
    134

    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
  •  



Featured


Click Here to Expand Forum to Full Width