Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003

    Unanswered: Connecting through DAO in VB to MySQL

    I have an activeX dll that is used for connecting to an Access DB. I need to update it to connect to a MySQL DB preferably with a DSN Less connection. It is using DAO right now to connect and I don't want to have to migrate it to ADO. Can someone give me some examples of how to connect to MySQL? Here is the code it is using now:

    Dim oDB As Database
    Dim oRecs As Recordset

    Set oDB = OpenDatabase(szDb)

    Set GetRecords = oDB.OpenRecordset(szQuery)

  2. #2
    Join Date
    Jun 2002

    You can find a dll (MyVbQl.dll) in the link below

    It will help to resolve your MySql Vb connection....and it is free!!

    Hope in this help

    Gianni Spano

Posting Permissions

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