I need to determine from ASP if the database server is up and running, and
if it isn't ping another database server. I posted this before about a
different client, and I was told to request a file from the IIS server, and
if I cannot retrieve it, the server is not there. I cannot use this method
due to one database box being Solaris and the other UNIX, so I need to ping.

Thanks!
David Lozzi

Couldn't you simply try establishing a database connection to the other
database server? That's what it's there for, after all?

Besides, pinging the server only tells you that the external nic is enabled
and it is accepting traffic. Never mind that the server might be set to
"hide" from pings (e.g. ping www.microsoft.com, you know it exists, right?),
even if a ping is positive, that doesn't tell you whether the database
service is running, or if it will accept your credentials when you log on.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/




"David Lozzi" <dlozzi@delphi-ts.com> wrote in message
news:ODqcxmhMEHA.3668@TK2MSFTNGP11.phx.gbl...[color=blue]
> I need to determine from ASP if the database server is up and running, and
> if it isn't ping another database server. I posted this before about a
> different client, and I was told to request a file from the IIS server,[/color]
and[color=blue]
> if I cannot retrieve it, the server is not there. I cannot use this method
> due to one database box being Solaris and the other UNIX, so I need to[/color]
ping.[color=blue]
>
> Thanks!
> David Lozzi
>
>[/color]

WOW, thank you. Its been a rough day for me ;)

Thanks,
David Lozzi


"Aaron Bertrand - MVP" <aaron@TRASHaspfaq.com> wrote in message
news:%23RPPNqhMEHA.3660@TK2MSFTNGP10.phx.gbl...[color=blue]
> Couldn't you simply try establishing a database connection to the other
> database server? That's what it's there for, after all?
>
> Besides, pinging the server only tells you that the external nic is[/color]
enabled[color=blue]
> and it is accepting traffic. Never mind that the server might be set to
> "hide" from pings (e.g. ping www.microsoft.com, you know it exists,[/color]
right?),[color=blue]
> even if a ping is positive, that doesn't tell you whether the database
> service is running, or if it will accept your credentials when you log on.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
>
> "David Lozzi" <dlozzi@delphi-ts.com> wrote in message
> news:ODqcxmhMEHA.3668@TK2MSFTNGP11.phx.gbl...[color=green]
> > I need to determine from ASP if the database server is up and running,[/color][/color]
and[color=blue][color=green]
> > if it isn't ping another database server. I posted this before about a
> > different client, and I was told to request a file from the IIS server,[/color]
> and[color=green]
> > if I cannot retrieve it, the server is not there. I cannot use this[/color][/color]
method[color=blue][color=green]
> > due to one database box being Solaris and the other UNIX, so I need to[/color]
> ping.[color=green]
> >
> > Thanks!
> > David Lozzi
> >
> >[/color]
>
>[/color]