The VFP Help file says: "The ConnectTimeOut option can be set only at the Visual FoxPro level and has no equivalent at the connection level. You can set all other options at either the connection or the Visual FoxPro level. Each option set at the Visual FoxPro level serves as a default value for subsequent connections."
I'll be damned if I have any clue what the hell they mean. "foxpro level"? "connection level"? WTF?!??! > -----Original Message----- > From: [email protected] [mailto:profoxtech- > [email protected]] On Behalf Of Ted Roche > Sent: Tuesday, February 15, 2011 12:03 AM > To: [email protected] > Subject: Re: ConnectTimeOut not respected by Microsoft SQL Server for > initial connection? > > On Mon, Feb 14, 2011 at 4:54 PM, Steve Ellenoff <[email protected]> > 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 > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[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.
