Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Determine whether a server is responding

Posted on 2004-10-14
4
Medium Priority
?
254 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
3 Comments
 
LVL 26

Accepted Solution

by:
EDDYKT earned 1000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Suggested Courses
Course of the Month21 days, 6 hours left to enroll

810 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