how to reconnect sql connection automatical if connection loss

Question

0.00/5 (No votes)

See more:

C#

I have a sql connection in c# win form project

i want to reconnect this if connection is drop..
how to do this

thanks

Posted 1-Mar-15 17:46pm

anushikaroshan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-03-01T18:04:00

The first thing you should investigate is why the connection is lost. If this is an acceptable and 'common' situation then I'd suggest using connection pooling so that after each unit of work the connection is closed by your program and re-opened where a new unit of work is started.

For more information, see SQL Server Connection Pooling (ADO.NET)[^].

Also notice both ConnectRetryCount and ConnectRetryInterval in ConnectionString[^]

RajeeshMenoth · Answer 2 · 2015-03-01T20:08:00

Solution 2

Try the following..

1) Automatic reconnect MS Sever SQL connection
2) is it safe to keep database connections open for long time

Posted 1-Mar-15 20:08pm

RajeeshMenoth