In pratica scordavo

Adodc1.CommandType = adCmdUnknown


quindi per faer una query con Myodbc da vb in MySql

strgSQL = "SELECT * FROM tablename"
Adodc1.CommandType = adCmdUnknown
Adodc1.RecordSource = strgSQL

Adodc1.Refresh

Grazie lo stesso