PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEV, WEBDEV e WINDEV Mobile

Inicio | Mensagens recentes | Conecte-se... |  | Português FR
Inicio → WINDEV 2024 → SQL server with OLE DB access, how to reconnect
SQL server with OLE DB access, how to reconnect
Iniciado por Sasha, mar., 16 2017 4:32 PM - Sem resposta
#1
Membro registado
1 mensagem
Publicado em março, 16 2017 - 4:32 PM
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.
→ Voltar para WINDEV 2024