There's a ConnectBusy property of the connection object. I'm not sure if it's going to let you know exactly what it's doing as Stephen mentions. And there are a whole bunch of options about batch processing and how many rows to retrieve and so on. SQLMORERESULTS() might also be helpful.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Friday, July 24, 2015 4:33 PM To: [email protected] Subject: RE: Connecting to SQL via VFP w/Failover... Stephen - I've been reviewing a Lot of the VFP Online documentation on this SQL stuff today - and just looked again now - and didn't come across any .State value. -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Friday, July 24, 2015 4:04 PM To: [email protected] Subject: Re: Connecting to SQL via VFP w/Failover... On Fri, Jul 24, 2015 at 1:59 PM, Kurt Wendt <[email protected]> wrote: > Stephen - I really DO Agree with you. What you describe IS the Proper > way to handle failover. > > And - FYI - to answer your one question - the Disaster Recovery Server > is being Mirrored constantly. > > --------------- Then you do not have to do much from VFP outside of a try catch wrapper around the submission of a statement to the back end. Been a long time since I did VFP SQLConnection. Can you get a .State value and if the answer is an enum that gives you the value for Open, Closed, Active, Broken, or Executing? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/bn4pr10mb0913a99db8a57b0b12a47b10d2...@bn4pr10mb0913.namprd10.prod.outlook.com ** 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.
