It seems my VB app is impatient insofaras it won't wait for MySQL to return a recordset result from a query. I have confirmed this by executing the same query directly in MySQL (using MySQL Control Center aka MySQLCC) and getting a result of several rows.

Is there any way to force VB to wait for MySQL to finish?

Here is how I connect:
mconCM.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};" & _
"Server=" & ComputerName & ";" & _
"Port=3306;" & _
"Option=0;" & _
"Stmt=;" & _
"Database=cm;" & _
"Uid=" & UserName & ";" & _
"Pwd=password"
mconCM.ConnectionTimeout = 3
mconCM.CursorLocation = adUseClient
mconCM.Open

And here is how I execute the query (strSQL is devised in another subroutine and has been proven valid):
With cmdSQL
.ActiveConnection = mconCM
.CommandTimeout = 30
.CommandType = adCmdText
.CommandText = strSQL
End With
Set rstRecordset = cmdSQL.Execute()


Thanks to anyone who helps!