InfoPath Dev

Hi,
Can we declare secondery data connections dynamically.
I have a lot of lookup tables from database.
I have a DB instance in a station in development environment, and a different instance in a station in the customer environment.
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.
Each time in the customer i have to change all the secendary cinnections.

Hi erezl,
You can change your query string dynamically to get values from different tables.
I dint try but check if you can change the connection string.
ADOAdapterObject oAdapter =(ADOAdapterObject) thisXDocument.DataAdapters["ConnectioName"];
oAdapter.Command = string.Format(""Select * from xyz");
oAdapter.Connection = "Connection String";
oAdapter.Query();

Agni
InfoPath Dev India