代码:Private Sub CommandButton1_Click()
Dim con As New ADODB.Connection
Dim cmd As ADODB.Command
Dim strSQL As String
Dim strCon As String
con.ConnectionString = "driver={SQL Server};" & _
"server=server;uid=sa;pwd=1111;database=pubs"
If con.State = adStateOpen Then
MsgBox "连接成功!"
Else
MsgBox "失败."
End If con.Close
End Sub
Dim con As New ADODB.Connection
Dim cmd As ADODB.Command
Dim strSQL As String
Dim strCon As String
con.ConnectionString = "driver={SQL Server};" & _
"server=server;uid=sa;pwd=1111;database=pubs"
If con.State = adStateOpen Then
MsgBox "连接成功!"
Else
MsgBox "失败."
End If con.Close
End Sub
解决方案 »
- 关于在VB中添加播放FLASH的shockwaveflash控件时出的问题求解。
- 求VB高手和软件测试员
- VB和sql2000 链接做成了以个管理系统~ 打包后可以在没有装VB和SQL的机器上运行吗?
- toolbar连接imagelist控件 为什么运行没有图片???
- 一个简单的问题,怎么让Text文本框的下拉滚动条处于底部状态?
- MsFlexGrid在设置单元格字体颜色时,是否可以不将当前单元格焦点设置过去?
- datagrid1更新的问题
- 很有趣的问题,请教高手!!!!!(小分发放)
- VB 如何将一串数字拆分成单个数字并去除相同的数字
- 水仙花数字如何编写
- vb中如何操作打印机的并口通信?
- 怎样把VB报表中的"打印"和"导出"两个按钮去掉,或者怎样加一些按钮到报表中去?
on error resume next
Dim con As New ADODB.Connection
Dim cmd As ADODB.Command
Dim strSQL As String
Dim strCon As String
con.ConnectionString = "driver={SQL Server};" & _
"server=server;uid=sa;pwd=1111;database=pubs"
con.open
If con.State = adStateOpen Then
MsgBox "连接成功!"
Else
MsgBox "失败."
End If con.Close
End Sub
Dim con As New ADODB.Connection
Dim cmd As ADODB.Command
Dim strSQL As String
Dim strCon As String
con.ConnectionString = "driver={SQL Server};" & _
"server=server;uid=sa;pwd=1111;database=pubs"
con.Open '加上这句======================== If con.State = adStateOpen Then
MsgBox "连接成功!"
Else
MsgBox "失败."
End If con.Close
End Sub