From: Bernard Bout
To: ChengTing Tsai
Visual FoxPro 9 SP2
Databases, Tables and SQL Server
Tuesday, May 19, 2009 6:09:01 AM
This message was rated by:
> > 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.
Anders is right about the resources. You should avoif opening and closing connections.
> 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 ?
That is partly correct. You can reuse it only if you have not closed it.
The CA accepts 3 ways to connect:
1. Connection Handle -
oConn = SQLSTRINGCONNECT(SQLCONNECTIONSTRING)
Then you can refer to this handle - oConn and use it till you close it. If you close it then you have to create a new connection handle before using it.
2, DSN - This is setup on the local computer
3. Connection Strin
For 2 & 3 above I am sure the CA opens and closes it as needed. If you set up the Form to use the connection property of the DE and you specify 2 or 3 (as above) then the connection will be handled by the DE. If you close the form, the connection will be automatically closed.
If you close an open connection manually you cannot use CursorSetProp to recover it. You have to manually open a new connection.
This is what I do:
I use method 1 above - oConn stores my handle and the connection is left open for the complete time the application session is open.
I also use a VFP command
Look it up in the help. It closes idle connections and opens them as needed.
Bottom line is if you use method 1 then you have to create and close the connection.
If you use method 2 & 3 above then the CA or DE will manage the connection open/close.
> I do appreciate your help. Thanks ^^
** If you see someone without a smile, give em one of yours :) **
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