Check to ensure server and db available

When I load the startup form, I want to make a check to ensure the named
server AND database (SQL2k) is available before trying to load any data. Any
recommendations?

Miha
Sat Jul 30 03:15:53 CDT 2005

Try a connect (embedded in try/catch block).

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
> When I load the startup form, I want to make a check to ensure the named
> server AND database (SQL2k) is available before trying to load any data.
> Any recommendations?
>

Scott
Sat Jul 30 08:10:52 CDT 2005

.... configure and instantiate connection object...

Try
connection.open()
Catch ex As Exception
'Handle inability to open connection here
Finally
connection.close()
End Try


"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
> When I load the startup form, I want to make a check to ensure the named
> server AND database (SQL2k) is available before trying to load any data.
> Any recommendations?
>

William
Sat Jul 30 11:27:58 CDT 2005

The 2.0 Framework has a number of new "factory" classes and service classes
that make this easy. I'll be showing those at VSLive in Orlando in October.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
> When I load the startup form, I want to make a check to ensure the named
> server AND database (SQL2k) is available before trying to load any data.
> Any recommendations?
>

Earl
Mon Aug 01 20:14:01 CDT 2005

Thanks for the thoughts guys. Just thought maybe there was something more
elegant than capturing an exception :=)

Oh, and when are we to see 2.0 Bill?

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:u0F6mOSlFHA.1968@TK2MSFTNGP14.phx.gbl...
> The 2.0 Framework has a number of new "factory" classes and service
> classes that make this easy. I'll be showing those at VSLive in Orlando in
> October.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
>> When I load the startup form, I want to make a check to ensure the named
>> server AND database (SQL2k) is available before trying to load any data.
>> Any recommendations?
>>
>
>

William
Tue Aug 02 10:33:03 CDT 2005

You can work with it now. The CTPs are fairly stable and good enough to
start building and testing applications for delivery in 2006.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:%23yBe29vlFHA.572@TK2MSFTNGP15.phx.gbl...
> Thanks for the thoughts guys. Just thought maybe there was something more
> elegant than capturing an exception :=)
>
> Oh, and when are we to see 2.0 Bill?
>
> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
> news:u0F6mOSlFHA.1968@TK2MSFTNGP14.phx.gbl...
>> The 2.0 Framework has a number of new "factory" classes and service
>> classes that make this easy. I'll be showing those at VSLive in Orlando
>> in October.
>>
>> --
>> ____________________________________
>> William (Bill) Vaughn
>> Author, Mentor, Consultant
>> Microsoft MVP
>> www.betav.com/blog/billva
>> www.betav.com
>> Please reply only to the newsgroup so that others can benefit.
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> __________________________________
>>
>> "Earl" <brikshoe@newsgroups.nospam> wrote in message
>> news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
>>> When I load the startup form, I want to make a check to ensure the named
>>> server AND database (SQL2k) is available before trying to load any data.
>>> Any recommendations?
>>>
>>
>>
>
>

Earl
Tue Aug 02 16:01:42 CDT 2005

Will do. I actually meant to write that as "... 2.0, Bill", but figured I
might get a response out of "...2.0 Bill" also. =)

"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:OzJI6d3lFHA.936@TK2MSFTNGP09.phx.gbl...
> You can work with it now. The CTPs are fairly stable and good enough to
> start building and testing applications for delivery in 2006.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:%23yBe29vlFHA.572@TK2MSFTNGP15.phx.gbl...
>> Thanks for the thoughts guys. Just thought maybe there was something more
>> elegant than capturing an exception :=)
>>
>> Oh, and when are we to see 2.0 Bill?
>>
>> "William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
>> news:u0F6mOSlFHA.1968@TK2MSFTNGP14.phx.gbl...
>>> The 2.0 Framework has a number of new "factory" classes and service
>>> classes that make this easy. I'll be showing those at VSLive in Orlando
>>> in October.
>>>
>>> --
>>> ____________________________________
>>> William (Bill) Vaughn
>>> Author, Mentor, Consultant
>>> Microsoft MVP
>>> www.betav.com/blog/billva
>>> www.betav.com
>>> Please reply only to the newsgroup so that others can benefit.
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>> __________________________________
>>>
>>> "Earl" <brikshoe@newsgroups.nospam> wrote in message
>>> news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
>>>> When I load the startup form, I want to make a check to ensure the
>>>> named server AND database (SQL2k) is available before trying to load
>>>> any data. Any recommendations?
>>>>
>>>
>>>
>>
>>
>
>

Earl
Thu Aug 11 22:17:00 CDT 2005

You have a recommendation on which event to fire this in? Obviously, I could
do the check when a user presses a button, but I'd much rather do it while
the form is loading. I've experimented a bit with this and none of the Form
events seem appropriate.

"Miha Markic [MVP C#]" <miha at rthand com> wrote in message
news:O9jRr7NlFHA.2860@TK2MSFTNGP15.phx.gbl...
> Try a connect (embedded in try/catch block).
>
> --
> Miha Markic [MVP C#] - RightHand .NET consulting & development
> www.rthand.com
> Blog: http://cs.rthand.com/blogs/blog_with_righthand/
> SLODUG - Slovene Developer Users Group www.codezone-si.info
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:uvtO72NlFHA.1048@tk2msftngp13.phx.gbl...
>> When I load the startup form, I want to make a check to ensure the named
>> server AND database (SQL2k) is available before trying to load any data.
>> Any recommendations?
>>
>
>