VB and MySQL

[Matt]

How can I make a connection to a mysql database in my vb program, I am using VB6. I saw how to do it very simply using vb.net, but not vb6. What I am trying to do with this project is to create a login screen to prevent piracy. It will connect to the MySQL database, then lookup the username the person gives. Then if there is a row with that username it will chack the password, and then it will check the computer name. I think I can do the MySQL queries, but getting the connection is where I am stuck.

[kheston]

Matt,<p>VB6 knows very well how to connect to ODBC sources. Go to the MySql site and download the ODBC driver (it's free), load it per the instructions and use an ADO object to connect.<p>Good luck!