<%@ LANGUAGE=VBScript%><% 'Buffer output so that different pages can be displayed. Response.Buffer = True %><HTML> <head> <title>测试!</title> </head> <body bgcolor="#FFFFFF" topmargin="0" leftmargin="0" LINK="#0080FF" VLINK="#0080FF"><% Dim ccData ' Use it to instantiate another object. Set ccData = Server.CreateObject("SQLDMO.SQLServer") ccData.Connect "你的MSSQLSERVERNAME", "你的用户", "你的口令" if ccData.ConnectionID<>0 then Response.Write("已经建立连接") ccData.Shutdown end if ccData.Close Set ccData=Nothing %> </body> </html>
stop是可以的,我刚刚想试一下start但是不行哦 Private Sub Command1_Click() Dim dd As New SQLDMO.SQLServer Set dd = CreateObject("SQLDMO.SQLServer") 'dd.Connect "server", "sa", "" dd.Start True, "server", "sa", "" End Sub
'Buffer output so that different pages can be displayed.
Response.Buffer = True
%><HTML>
<head>
<title>测试!</title>
</head>
<body bgcolor="#FFFFFF" topmargin="0" leftmargin="0" LINK="#0080FF" VLINK="#0080FF"><%
Dim ccData
' Use it to instantiate another object.
Set ccData = Server.CreateObject("SQLDMO.SQLServer")
ccData.Connect "你的MSSQLSERVERNAME", "你的用户", "你的口令"
if ccData.ConnectionID<>0 then
Response.Write("已经建立连接")
ccData.Shutdown
end if
ccData.Close
Set ccData=Nothing
%>
</body>
</html>
Shell "net stop mssqlserver", vbHide
启动服务:
Shell "net start mssqlserver", vbHide
“mssqlserver”,如果不是,将”Shell "net stop .......",vbHide“语句中的处换成对应的名称就OK了
Private Sub Command1_Click()
Dim dd As New SQLDMO.SQLServer
Set dd = CreateObject("SQLDMO.SQLServer")
'dd.Connect "server", "sa", ""
dd.Start True, "server", "sa", ""
End Sub