On Error GoTo lbErr
Dim iDb As ADODB.Connection
Set iDb = New ADODB.Connection
Dim iConcStr As StringiConcStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=master;Data Source=HX"
iDb.Open iConcStr
Dim str As String
str = "IF EXISTS (SELECT name FROM sysobjects " & _
" WHERE name = 'bbb' AND type = 'P') " & _
" DROP PROCEDURE bbb " & _
" GO " & _
" create procedure bbb " & _
" as " & _
" print 'ccc' " & _
" go "
iDb.Execute str
lbErr:
MsgBox Error, vbOKOnly + vbExclamation, "错误!"
iDb.Close
Dim iDb As ADODB.Connection
Set iDb = New ADODB.Connection
Dim iConcStr As StringiConcStr = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=master;Data Source=HX"
iDb.Open iConcStr
Dim str As String
str = "IF EXISTS (SELECT name FROM sysobjects " & _
" WHERE name = 'bbb' AND type = 'P') " & _
" DROP PROCEDURE bbb " & _
" GO " & _
" create procedure bbb " & _
" as " & _
" print 'ccc' " & _
" go "
iDb.Execute str
lbErr:
MsgBox Error, vbOKOnly + vbExclamation, "错误!"
iDb.Close
解决方案 »
- VB初学者提问:如何动态显示数据
- vb中如何实现查找文件
- 如何知道一个声音播放完了
- 小弟软件被华军收录 心情愉快 特来散分!
- [推荐更新]Service Pack 6 for Visual Basic 6.0, Visual C++ 6.0
- 如何把ADO2.7卸掉?!急!!
- 如何判断当前datagrid控件当中,有没有选中某一条记录。记录是否是高亮显示。
- 给钱啦!
- 那位能告诉我VSflexgrid和ActiveReport在那里可以下到?????????
- 简单问题,分不多但应该很好拿!多个ado控件能不能只用一个连接????
- GETPIXEL()取到的颜色值是设备相关的,如何转换成设备无关的呀,多谢了
- 如果将一个字符变量转换为窗体类型.
先看看错误信息是什么!