>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.