Sub main() If ConnectToServer = False Then End End Sub 将启动对象设置为Sub main
Public Function connecttoserver() As Boolean On Error GoTo connecterr con.ConnectionString = "driver={SQL Server};" & _ "server=你的数据库服务器的名称;uid=;pwd=;database=book" con.ConnectionTimeout = 20 con.Open connecttoserver = True Exit Function connecterr: connecttoserver = False MsgBox "数据库服务器还没有打开" End Function
装SQL SERVER2000,在VB中引用"Microsoft SQLDMO Object Library" dim svrDB as new SQLDMO.SQLServer svrDB.Connect "192.168.0.1","sa","pwd" svrDB.Stop svrDB.close set svrDB=nothing
If ConnectToServer = False Then End
End Sub
将启动对象设置为Sub main
On Error GoTo connecterr
con.ConnectionString = "driver={SQL Server};" & _
"server=你的数据库服务器的名称;uid=;pwd=;database=book"
con.ConnectionTimeout = 20
con.Open
connecttoserver = True
Exit Function
connecterr:
connecttoserver = False
MsgBox "数据库服务器还没有打开"
End Function
shell "net stop MSSQLSERVER" 停止服务
如果数据库跟客户端程序不在一台机器上,也就是说是远程mssqlserver, "net start mssqlserver"是不是就不能用了啊?
dim svrDB as new SQLDMO.SQLServer
svrDB.Connect "192.168.0.1","sa","pwd"
svrDB.Stop
svrDB.close
set svrDB=nothing
是什么原因啊