Judith Barer wrote: > I am playing around with sql server 2005 express and vfp 8.0. I created > three remote views all using the same shared connection. Then I used > two of the views in a form. When I added the third view I got a > connectivity error "connection is busy with results for another command" > So I created a new connection and used the new connection for the third > view and then it worked fine. My question is that I have many tables > and views in my database (at least 30) of which many views may be open > at one time so is there a problem with using many connections? >
Most likely what happened is exactly what it said - data was still being gathered/brought down with the shared connection. Whenever possible, I try to share connections, but some connections simply can't be shared because of the amount of data that could (or potentially could) be retreived. For instance, in McGraw-Hill, I can't share the connection used to retrieve chapter info, as if there are a lot of chapters, the other views will get an "in use" message. -- Vince Teachout Caracal Software www.caracal.net 518-733-9411 _______________________________________________ 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.
