I've had these problems to and solved them this way:

* gcServerdb is the ODBC datasource, a string read from an .ini file

* Example from a the form's Load method:
* CursorSetProp('Buffering',5,'InventorySalesColor')  may not apply to your way of doing things 


If Not Dbused('Maintenance')
	Open Database 'Data\Maintenance' Shared
Endif

If Not Dbused('Inventory')
	Open Database 'Data\Inventory' Shared
Endif
Set Database To Maintenance

* Here's the important stuff !!!!!

If Vartype(lnSql) = 'U' Or Vartype(lnSql) = 'L'
	SQLSetprop(0,'Asynchronous',.F.)
	Public lnSql As Integer
	lnSql = SQLConnect(gcServerDb)
Endif

* End

Set NullDisplay To ''

Try
	Use BusinessNameFromBusinessId Connstring lnSql In 0 Nodata
	Use BusinessLineFromBusinessLineId Connstring lnSql In 0 Nodata

	Use InventorySalesColor Connstring lnSql In 0 Nodata
	
	Use SalesColors Connstring lnSql Nodata In 0
	CursorSetProp('Buffering',5,'SalesColors')
	
	Use Stations Connstring lnSql In 0
	CursorSetProp('Buffering',5,'Stations')

	Use InvoiceTypes Connstring lnSql In 0
	CursorSetProp('Buffering',5,'InvoiceTypes')

... aso

HTH



>I'm converting an application to use remote views to access SQLExpress2005 data.
>I need advice on establishing 'shared' or 'not shared' the connection used by views.
>Now I'm randomly receiving the following error message:
>'Connection myConnection is busy'
>
>TIA
>Bruno