>>Hi there.
>>
>>I am facing a problem using Cursor Adapter class.
>>
>>Here is the detail
>>
>>1. I open the CA in the Init event of the Form
>>2. I fill the cursor in the CA Init event. Type ODBC and The connection is a global connection created at the beggining of the app.
>>
>>There is 8 forms with one CA each. So far I've been able to have all of them open, but some time i got an err saying that the connection is bussy.
>>
>>any ideas why and how to fix this??
>>
>>this is the connection snippet
>>
>>

>>	lcConnStr    = "Driver=SQL Server;Server=" + lcSqlServer + ";DATABASE=" + lcSqlDB + ";uid=" + lcSqlUser + ";pwd=" + ;
>>                                lsDecript(lcSqlPass,lcSqlUser)
>>	SQLSETPROP(0,"DispLogin",3)
>>	SQLSETPROP(0,"DispWarnings",.F.)
>>	lnConnection = SQLSTRINGCONNECT(lcConnStr,.t.)
>>

>
>Do you want all of them to re-use the same connection? I would rather use one connection per each and close as soon as finished.

Well, since i am a newbie on this. I have the approach i use before with remote views. Also I do not know the performance issue if i open a connection per every CA, if there is any. is it?

or it is the best way to do it? open the connection on the init , close it on the destroy?

TIA