InfoPath Dev

Is there anyway to prompt a user to select a database to connect to?

What I am wanting to do is give the user the option to connect to either a local access mdb or a db server such as SQLServer or Oracle. I would like it if the user was given a prompt that would have the avaliable data sources in a combo box that they can select. The schemas for the datasources would be identical. Users have the option to take with them into the field a subset of data contained in an access mdb. Subsequently when they are at the home office they could connect to the database server on the LAN if desired.

Thanks

I think you could do it but you would have to create seperate data connections for DB type. Then you would have to do some trickery to call the correct data source either through code or rules based upon the combobox selection. Personally, I think that would be a less scaleable and maintainable solution. This sounds a little repetitive to some of my previous posts, but if you have the ability using a webservice would be a nice clean way of doing what you are talking about. Then all you need to do is add a parameter to your webservice that indicates what type of data connection you wish to make. Then your InfoPath form only has to make one data connection and lets the webservice push or pull data into the selected data source.