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. Thanks for any help- Steve _______________________________________________ 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.
