bonjour,
j'ai besoin de faire le ping sur tous les équipements qui se trouve dans la base de données.
1) j'ai mis ce code dans le module:
2) j'ai fait un MSFLEXGRID dans le quel je vais mettre les adresses_ip de chaque équipement:
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243 Option Explicit Public cnn As New ADODB.Connection Public connexion As Boolean 'Option Explicit 'Icmp constants converted from 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_pingstatus.asp Private Const ICMP_SUCCESS As Long = 0 Private Const ICMP_STATUS_BUFFER_TO_SMALL = 11001 'Buffer Too Small Private Const ICMP_STATUS_DESTINATION_NET_UNREACH = 11002 'Destination Net Unreachable Private Const ICMP_STATUS_DESTINATION_HOST_UNREACH = 11003 'Destination Host Unreachable Private Const ICMP_STATUS_DESTINATION_PROTOCOL_UNREACH = 11004 'Destination Protocol Unreachable Private Const ICMP_STATUS_DESTINATION_PORT_UNREACH = 11005 'Destination Port Unreachable Private Const ICMP_STATUS_NO_RESOURCE = 11006 'No Resources Private Const ICMP_STATUS_BAD_OPTION = 11007 'Bad Option Private Const ICMP_STATUS_HARDWARE_ERROR = 11008 'Hardware Error Private Const ICMP_STATUS_LARGE_PACKET = 11009 'Packet Too Big Private Const ICMP_STATUS_REQUEST_TIMED_OUT = 11010 'Request Timed Out Private Const ICMP_STATUS_BAD_REQUEST = 11011 'Bad Request Private Const ICMP_STATUS_BAD_ROUTE = 11012 'Bad Route Private Const ICMP_STATUS_TTL_EXPIRED_TRANSIT = 11013 'TimeToLive Expired Transit Private Const ICMP_STATUS_TTL_EXPIRED_REASSEMBLY = 11014 'TimeToLive Expired Reassembly Private Const ICMP_STATUS_PARAMETER = 11015 'Parameter Problem Private Const ICMP_STATUS_SOURCE_QUENCH = 11016 'Source Quench Private Const ICMP_STATUS_OPTION_TOO_BIG = 11017 'Option Too Big Private Const ICMP_STATUS_BAD_DESTINATION = 11018 'Bad Destination Private Const ICMP_STATUS_NEGOTIATING_IPSEC = 11032 'Negotiating IPSEC Private Const ICMP_STATUS_GENERAL_FAILURE = 11050 'General Failure Public Const WINSOCK_ERROR = "Windows Sockets not responding correctly." Public Const INADDR_NONE As Long = &HFFFFFFFF Public Const WSA_SUCCESS = 0 Public Const WS_VERSION_REQD As Long = &H101 'Clean up sockets. 'http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154512 Private Declare Function WSACleanup Lib "WSOCK32.DLL" () As Long 'Open the socket connection. 'http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154512 Private Declare Function WSAStartup Lib "WSOCK32.DLL" (ByVal wVersionRequired As Long, lpWSADATA As WSADATA) As Long 'Create a handle on which Internet Control Message Protocol (ICMP) requests can be issued. 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcesdkr/htm/_wcesdk_icmpcreatefile.asp Private Declare Function IcmpCreateFile Lib "icmp.dll" () As Long 'Convert a string that contains an (Ipv4) Internet Protocol dotted address into a correct address. 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winsock/wsapiref_4esy.asp Private Declare Function inet_addr Lib "WSOCK32.DLL" (ByVal cp As String) As Long 'Close an Internet Control Message Protocol (ICMP) handle that IcmpCreateFile opens. 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcesdkr/htm/_wcesdk_icmpclosehandle.asp Private Declare Function IcmpCloseHandle Lib "icmp.dll" (ByVal IcmpHandle As Long) As Long 'Information about the Windows Sockets implementation 'http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154512 Private Type WSADATA wVersion As Integer wHighVersion As Integer szDescription(0 To 256) As Byte szSystemStatus(0 To 128) As Byte iMaxSockets As Long iMaxUDPDG As Long lpVendorInfo As Long End Type 'Send an Internet Control Message Protocol (ICMP) echo request, and then return one or more replies. 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcetcpip/htm/cerefIcmpSendEcho.asp 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 'This structure describes the options that will be included in the header of an IP packet. 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcetcpip/htm/cerefIP_OPTION_INFORMATION.asp Private Type IP_OPTION_INFORMATION Ttl As Byte Tos As Byte Flags As Byte OptionsSize As Byte OptionsData As Long End Type 'This structure describes the data that is returned in response to an echo request. 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wcesdkr/htm/_wcesdk_icmp_echo_reply.asp Public Type ICMP_ECHO_REPLY address As Long Status As Long RoundTripTime As Long DataSize As Long Reserved As Integer ptrData As Long Options As IP_OPTION_INFORMATION Data As String * 250 End Type Public Function connexion_cnn() As Boolean cnn.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Base;Data Source=.\SQLEXPRESS;Initial File Name=C:\application PFE\Base\Base.mdf" cnn.Open End Function '-------------------------- ' PING '-------------------------- '-- Ping a string representation of an IP address. ' -- Return a reply. ' -- Return long code. Public Function ping(sAddress As String, Reply As ICMP_ECHO_REPLY) As Long Dim hIcmp As Long Dim lAddress As Long Dim lTimeOut As Long Dim StringToSend As String 'Short string of data to send StringToSend = "hello" 'ICMP (ping) timeout lTimeOut = 1000 'ms 'Convert string address to a long representation. lAddress = inet_addr(sAddress) If (lAddress <> -1) And (lAddress <> 0) Then 'Create the handle for ICMP requests. hIcmp = IcmpCreateFile() If hIcmp Then 'Ping the destination IP address. Call IcmpSendEcho(hIcmp, lAddress, StringToSend, Len(StringToSend), 0, Reply, Len(Reply), lTimeOut) 'Reply status ping = Reply.Status 'Close the Icmp handle. IcmpCloseHandle hIcmp Else Debug.Print "failure opening icmp handle." ping = -1 End If Else ping = -1 End If End Function 'Clean up the sockets. 'http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154512 Public Sub SocketsCleanup() WSACleanup End Sub 'Get the sockets ready. 'http://support.microsoft.com/default.aspx?scid=kb;EN-US;q154512 Public Function SocketsInitialize() As Boolean Dim WSAD As WSADATA SocketsInitialize = WSAStartup(WS_VERSION_REQD, WSAD) = ICMP_SUCCESS End Function 'Convert the ping response to a message that you can read easily from constants. 'For more information about these constants, visit the following Microsoft Web site: 'http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/win32_pingstatus.asp Public Function EvaluatePingResponse(PingResponse As Long) As String Select Case PingResponse 'Success Case ICMP_SUCCESS: EvaluatePingResponse = "Success!" cartographie.MSFlexGrid1.CellBackColor = &H80FF80 'Some error occurred Case ICMP_STATUS_BUFFER_TO_SMALL: EvaluatePingResponse = "Buffer Too Small" Case ICMP_STATUS_DESTINATION_NET_UNREACH: EvaluatePingResponse = "Destination Net Unreachable" Case ICMP_STATUS_DESTINATION_HOST_UNREACH: EvaluatePingResponse = "Destination Host Unreachable" Case ICMP_STATUS_DESTINATION_PROTOCOL_UNREACH: EvaluatePingResponse = "Destination Protocol Unreachable" Case ICMP_STATUS_DESTINATION_PORT_UNREACH: EvaluatePingResponse = "Destination Port Unreachable" Case ICMP_STATUS_NO_RESOURCE: EvaluatePingResponse = "No Resources" Case ICMP_STATUS_BAD_OPTION: EvaluatePingResponse = "Bad Option" Case ICMP_STATUS_HARDWARE_ERROR: EvaluatePingResponse = "Hardware Error" Case ICMP_STATUS_LARGE_PACKET: EvaluatePingResponse = "Packet Too Big" Case ICMP_STATUS_REQUEST_TIMED_OUT: EvaluatePingResponse = "Request Timed Out" Case ICMP_STATUS_BAD_REQUEST: EvaluatePingResponse = "Bad Request" Case ICMP_STATUS_BAD_ROUTE: EvaluatePingResponse = "Bad Route" Case ICMP_STATUS_TTL_EXPIRED_TRANSIT: EvaluatePingResponse = "TimeToLive Expired Transit" Case ICMP_STATUS_TTL_EXPIRED_REASSEMBLY: EvaluatePingResponse = "TimeToLive Expired Reassembly" Case ICMP_STATUS_PARAMETER: EvaluatePingResponse = "Parameter Problem" Case ICMP_STATUS_SOURCE_QUENCH: EvaluatePingResponse = "Source Quench" Case ICMP_STATUS_OPTION_TOO_BIG: EvaluatePingResponse = "Option Too Big" Case ICMP_STATUS_BAD_DESTINATION: EvaluatePingResponse = "Bad Destination" cartographie.MSFlexGrid1.CellBackColor = &H8080FF Case ICMP_STATUS_NEGOTIATING_IPSEC: EvaluatePingResponse = "Negotiating IPSEC" Case ICMP_STATUS_GENERAL_FAILURE: EvaluatePingResponse = "General Failure" 'Unknown error occurred Case Else: EvaluatePingResponse = "Unknown Response" End Select End Function
je veut savoir comment je peux faire le ping sur toutes les adresses des équipements qui se trouve dans le MSFLEXGRID ???
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114 Option Explicit Dim Rs1 As New ADODB.Recordset Dim Rs2 As New ADODB.Recordset Dim Rs3 As New ADODB.Recordset Dim requete As String Dim compteur, curseur, ligne, mg As Long Dim i As Integer Private Sub Command1_Click() Dim Reply As ICMP_ECHO_REPLY Dim lngSuccess As Long Dim strIPAddress As String Label2.BackColor = &H80FF80 Label2.Caption = "Surveillance Active" 'Get the sockets ready. Rs1.Open "select adresse_ip, NOM_CELLULE from serveur", cnn, adOpenKeyset, adLockOptimistic MSFlexGrid1.Cols = 10 MSFlexGrid1.Rows = 10 MSFlexGrid1.ColWidth(0) = 0 If Rs1.RecordCount > 0 Then i = 1 Rs1.AbsolutePosition = 1 MSFlexGrid1.Row = 0 Do While Not Rs1.EOF MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1 MSFlexGrid1.Cols = MSFlexGrid1.Cols + 1 MSFlexGrid1.TextMatrix(1, i) = Rs1.Fields("adresse_ip") MSFlexGrid1.TextMatrix(2, i) = Rs1.Fields("NOM_CELLULE") i = i + 1 Rs1.MoveNext Loop End If 'Rs1.Close Rs2.Open "select adresse_ip_interface, NOM_CELLULE from routeur", cnn, adOpenKeyset, adLockOptimistic MSFlexGrid1.Cols = 10 MSFlexGrid1.Rows = 10 MSFlexGrid1.ColWidth(0) = 0 If Rs2.RecordCount > 0 Then i = 1 Rs2.AbsolutePosition = 1 MSFlexGrid1.Row = 0 Do While Not Rs2.EOF MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1 MSFlexGrid1.Cols = MSFlexGrid1.Cols + 1 MSFlexGrid1.TextMatrix(4, i) = Rs2.Fields("adresse_ip_interface") MSFlexGrid1.TextMatrix(5, i) = Rs2.Fields("NOM_CELLULE") i = i + 1 Rs2.MoveNext Loop End If Rs2.Close Rs3.Open "select NOM_CELLULE from switch", cnn, adOpenKeyset, adLockOptimistic MSFlexGrid1.Cols = 10 MSFlexGrid1.Rows = 10 MSFlexGrid1.ColWidth(0) = 0 If Rs3.RecordCount > 0 Then i = 1 Rs3.AbsolutePosition = 1 MSFlexGrid1.Row = 0 Do While Not Rs3.EOF MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1 MSFlexGrid1.Cols = MSFlexGrid1.Cols + 1 MSFlexGrid1.TextMatrix(7, i) = Rs3.Fields("NOM_CELLULE") i = i + 1 Rs3.MoveNext Loop End If Rs3.Close If SocketsInitialize() Then 'Address to ping strIPAddress = "127.0.0.1" 'Ping the IP that is passing the address and get a reply. lngSuccess = ping(strIPAddress, Reply) 'Display the results. Debug.Print "Address to Ping: " & strIPAddress Debug.Print "Raw ICMP code: " & lngSuccess Debug.Print "Ping Response Message : " & EvaluatePingResponse(lngSuccess) Debug.Print "Time : " & Reply.RoundTripTime & " ms" 'Clean up the sockets. SocketsCleanup Else 'Winsock error failure, initializing the sockets. Debug.Print WINSOCK_ERROR End If Rs1.Close End Sub
aussi, comment je peux faire ce test: si le ping est réalisé correctement alors la cellule est coloré en vert (MSFlexGrid1.CellBackColor = &H80FF80) sinon en rouge (MSFlexGrid1.CellBackColor = &H8080FF) ????
SVP aider moi
Merci beaucoup
Partager