I alone help unit development winform management procedures, in the time away from the computer more than an hour, again will quote "connection error, signal lights time to" error box, return to normal after closing, excuse me why ah?
Ali cloud SQL library!
The other in a program with access to the library every 2 minutes timer, still have a connection error!
Several management program has this kind of phenomenon, continuous operation is normal!

CodePudding user response:

Connection error, signal lights time to

Find the first, where is the exception thrown, then on to ask,

Anyway, Microsoft itself is not going to throw what "on time" this tip for you

CodePudding user response:

Normal writing should be necessary to connect the SERVER, usually break line, and not always on line

CodePudding user response:

Is such a scene, open a data query, do not close this window, then hang up above, when a mouse click on the interface, no response after a few seconds, the pop-up error "in a transport level error occurred while receiving results from the server, (the provider: TCP provider, error: 0 - a semaphore timeout has to)", return to normal after close the popup window, can refresh the query!

W7 and w10, different machine, in this case!

CodePudding user response:

The routing should be cut off for a long time without any communication TCP connection

We speak, of course, the data communication is instantaneous, so as the 2nd floor, conn should not use the open forever, only used in the open, you should immediately close him after operation

CodePudding user response:

Tcp has a keepalive, if you don't do any communication for a long time, whether it's essentially a or your local Tcp communications will shut down, if you want to keep long connection that needs to be regularly send packets to the database

CodePudding user response:

Are you still in the application of the scene, that is, when the data query open Connect, query immediately shut down, when the query again to open, open is close, add an event, a movement to query, when it is only when the query link will not appear this kind of circumstance, you this kind of situation, one is your unit have routing time, shaking hands is similar Keppalive TCP protocol, then there is cloud SQL there are limits, he certainly won't let you keep no data connection for a long time,