I need to set the CommandText of a Connection in the Data Environment at runtime. Basically the Datasource, Username, Password, Initial Catalog are all read in from the registry and may vary depending on the SQL server that the application is running on.
The problem I am having is that when I set the connection string I get an error. I am using "DE1.Conn1.ConnectionString = "Blah Blah Blah...."
Thanks in advance...