下面为您介绍的方法是用于实现ADO连接MYSQL,如果您对连接MYSQL的技术相关内容感兴趣,随我看来。,相信对您掌握连接MYSQL方面的知识会有所帮助。
* When using "ODBC 3.51 LOCAL database": 'DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword;OPTION=3;' * When using "ODBC 3.51 REMOTE database": 'DRIVER={MySQL ODBC 3.51 Driver}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; USER=myUsername; PASSWORD=myPassword; OPTION=3;' * When using "ODBC 5.0 LOCAL database": 'DRIVER={MySQL Connector/ODBC v5}; SERVER=localhost; DATABASE=myDatabase; UID=myUsername; PASSWORD=myPassword;OPTION=3;' * When using "ODBC 5.0 REMOTE database": 'DRIVER={MySQL Connector/ODBC v5}; SERVER=data.domain.com; PORT=3306; DATABASE=myDatabase; UID=myUsername; PASSWORD=myPassword;OPTION=3;'