From: Anders Altberg
To: ChengTing Tsai
Visual FoxPro 9 SP2
Databases, Tables and SQL Server
Monday, May 18, 2009 9:48:15 AM
This message was rated by:
> Hi VFP experts
> I read Bernard's CA article.
> I was wondering if someone can explain the connection manager in CA.
> In SPT, After create a connection by Sqlstringconnect(),the desiger should use sqldisconnect() to disconnect the connection by myself.
> The purpose is avoid to waste resource in SQL Server.
> In CA,the desiger doesn't disconnect the connection. If designer disconnect the connection, the CA will happen error.
> I am curious How CA handle the connection. When CA disconnect the connection.
> Or the designer can ignore it. CA will handle it automatically.
> Thanks in advance.
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.
Posted by ChengTing Tsai @ 5/18/2009 9:38:45 AM
Posted by Anders Altberg @ 5/18/2009 9:48:15 AM
Posted by ChengTing Tsai @ 5/19/2009 1:34:16 AM
Posted by Bernard Bout @ 5/19/2009 6:09:01 AM
Posted by ChengTing Tsai @ 5/19/2009 10:05:02 AM