https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/54387.aspxFri, 30 Apr 2010 09:05:52 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:54387Prasad0https://www.infopathdev.com:443/forums/thread/54387.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=54387<p>Convert your data connection to UDCX file.</p>https://www.infopathdev.com:443/forums/thread/54362.aspxThu, 29 Apr 2010 16:57:01 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:54362bryanstrader0https://www.infopathdev.com:443/forums/thread/54362.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=54362<p>Is there a way to override the connection string of a <u>secondary</u> data source? Here is my situation: I have a few different secondary data sources in my form. Each time I roll from development to production I have to change each secondary data source to look at the other database. Of course once you switch database, you have to re-link your tables for the datasource. This can be painful if you have alot of joins. Is there a way to control which database all secondary datasources use with one setting? Thanks in advance for any help here. Ideally I&#39;d like to be able to override the connection of these data sources on my Form Load event.</p> <p>&nbsp;</p> <p>Bryan </p>