作者blueO ()
看板Visual_Basic
标题[VB6 ] 请问各位高手，vb6将值存进mysql的问题
时间Wed Oct 17 20:26:41 2007
请问各位高手
我的程式如下:
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseClient
conn.ConnectionString = "DRIVER=MySQL ODBC 3.51 DRIVER;SERVER=61.229.14.27;DATABASE=mydata;USER=root;password=1234;OPTION=3;"
rs.CursorType = adOpenDynamic
rs.Open "insert into 'stu_data'('name') values('111') ", conn, adOpenStatic, adLockOptimistic
End Sub
执行後会产生:
执行阶段错误'3709' 无法用连线执行此操作。内容可能已关闭或无效
请问是哪里有问题呢?
是mysql里有哪里要更改权限吗?
谢谢
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.229.14.27