Data Environment .Connectionstring ?

[cj92713696]

Does anyone know how to change the .Connectionstring property of the Data Environment through VB code?

I have tried to change it directly by doing a DE.ConnectionObj.Connectionstring = &quot;<connection string>&quot; but I get a new .Connectionstring to the effect of the old string w/a value appended &quot;EXTENDED&quot; and the new connection string.

Is there an example someone would be willing to post?

Thanks,
CJ

 

[rdeleon]

Don't know if you still needed help on this, but I set the connection properties of the data environment with the following code:

deName.cnName.Properties(&quot;Data Source&quot.Value = &quot;your value&quot;
deName.cnName.Properties(&quot;Initial Catalog&quot.Value = &quot;new value&quot;
etc...