DBServer_MySql = "xxx" '数据库服务器
地址
DBUsername_MySql = "yyy" '用户名
DBPassword_MySql = "zzz" '用户密码
DBName_MySql = "aaa" '数据库名
ConnString_MySql = "Driver={MySQL ODBC 3.51 Driver};Server=" & DBServer_MySql & ";Uid=" & DBUsername_MySql & ";Pwd=" & DBPassword_MySql & ";Database=" & DBName_MySql & ";Port=3306;Option=3;Socket=;Stmt=Set Names 'GBK';"
注意数据库连接串里面的 Stmt=Set Names 'GBK' ,一定要有这一句。
DBUsername_MySql = "yyy" '用户名
DBPassword_MySql = "zzz" '用户密码
DBName_MySql = "aaa" '数据库名
ConnString_MySql = "Driver={MySQL ODBC 3.51 Driver};Server=" & DBServer_MySql & ";Uid=" & DBUsername_MySql & ";Pwd=" & DBPassword_MySql & ";Database=" & DBName_MySql & ";Port=3306;Option=3;Socket=;Stmt=Set Names 'GBK';"
注意数据库连接串里面的 Stmt=Set Names 'GBK' ,一定要有这一句。