Thanks Mike, I'll give that a try...
Alec Gagne Crimestar Corporation San Jose, California, USA -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Mike Copeland Sent: Wednesday, September 25, 2013 12:19 PM To: [email protected] Subject: Re: Broken Connection and Remote Views There are probably better ways to do it, but I use nResult=SQLEXEC(datahandle,'SELECT @@identity') If nResult is 0 then I just assume that there is a problem and proceed to disconnect, throw away the old handle, and then reconnect. If that fails, then bail out. "Select @@identity" has a very low footprint, returning nothing and only useful to see if the communication link is still valid (as far as I know.) Some Fox error codes to look for would be 1526, 1466, and 2006. I've never used views, but in my opinion using views with SQL is not recommended. I just fetch whatever data I need from the server and the connection is only needed for that data transmission. After that brief communication, nothing is assumed and the next communication has to stand on its own. I run the above "Select @@identity" before each request for data. Yeah, additional overhead, but it's quick and ensures that the connection is still valid. Mike Copeland -------- Original Message -------- Subject: Broken Connection and Remote Views From: <[email protected]> To: [email protected] Date: 9/25/2013 1:47 PM > > IF, when a connection to SQL Server breaks, (CREATE CONNECTION myconn > CONNSTRING "blah, blah, blah") due to a network interruption or > timeout by the OS, etc. etc. ... all the views based on that > connection will stop working. Does anyone out there have a solid way > to test for the status of a connection (other than to attempt a query > and trapping for a timeout error) to make sure the connection is still good? > > My thought here is to test for the connection status and if broken, > reconnect and rebuild the views that are based on it. > > Thanks > > Alec Gagne > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
