I've had similar requirements with a common DBC and various SQL server db's and have used the following approach:

* Ive got a Main form with an attached Menu, this code is from one of the menu options procedures.

IF oMainMenuForm.cServerDB = oMainMenuForm.aServerDB(2) OR oMainMenuForm.cServerDB = ''
	oMainMenuForm.cServerDB = oMainMenuForm.aServerDB(1)

	TRY     && Close any open forms
		oMainMenuForm.oInvoices = NULL
	CATCH TO oException
	ENDTRY

	TRY
		oMainMenuForm.oReservations = NULL
	CATCH TO oException
	ENDTRY

	CLOSE TABLES ALL

	IF TYPE('lnSql') = 'N' AND lnSql > 0
		SQLDISCONNECT(0)
		RELEASE lnSql
	ENDIF

	CLOSE DATABASES ALL
	PUBLIC lnSql

	lnSql = SQLCONNECT(oMainMenuForm.aServerDB(1),.T.)
	OPEN DATABASE SOS   && Common DBC wtih remote views

	IF lnSql < 1
		oErrors.ErrorMsg()
	ENDIF
	oMainMenuForm.ACTIVATE
ENDIF

Now you start opening RV's in the form's load event with Use...Connstring lnSql

HTH