On 7/29/06, Man-wai CHANG <[EMAIL PROTECTED]> wrote:
But remote views should be the way to go for Visual Foxpro. But using a remote view meant using persistent connections. And M$ charges SQL Server (before 2005) users per connection. Kind of a joke...
Remote views, cursoradaptors and SQL Pass-Through all have strong and weak aspects. In most cases, remote views only tie up a connection for a moment, work synchronously, and so a single connection can be shared by all the remote views in an application. It's a rare case where you might want to use a second connection for progressive fetching, multiple SQL statements, asynchronous processing, etc. -- 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 ** 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.