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


Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform