Check for connection

If you have SP2 installed with SS2K5 you can specify a Failover server.
There are ways to see if a SQL Server Instance is running using the factory
classes. (DBProviderFactory etc...)

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Bob Hamill" wrote in message

> Hi
> Sorry I forgot to mention I am using vb 2005 and mssql
> --
> Regards
> Bob
>
>
> "Bob Hamill" wrote:
>
>> Hi I want to check if a server is available - at present the system just
>> gives a message then bombs out - I want to be able to redirect to another
>> server if the software cannot find the initial connection string
>>
>> Can you please help!!
>> --
>> Regards
>> Bob
 >> Stay informed about: Check for connection