[ruteckycs]

Ok, I have about 10 days with nothing to do so I was wanting to work on a personal project. Im constrained to using VB6 for the work. It has been quite some time since I used VB6 and I was never quite an expert in it to start with so please bare with me.

I would like to use VB6 to connect to a MYSQL database that is running on my website (GoDaddy) but I have no idea how to use VB6 to connect to anything online I will also need to run quarry's.

In short Im looking for the VB6 equivalent of this PHP code:

PHP Code:

mysql_connect("remotehost", "admin", "password");
mysql_select_db("databasename"); 

and instructions to run a quarry.

Thanks in advance for any insight.

[Dwagar]

I did this once before when trying to move away from ms access but then later decided to go with ms sql. Do you have the mySQL connector installed? I am pretty sure I needed that from MySQL :: MySQL Downloads

I also ran into another forum at Connect to mySQL Database with Visual Basic - Access World Forums that may help you out.

Wish you best of luck