https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17036.aspxWed, 28 Sep 2005 15:35:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17036Agni Jonnalagadda0https://www.infopathdev.com:443/forums/thread/17036.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17036Hi erezl, <br />You can change your query string dynamically to get values from different tables. <br />I dint try but check if you can change the connection string.<br />ADOAdapterObject oAdapter =(ADOAdapterObject) thisXDocument.DataAdapters["ConnectioName"];<br />oAdapter.Command = string.Format(""Select * from xyz");<br />oAdapter.Connection = "Connection String";<br />oAdapter.Query();<br /><br />Agni<br />InfoPath Dev Indiahttps://www.infopathdev.com:443/forums/thread/16741.aspxThu, 22 Sep 2005 08:38:26 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16741erezl0https://www.infopathdev.com:443/forums/thread/16741.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16741Hi,<br />Can we declare secondery data connections dynamically.<br />I have a lot of lookup tables from database.<br />I have a DB instance in a station in development environment, and a different instance in a station in the customer environment.<br />Can I get the relevant station (data source) based on configfile, or can I change a single point of code to effect the connection definition? Can i use odbc connection, instead. Although i saw that the inifopath takes all the defintions including data source and station.<br />Each time in the customer i have to change all the secendary cinnections.