Solved

Determine whether a server is responding

Posted on 2004-10-14
4
235 Views
Last Modified: 2010-05-02
I am trying to determine whether a server is responding.
I tried using ListAvailableSQLServers:

    Set oNames = oSQLApp.ListAvailableSQLServers()
    For i = 1 To oNames.Count
        If oNames.Item(i) = serverName Then
            serverCheck = True
            Exit For
        End If
    Next i

However, I get an error 'Not enough storage is available to complete this operation' when the oSQLApp.ListAvailableSQLServers() command is executed.

Is there another way to determine whether a server is availabe?

Thanks,

Louise
0
Comment
Question by:louiserutherford
4 Comments
 
LVL 26

Accepted Solution

by:
EDDYKT earned 250 total points
ID: 12307302
0
 
LVL 48

Expert Comment

by:Mikal613
ID: 12307385
0
 
LVL 76

Expert Comment

by:David Lee
ID: 12315138
What do you consider to be "available"?  Ping will tell you if the server is available from a communications perspective.  WMI will allow you to see if a specific service is running on a given machine.  If you could be a little more specific, then we might be able to give a more definitive answer.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question