PB judges the status of SQLServer2000

xiaoxiao2021-03-06  59

/ / Judgment if the SQL Server has been launched, if not started, do the corresponding processing st_status.text = 'to determine if the SQL Server has started ...' oleObject PBObjectlong Ll_Status

PBObject = crete oleobjectll_status = pbobject.connecttonewObject ("sqldmo.sqlserver")

String ls_servernameinteger li_returnstring ls_usernamestring ls_password

Constant Integer SQLDMOSvc_Unknown = 0 // unknown state Constant Integer SQLDMOSvc_Running = 1 // has started Constant Integer SQLDMOSvc_Paused = 2 // SQL Server on hold Constant Integer SQLDMOSvc_Stopped = 3 // SQL Server is stopped Constant Integer SQLDMOSvc_Starting = 4 // SQLSERVER starting (closed -> start) Constant Integer SQLDMOSvc_Stopping = 5 // SQLSERVER is closing Constant integer SQLDMOSvc_Continuing = 6 // SQLSERVER is starting (pause -> start) Constant Integer SQLDMOSvc_Pausing = 7 // SQLSERVER Holding (start - > Pause)

LS_SERVERNAME = '218.71.42.229'ls_username =' sa'ls_password = ''

转载请注明原文地址:https://www.9cbs.com/read-83990.html

New Post(0)