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?
Thanks Judith Barer Star-K Kosher Certification 122 Slade Ave Baltimore, MD 21208 410 484 4110 Fax 410 653 9293 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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.
