Thanks Richard - I'm going to take a look at that link right now. -K-
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Richard Kaye Sent: Friday, July 24, 2015 4:42 PM To: [email protected] Subject: RE: Connecting to SQL via VFP w/Failover... In theory, any valid option supported by the database driver you are using (I assume ODBC in this case) can be used with SQLSTRINGCONNECT. This site is a good reference resource for all things connection string: https://www.connectionstrings.com/ -- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Friday, July 24, 2015 4:35 PM To: [email protected] Subject: RE: Connecting to SQL via VFP w/Failover... Charlie, Honestly - I didn't even know that was an option that could be used in the Connection string. I was continuing to look at the VFP online help right now - but, so far was not able to track down all the viable options that can be sent in the Connection string. Adding the Failover in the connection string sounds like the Perfect solution. Can you point me to anything in the online help to get more info about this option and the connection string in general? Thanks, -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Charlie Sent: Friday, July 24, 2015 4:14 PM To: [email protected] Subject: Re: Connecting to SQL via VFP w/Failover... On 7/24/2015 2:59 PM, Kurt Wendt wrote: Good lord, all that text.... Technically, a FAILOVER architecture does not require special processing on the "end point" (aka client). Anyway, did you use the ";Failover Partner=PartnerServerName" clause in your SQL connect string? -Charlie > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Stephen Russell > Sent: Friday, July 24, 2015 2:27 PM > To: [email protected] > Subject: Re: Connecting to SQL via VFP w/Failover... > > [much snippage.....] [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/80838f1ca795b14ea1af48659f35166f1ce...@drexch02.corp.globetax.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.
