读书人

VB怎么向mysql插值?总是出错

发布时间: 2012-01-19 20:57:59 作者: rapoo

VB如何向mysql插值?总是出错!
Dim smConnString As String
smConnString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;PORT=3306;DATABASE=dstore;USER=root;PASSWORD=111111;OPTION=3; "
Dim rs2 As New ADODB.Recordset
Dim connm As New ADODB.Connection
connm.Open smConnString

rs2.Open "INSERT INTO fenzu (username, unit) VALUES( '1 ', '1 ') ", connm


Set rs2 = Nothing
Set connm = Nothing

[解决办法]
connm.execute "INSERT INTO fenzu (username, unit) VALUES( '1 ', '1 ') "

读书人网 >VB

热点推荐