VB6 and MySQL Login

Using the ADODC1 or the MSRDC1 is not the best idea as you should use ADO, RDO, or DAO ODBC Direct with an ODBC DSN. However, with a visit to http://www.connectionstrings.com, you can use a DNS Less connection string with ADO (preferred technology by most people). Now, if you are shaky on using ADO, you can easily find a tutorial on ADO by using your friends (yahoo, google, ask, answers, bing) and searching for vb6 ado tutorial...

Good Luck

Right, I think I've connected to the database using the

ConnectString = "DRIVER={MySQL ODBC 3.51 Driver};" & _
                "SERVER=" & strServerName & _
                ";DATABASE=" & strDatabaseName & ";" & _
                "USER=" & strUserName & _
                ";PASSWORD=" & strPassword & _
                ";OPTION=3;"

function, but how do I know if it has connected correctly? is there some way to make a popup appear to show a successful login?

Also, how do I now excute SQL commands without using the MSRDC control?

Well once you try and connet, if the connection fails, you should get an error, if you do not get an error, then presumably, you have a good connection. Also, you should be able to test the connectionstate or whatever the property is to see if it is adstateopen/closed or whatever. Press F1 to see the help files on the subjects and the correct parameters to test against (see example if they have one)...

Good Luck

imedeately after you have opened your connection it should give you an error that the connection has failed and if does not give you an error that means that the connection was successfull that if you dont have any error hanlers that may suppress the errors or you could display a message with the state of the connection