SQL Database Connection

[Darkness84]

I am working on an application that maintains an open connection to an sql database. I also have a timer that checks to see if the connection has closed and if so, it tries to re-opens the connection. This is working fine at the moment as my application and the database are running on the same computer. However this application will eventually run on a different computer to where the database will be. What I would like to know is if for some reason the connection from the computer running the application and the computer with the database were to become disconnected, would my application view this as the connection being closed?

[coolestCoder]

Darkness84 wrote:

I am working on an application that maintains an open connection to an sql database

First of all, I would like to know the conditions under which you need an open connection to the database (always) ? I think you can open the connection just at the time of your query execution. what is the problem in this kind of scenario ? Persisting database connections will load your database server. I dont think that this is desirable.

---

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

---

coolestCoder

[Darkness84]

I am using SqlDependency so that my application will respond immediately to changes in the database and thus i need the connection to be open.

[coolestCoder]

Hi, I dont know much about the SqlDependency, here[^] is an article on CP, which specifies (at the last) that the connection need not be open to recieve change event. Will this solve your problem ?

---

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

---

coolestCoder

[Darkness84]

Not sure, but I'll have a read. Thanks.