Data sources

[Jaime]

Hi,

I'm developing some InfoPath forms that submit/request data from primary and
secondary data sources. I would like to know if there is a way to configure
an intermediary layer between the form and the actual data source in such a
way that if the the location of the data source is changed only the
intermediate link should be re-configured, so the change in location is
totally transparent to the form. Something like a Unix/Linux symbolic link.
BTW the functionality is needed so a form can be developed using a local DB,
but after deploying, the DB will reside in a shared network location.

Thanks in advance.

 

[Adam Harding]

Hi

Fairly simple to do this in infopath, go into Tools-Data Connections-Main
Connection and modify

that is all that is needed so no real need for the middle portion

Cheers Adam

 

[Jaime]

That's right, but that change must be done with every form (I have several
forms); using a mid-layer will create an abstraction layer so only one
re-configuration is needed to affect all the forms (which is what I want).

--Jaime

 

[Adam Harding]

Ok i understand

Jaime

Easiest thing to do is to write a web service as the mid layer that
redirects the stuff onto the database. On the plus side then there are
ABSOLUTELY NO LIMITATIONS to what data you can submit onto the database, Memo
fields and the like, email addresses and so on and so forth.

Cheers Adam