How to connect MySQL5 with VB6.0 by coding?

i want to 开发者_如何学编程connect my Visual Basic 6.0 Application with MySQL5 database by coding not by DSN. what will be the connection string to connect them? If anyone help me to do this, it would be greatly appreciated.

Thanks,

Yugal

This should work:

ConnStr = "DRIVER={MySQL ODBC 5.1 Driver};" _
    & "SERVER=myserver;" _
    & "DATABASE=mydatabase;" _
    & "UID=myuserid;" _
    & "PWD=mypassword;" _
    & "OPTION=1"