Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: ChengTing Tsai
  Where is ChengTing Tsai?
 Kaohsiung
 Taiwan
 ChengTing Tsai
 To: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Connection
Thread ID: 228313 Message ID: 228447 # Views: 3 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, May 19, 2009 1:34:16 AM         
   


> Keeping a connection open isn't in itself a waste of resources; creating a new connction for every call to the server is not recommended.
> In CA you have oConn.Open and oConn.Close.
>

To Anders
Thanks for your reply.
Please explain more about "In CA you have oConn.Open and oConn.Close."
Is it meaning that I can control the connection open or close by myself?
I am confused it.

If I want to avoid to waste resource,I should reuse the connection.
EX: Use CorsorGetProp to get connecttion I create before.
Is my thinking correct ?

I do appreciate your help. Thanks ^^

ENTIRE THREAD

Connection Posted by ChengTing Tsai @ 5/18/2009 9:38:45 AM
RE: Connection Posted by Anders Altberg @ 5/18/2009 9:48:15 AM
RE: Connection Posted by ChengTing Tsai @ 5/19/2009 1:34:16 AM
RE: Connection Posted by Bernard Bout @ 5/19/2009 6:09:01 AM
RE: Connection Posted by ChengTing Tsai @ 5/19/2009 10:05:02 AM