When using the Data environment designer, the Data Source and the Initial catalog properties on the connection have to be set each time and the ActiveX has to be built and this should be done for each computer if they have to be used as different servers.

Is there a way to avoid this system dependency and make the ActiveX generalized and attach the existing UDL file on that system and make the connection set.