Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"运行出现:
实时错误'3705'
对象打开时,,不允许操作
Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.close
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"运行出现:
实时错误'3705'
对象关闭时,,不允许操作其他过程用:
conn.ConnectionTimeout = 10如何更改,盼赐教!
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"运行出现:
实时错误'3705'
对象打开时,,不允许操作
Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.close
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"运行出现:
实时错误'3705'
对象关闭时,,不允许操作其他过程用:
conn.ConnectionTimeout = 10如何更改,盼赐教!
解决方案 »
- Aodc.Recordset!字段名 叹号后面的字段名,有没有办法用变量啊
- 关于时间的查询报错
- Appearance 只读?
- 两个概念性问题
- 快来呀!让你的HFlexGrid也支持滚轮!!自写代码,请指教!
- 在线求助:在VB中读写文件的方法
- 求教在windows2000下获取系统路径的方法!
- MediaPlayer控件的问题!
- 怎样在代码中写adodc控件的相对路径
- 请问Active Report 1.1中怎样打印带Filter的记录集
- 记得有一个DLL文件,可以屏蔽webbrowser控件的所有鼠标右键操作,谁有此DLL文件的下载地址和使用示例,请提供?
- 求VB保存和输出任意类型文件到SQL SERVER中最理想的方法,(在线等...)
然后去掉conn.close试试
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
'//这里不可以关闭
---------------------------------------------------------------------
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"
---------------------------------------------------------------------
改成:conn.Execute "update [123] set www=0 where 起始>'0001' and 终止<'0010'"
试一下!
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.open '连接对像打开后才有效
'可以到程序退出时才关闭此对象,或是不关闭也可以,应用程序退出后此连接会自动断的
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"
Dim conn As New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"
把这个时间设长点:
conn.ConnectionTimeout = 45
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"运行出现:
实时错误'3705'
对象打开时,,不允许操作因为你设置了连接字符串,但是没有打开,在conn.Execute ,前加上CONN.OPENDim conn As New ADODB.Connection
conn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=abc;Data Source=TTTTTT;"
conn.close'关闭连接
conn.Execute "update [123] set www=0 where '起始'>0001 and '终止'<0010"是因为你关闭了连接,,应该把这一句放到最后还有一个问题
update [123] set www=0 where '起始'>0001 and '终止'<0010
SQL语句可能有错误,'起始'>0001 and '终止'<0010,
字段名上面不可以添加引号,至少改成起始>'0001' and 终止<'0010'
还有最好将这两个字段设为数值,字符串比较很慢,而且容易出错