Connecting to a remote MySQL server using ADO

Is there a way for me to connect to a remote MySQL server using the ADO technology? If there is, how?

Using Connector/ODBC, you can access MySQL like you would any ODBC database using ADO. More information can be found at http://www.vbmysql.com.

For More Information

• Dozens more answers to tough MySQL questions from Mike Hillyer are available here.
• The Best MySQL Web Links: tips, tutorials, scripts, and more.
• Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, MySQL, object-oriented and data warehousing gurus are waiting to answer your toughest questions.