Results 1 to 5 of 5

Thread: ODBC or Oledb

  1. Mar 16th, 2006, 10:54 PM #1
    barianto
    barianto is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2005
    Posts
    145

    ODBC or Oledb

    Hi guys,

    Please give me some recommendation
    which is best connection method to connect to MySql using VB & ADO?
    Is it ODBC or OledDB Provider?

    need some light over here
    Last edited by barianto; Mar 16th, 2006 at 11:07 PM.
    Reply With Quote Reply With Quote
  2. Mar 16th, 2006, 11:34 PM #2
    d3gerald
    d3gerald is offline
    Frenzied Member d3gerald's Avatar
    Join Date
    Jan 2006
    Posts
    1,348

    Re: ODBC or Oledb

    anyone can correct me if i'm wrong but i think the best way to do a connection nowadays is oledb, i just dont know whats best for MySQL
    On error goto Trap

    Trap:
    in case of emergency, drop the case...
    ****************************************
    If this post has been resolved. Please mark it as "Resolved" by going through the "Thread Tools" above and clicking on the "Mark Thread Resolved " option.     if a post is helpful to you, Please Rate it by clicking on the Rate link right below the avatar
    Reply With Quote Reply With Quote
  3. Mar 16th, 2006, 11:38 PM #3
    KGComputers
    KGComputers is offline
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,024

    Re: ODBC or Oledb

    Hi,,,,
    If your mysql database is good for one PC only then OLEDB would be fine....If your mysql database is located on a remote server, ODBC(data sources) would be an advantage...

    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: Personal | Programming
    Projects: GitHub | jsFiddle
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...
    Reply With Quote Reply With Quote
  4. Mar 17th, 2006, 12:19 AM #4
    barianto
    barianto is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2005
    Posts
    145

    Re: ODBC or Oledb

    please explain what advantage using ODBC on remote access
    Last edited by barianto; Mar 17th, 2006 at 12:25 AM.
    Reply With Quote Reply With Quote
  6. Mar 20th, 2006, 05:22 AM #5
    dee-u
    dee-u is offline
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Pinas
    Posts
    11,127

    Re: ODBC or Oledb

    I'm not sure but is there an OleDb Provider for MySql?
    Regards,

    ™

    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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