That's why I suggested changing the connection itself, not the view. You just change the database and/or server the connection points to and all the views are then pointing to that database/server.

>A view's ConnectName property is readonly. The only way it can be changed is by redefining the view.
>
>
>>I would create a single connection and just change it using DBSETPROP to point to different data as needed.
>>
>>>Hi,
>>>
>>>I have three sets of data: testing, training, and live, so I created three connections (Testing, Training, and Live) in my project.
>>>What is the best way to organize remote views to have ability to switch between data sources?
>>>
>>>1. For each table on backend create three remote views in the project. For example: v_test_reasons, v_train_reasons, v_live_reasons and choose one of them like this
>>>
>>>cSource = "test"
>>>Use ("v_"+cSource+"_reasons")
>>>
>>>2. ???