On Mon, Feb 14, 2011 at 4:54 PM, Steve Ellenoff <sellen...@pinmame.com> wrote: > If I issue SQLSETPROP(0,"ConnectTimeOut",1) to set the VFP global > time out to 1 second, and then issue an SQLConnect() against an MS > SQL Server back-end, it does not respect the 1 second time-out if the > server cannot connect. Instead it takes about 30 seconds before it > returns the appropriate -1 value for the handle.
It's possible that the server only accepts a range of reasonable timeout settings, and won't respond if you set it outside of that range. You might want to use SQLGETPROP to confirm the setting "took" and try it with settings of 5 seconds or 10 seconds to see if you get different behavior. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/aanlktimkgjuotz1u1perbwwe6hpkljwrxswkvsyjr...@mail.gmail.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.
