On Mon, Feb 14, 2011 at 3: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. > > On a PostgreSQL back-end, which I've become very familiar with, the > setting is respected, and the failed connection returns in about 1.5 seconds. > > Does anyone know if / how to make MS SQL Server use this setting, or > something else that get the same effect? > > Although my real code doesn't need a 1 second time out, 30 is too > high since it basically freezes VFP entirely and makes the app > totally un-responsive. --------------------------------
I don't think that the backend is doing anything and this is all VFP settings. Thus it works for backend A but not backend B makes no sense. Been a long time since I did this but this setting is to put VFP at a pause waiting for a long process instead I thought. -- Stephen Russell Sr. Production Systems Programmer CIMSgts 901.246-0159 cell _______________________________________________ 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.
