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. ???
Erik Moore
Clientelligence