oConn.Open "Driver={mySQL};" & _
"Server=db1.database.com;" & _
"Port=3306;" & _
"Option=131072;" & _
"Stmt=;" & _
"Database=mydb;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

Some helpful links:
http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm
http://www.connectionstrings.com/
http://www.simongibson.com/intranet/adoodbc/adoodbc.html