Change the ConnectionString property. The trick is to do it before the data environment opens itself. One place to do it is a Public Sub Main in a standard module (and setting the startup object to Sub Main).

>Hai all,
> Does any one know how to give connection dynamically in dataenvironment.