Results 1 to 3 of 3

Thread: ADO Connection to a MySQL DB

  1. Nov 15th, 2001, 11:39 AM #1
    Merlin
    Merlin is offline

    Thread Starter
    Addicted Member Merlin's Avatar
    Join Date
    Dec 2000
    Location
    Eau Claire, WI
    Posts
    233

    ADO Connection to a MySQL DB

    I need a connection string for ADO to a MySQL database. This is what I pulled from another post but I get the No Default Driver Specified Error. I am new to the world of MySQL, I just need to connect and grab the contents of one table to compare to another in SQL Server 7.0. I have NO CLUE what the connection string should be...

    VB Code:
    1. Public Const gsConnection As String = "driver={MySQL};server=blah.blah.com;uid=uid;pwd=pwd;database=phpshop"

    (Posted in Database Q&A as well)
    poooof

    Wizard Since 1997
    SQL Server 7.0:2K, Oracle, VB 6.0 EE, VBScript, C/C++, COBOL, RPG ILE, HTML, XML, Perl
    Reply With Quote Reply With Quote
  2. Nov 15th, 2001, 03:29 PM #2
    d4v3
    d4v3 is offline
    Lively Member d4v3's Avatar
    Join Date
    Nov 2001
    Location
    Leicester, UK
    Posts
    82
    not sure if u can use ADO with MySQL, ivbe never heard of it before!
    Reply With Quote Reply With Quote
  3. Nov 15th, 2001, 03:49 PM #3
    JoshT
    JoshT is offline
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    Download and install MyODBC (Win32 version), and you can use that to connect to a local or remote MySQL via ADO. I had no problems running MySQL on a Linux box and connecting to it via VB/ADO on a Windows box (unfortunately I've misplaced my code...).
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    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