Data sources

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jaime - 06 Mar 2006 14:22 GMT

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.

Reply to this Message

Adam Harding - 06 Mar 2006 15:26 GMT

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> Thanks in advance.

Reply to this Message

Jaime - 06 Mar 2006 15:38 GMT

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

> Hi
>
[quoted text clipped - 17 lines]
> >
> > Thanks in advance.

Reply to this Message

Adam Harding - 08 Mar 2006 10:58 GMT

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

> 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
[quoted text clipped - 23 lines]
> > >
> > > Thanks in advance.

Reply to this Message