I am facing problem with data environment. I want to change the default database property which is used by the data environment's connection dinamically. I have added some commands to that connection which are record sourse to some reports. But On some condition i want to change the default database property to some other database which is on the same server to fetch records.
Any help would be highly appreciated.