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 ') "