VB 检测服务状态.

[amd8750]

搭建了一个mssql 服务器, 在首界面做一个服务器状态的提示,
是直接连接检测sql端口好,还是ping服务器ip好? 那种检测方式快速而且程序不假死?

我自己看网上大神的代码,结合修改了一下, 使用ping的方式,但是有这个问题,程序开启的时候有非常短的卡顿,感觉0.3s左右.
如何修改才可以让这个ping操作在程序运行之后在进行,而且不会出现短暂卡顿或假死?



程序代码

Private Sub Form_Load()
If PingIP("192.168.20.1") Then
Label3.Caption = "正常"
Else
Label3.Caption = "不正常"
End If
End Sub

模块代码 (这段确实太长了,很多地方都看不懂...新手,请大家简练)

Option Explicit
 
Private Const IP_SUCCESS As Long = 0
Private Const IP_STATUS_BASE As Long = 11000
Private Const IP_BUF_TOO_SMALL As Long = (11000 + 1)
Private Const IP_DEST_NET_UNREACHABLE As Long = (11000 + 2)
Private Const IP_DEST_HOST_UNREACHABLE As Long = (11000 + 3)
Private Const IP_DEST_PROT_UNREACHABLE As Long = (11000 + 4)
Private Const IP_DEST_PORT_UNREACHABLE As Long = (11000 + 5)
Private Const IP_NO_RESOURCES As Long = (11000 + 6)
Private Const IP_BAD_OPTION As Long = (11000 + 7)
Private Const IP_HW_ERROR As Long = (11000 + 8)
Private Const IP_PACKET_TOO_BIG As Long = (11000 + 9)
Private Const IP_REQ_TIMED_OUT As Long = (11000 + 10)
Private Const IP_BAD_REQ As Long = (11000 + 11)
Private Const IP_BAD_ROUTE As Long = (11000 + 12)
Private Const IP_TTL_EXPIRED_TRANSIT As Long = (11000 + 13)
Private Const IP_TTL_EXPIRED_REASSEM As Long = (11000 + 14)
Private Const IP_PARAM_PROBLEM As Long = (11000 + 15)
Private Const IP_SOURCE_QUENCH As Long = (11000 + 16)
Private Const IP_OPTION_TOO_BIG As Long = (11000 + 17)
Private Const IP_BAD_DESTINATION As Long = (11000 + 18)
Private Const IP_ADDR_DELETED As Long = (11000 + 19)
Private Const IP_SPEC_MTU_CHANGE As Long = (11000 + 20)
Private Const IP_MTU_CHANGE As Long = (11000 + 21)
Private Const IP_UNLOAD As Long = (11000 + 22)
Private Const IP_ADDR_ADDED As Long = (11000 + 23)
Private Const IP_GENERAL_FAILURE As Long = (11000 + 50)
Private Const MAX_IP_STATUS As Long = (11000 + 50)
Private Const IP_PENDING As Long = (11000 + 255)
Private Const PING_TIMEOUT As Long = 500
Private Const WS_VERSION_REQD As Long = &H101
Private Const MIN_SOCKETS_REQD As Long = 1
Private Const SOCKET_ERROR As Long = -1
Private Const INADDR_NONE As Long = &HFFFFFFFF
Private Const MAX_WSADescription As Long = 256
Private Const MAX_WSASYSStatus As Long = 128
 
Public PingTime As Long
Private Type ICMP_OPTIONS
Ttl As Byte
Tos As Byte
Flags As Byte
OptionsSize As Byte
OptionsData As Long
End Type
 
Private Type ICMP_ECHO_REPLY
Address As Long
status As Long
RoundTripTime As Long
DataSize As Long
DataPointer As Long
Options As ICMP_OPTIONS
Data As String * 250
End Type
 
Private Type WSADATA
wVersion As Integer
wHighVersion As Integer
szDescription(0 To MAX_WSADescription) As Byte
szSystemStatus(0 To MAX_WSASYSStatus) As Byte
wMaxSockets As Long
wMaxUDPDG As Long
dwVendorInfo As Long
End Type
 
Public Declare Function timeGetTime Lib "winmm.dll" () As Long
Private Declare Function WSAStartup Lib "wsock32" (ByVal wVersionRequired As Long, lpWSADATA As WSADATA) As Long
Private Declare Function WSACleanup Lib "wsock32" () As Long
Private Declare Function IcmpCreateFile Lib "icmp.dll" () As Long
Private Declare Function inet_addr Lib "wsock32" (ByVal s As String) As Long
Private Declare Function IcmpCloseHandle Lib "icmp.dll" (ByVal IcmpHandle As Long) As Long
Private Declare Function IcmpSendEcho Lib "icmp.dll" (ByVal IcmpHandle As Long, ByVal DestinationAddress As Long, ByVal RequestData As String, ByVal RequestSize As Long, ByVal RequestOptions As Long, ReplyBuffer As ICMP_ECHO_REPLY, ByVal ReplySize As Long, ByVal Timeout As Long) As Long
 
Private Function GetStatusCode(status As Long) As String
On Error GoTo ErrLine
Dim Msg As String
GetStatusCode = ""
Select Case status
Case IP_SUCCESS
Msg = "ip success"
Case INADDR_NONE
Msg = "inet_addr: bad IP format"
Case IP_BUF_TOO_SMALL
Msg = "ip buf too_small"
Case IP_DEST_NET_UNREACHABLE
Msg = "ip dest net unreachable"
Case IP_DEST_HOST_UNREACHABLE
Msg = "ip dest host unreachable"
Case IP_DEST_PROT_UNREACHABLE
Msg = "ip dest port unreachable"
Case IP_DEST_PORT_UNREACHABLE
Msg = "ip dest port unreachable"
Case IP_NO_RESOURCES
Msg = "ip no resources"
Case IP_BAD_OPTION
Msg = "ip bad option"
Case IP_HW_ERROR
Msg = "ip hw_error"
Case IP_PACKET_TOO_BIG
Msg = "ip packet too_big"
Case IP_REQ_TIMED_OUT
Msg = "ip req timed out"
Case IP_BAD_REQ
Msg = "ip bad req"
Case IP_BAD_ROUTE
Msg = "ip bad route"
Case IP_TTL_EXPIRED_TRANSIT
Msg = "ip ttl expired transit"
Case IP_TTL_EXPIRED_REASSEM
Msg = "ip ttl expired reassem"
Case IP_PARAM_PROBLEM
Msg = "ip param_problem"
Case IP_SOURCE_QUENCH
Msg = "ip source quench"
Case IP_OPTION_TOO_BIG
Msg = "ip option too_big"
Case IP_BAD_DESTINATION
Msg = "ip bad destination"
Case IP_ADDR_DELETED
Msg = "ip addr deleted"
Case IP_SPEC_MTU_CHANGE
Msg = "ip spec mtu change"
Case IP_MTU_CHANGE
Msg = "ip mtu_change"
Case IP_UNLOAD
Msg = "ip unload"
Case IP_ADDR_ADDED
Msg = "ip addr added"
Case IP_GENERAL_FAILURE
Msg = "ip general failure"
Case IP_PENDING
Msg = "ip pending"
Case PING_TIMEOUT
Msg = "ping timeout"
Case Else
Msg = "unknown msg returned"
End Select
GetStatusCode = Msg
Exit Function
ErrLine:
End Function
 
Private Function Ping(sAddress As String, sDataToSend As String, ECHO As ICMP_ECHO_REPLY) As Long
On Error GoTo ErrLine
Dim hPort As Long
Dim dwAddress As Long
dwAddress = inet_addr(sAddress)
If dwAddress <> INADDR_NONE Then
hPort = IcmpCreateFile()
If hPort Then
Call IcmpSendEcho(hPort, dwAddress, sDataToSend, Len(sDataToSend), 0, ECHO, Len(ECHO), PING_TIMEOUT)
Ping = ECHO.status
Call IcmpCloseHandle(hPort)
End If
Else
Ping = INADDR_NONE
End If
Exit Function
ErrLine:
Ping = INADDR_NONE
End Function
 
Public Function PingIP(ByVal szIp As String) As Boolean
On Error GoTo ErrLine
Dim WSAD As WSADATA
Dim ECHO As ICMP_ECHO_REPLY
Dim ret As Long
'Delay 150
PingIP = False
PingTime = Empty
If WSAStartup(WS_VERSION_REQD, WSAD) = IP_SUCCESS Then
ret = Ping(Trim$(szIp), "tanaya", ECHO)
PingTime = ECHO.RoundTripTime
If InStr(1, GetStatusCode(ret), "success") <> 0 Then
WSACleanup
PingIP = True
PingTime = ECHO.RoundTripTime
Exit Function
End If
End If
Exit Function
ErrLine:
End Function

[Tiger_Zhao]

不要试图检查服务器的在线状态，直接连接数据库看是否报错。
如果服务器断线，无论怎么做都是通过等待超时来实现的，没有快速的方法。

[amd8750]

引用 1 楼 Tiger_Zhao 的回复:

不要试图检查服务器的在线状态，直接连接数据库看是否报错。 如果服务器断线，无论怎么做都是通过等待超时来实现的，没有快速的方法。

您好,用啥方法可以直连数据库,并把实时状态显示出来呢?

[Tiger_Zhao]

不需要显示状态。
你的程序能工作（能访问数据库）就是正常的。
保证环境正常可访问是用户的责任。

假如你生成个手机充电器，难道还要考虑：
A)可能要打雷，要加上防雷击功能。
B)可能要海啸，要加上防水、防漏电功能。
C)可能要地震，要加固成6层楼房压下来都不坏。
D)……