谢谢楼各位的回答,上面的问题已经解决,现在的问题是我用VB连接MYSQL时,程序如下: Dim objCn As New ADODB.Connection Dim rs As New ADODB.RecordsetPrivate Sub Form_Load()objCn.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=" & mySqlIP & ";PORT=3306;database=mysql;uid=" & usr_id & ";pwd=" & pass & ";OPTION=131072;" objCn.Open rs.Open "Select * From help_topic", objCn, adOpenKeyset, adLockOptimistic MsgBox rs.RecordCount end sub 没有报任何错误,可是rs.RecordCount的值是-1,这是怎么回事呀,
GUI工具:PHPAdmin、SQLyog(有汉化版本.推荐)、MySQL Administrator(Mysql官方出品,对汉语支持不好)
我也下载了一个PHPAdmin,可是不知道应该怎么用,好像不能安装(还是不用安装),应该怎么办,谢谢,
Dim objCn As New ADODB.Connection
Dim rs As New ADODB.RecordsetPrivate Sub Form_Load()objCn.ConnectionString = "driver={MySQL ODBC 3.51 Driver};server=" & mySqlIP & ";PORT=3306;database=mysql;uid=" & usr_id & ";pwd=" & pass & ";OPTION=131072;" objCn.Open
rs.Open "Select * From help_topic", objCn, adOpenKeyset, adLockOptimistic
MsgBox rs.RecordCount
end sub
没有报任何错误,可是rs.RecordCount的值是-1,这是怎么回事呀,