InfoPath Dev

I have a InfoPath form which uses a webservice to post and retrieve data to SQL Server.

Is it possible to use a config file to read the server name? Otherwise would have to recompile for each server, ie Development, Staging and Live.

Any ideas appreciated.

If you're using InfoPath 2007 this would be a perfect opportunity to use the Universal Data Connection, or UDC files. Otherwise, you could try out our deployment tool:http://www.qdabra.com/proddetail.asp?prod=QDeployment

alas InfoPath 2003

You shouldn't have to recompile. You can use a config file in a relative location on your SharePoint site or just add a secondary XML data source to the form template and refer to the values in that.