用ADO连接MYSQL的连接字符串

时间：2009-04-14 来源：guoguo-beijing2008

* 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;'