Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Duplicate losing SQL Connection
Message
De
20/02/2018 07:28:46
 
 
À
19/02/2018 16:09:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01658232
Message ID:
01658263
Vues:
54
Hi!

I've had the same Problem, bud with remoreviews.

The solution was in the errorhandler, if this error occurs i test if the connection to the Server is still broken and then wait a second and test it again (after some cycles, i present the User a nice Message "Connecton was broken, try to reconnect...".)
If then the server / Connection is back again you have to set each sql Handle idleDisconnect:
	asqlhandles(laSqlhndls)
	
	for each m.lnOdbchdbc IN m.laSqlhndls foxobject 
		sqlIdleDisconnect(m.lnOdbchdbc)
	endfor
so the Problems disapear.

To test my solution i simply disconnected the Cable, or switched off the Networkadapter in the System tray.
This also worke's with temporary broken WLAN Connections.

HTH
Jörg Schneider
Joerg.Schneider@SMARTCRM.de
SMARTCRM CRM powered by MS Visual FoxPro
SMARTCRM GmbH
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform