Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Duplicate losing SQL Connection
Message
From
20/02/2018 07:28:46
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01658232
Message ID:
01658263
Views:
53
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform