Welcome! Log In Create A New Profile

Advanced

sql server (MSSQL ) loosing connection

Posted by wduser 
sql server (MSSQL ) loosing connection
November 02, 2018 09:45AM
Has anyone a way to atomatically reconnect after loosing connection I have seen hreconnect() but this does not seem to do anything with mssql native acces

thanks



Edited 1 time(s). Last edit at 11/02/2018 09:45AM by wduser.
Tom T
Re: sql server (MSSQL ) loosing connection
November 08, 2018 11:25AM
Hi,

Just use HopenConnection() in my opinion.
Re: sql server (MSSQL ) loosing connection
November 09, 2018 08:30AM
Hi

The first problem is . How do I detect that it has lost connection ? It might be a stupit question but it is a real problem for me. I work with the native connector for MSSQL.

The problem in more detail:

1 Howe do I know the connection is lost ?
2 Then reconnect. Declaring the connection. Then H open connection.
3 They would like to return to the position in the screen where they were when the connection failed.

Anyone an Idea how to do this. Starting with the detection of the connection loss ?

Thanks
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: