Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2006

    Unanswered: need help.. new to database / MySQL work.

    Working on a project for college and I need a database connection.

    Running MySQL 4.1

    I understand databases, and I understand (a fair level) VB. But even after trying to read up from a dozen differnet google searches.. I don't understand how to combine the two... hell I'm probably worse off then I was to begin with.

    From the looks of things I may need to download some drivers or something? Well.. If someone could help walk me though setting up a connection, and managing data handling.. I'd greatly apreciate it.

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Go to MySQL's site & download their latest ODBC drivers for their v4.1 database & install the driver.

    Then, you'll need to create a connection string for your app. Check out Carl Prothman's Connection String Site.

    Finally, using ADO, declare and instanciate the ADO objects you'll need (connection, recordset, etc.) Ref this ADO Tutorial - it's a good starting point.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts