|
| SQL server with OLE DB access, how to reconnect |
| Iniciado por Sasha, 16,mar. 2017 16:32 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
1 mensaje |
|
| Publicado el 16,marzo 2017 - 16:32 |
Greetings everyone,
is there an easy way to make WD try reconnect when a physical connection to a Db is lost?
I have next situation. I'm using OLEDB to connect to an SQL server db. When a connection problem occurs, WD throws an exception, which I'm able to trap. But, when I try to close the connection (declared by programming) , and reopen it, even if there's still no connection HOpenConnection will return True !? It seems that this approach won’t work.
Now, I did try declaring a new connection, in which case, HopenConnection would act predictably (it would try opening, and after a while return False value). Although it could work, I would like to avoid this approach, because the code within whole application relies upon using initial connection defined as a global object. |
| |
| |
| | | |
|
| | | | |
| | |
|