TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Bob B
NA
9
0
Checking for SQL existence???
Jul 25 2005 12:45 PM
I have a small application which makes a connection to an SQL DB and I am wondering if there was any
way to programatically check to see if the server is available or not prior to opening the connection.
I'm not sure if I'm making a whole lot fo sense here but this is basically what I'm running in to.
If I go to open the DB connection cn.open() but the SQL server happens to be down... then the app
will just hang for about 1 minute. I would like to know if there is anyway I can control this timeout and
have the application go elsewhere.
I no how to set the SQL timeout but that does not seem to address what I am running in to.
Any assistance with this would be greatly appreciaated.
Thanks,
Bob
Reply
Answers (
2
)
ComboBox related to SqlServer
update dataset with diffgram