VB6 ADO 连接MYSQL的字符串
VB6 ADO 连接MYSQL的字符串,请提供 一下 ,谢谢大家另外,再问一下,MY SQL 被ORACLE收购后还有前途吗 --------------------编程问答-------------------- --------------------编程问答-------------------- mConn.ConnectionString ="{MySQL ODBC 3.51 Driver};SERVER=xxx.xxx.xxx.xxx;port=3306;DATABASE=dbname;UID=xxx;pwd=xxx;OPTION=3" --------------------编程问答--------------------
'客户端需要安装mysql5.1驱动
dim conn as new adodb.connection
With conn
If .State = adStateOpen Then .Close
.ConnectionString = " DRIVER={MySQL ODBC 5.1 Driver};" _
& " SERVER=服务器名;" _
& " DATABASE=数据库名;" _
& " UID=登录名;" _
& " PWD=登录密码;" _
& " stmt=SET NAMES GB2312"
.CommandTimeout = 0
.Open
End With
补充:VB , 基础类