InfoPath Dev

Hello everybody!

Another question form my side:

I designed my form with InfoPath 2007 and in the preview everything worked fine. There are 4 data sources included in my form where I access our MSSql 2005 DB to populate the dropdownlists.

The problem is when I deploy it on MOSS 2007 and I create a new document out from the form library (I have a library for the form). There is always the error:

cannot access some data sources

These are only the data sources that are included in the form. I have another 2 webservices that are included in the form which retrieve also data from the database, these work fine. When I exclude the data sources from the form everything works fine!

My interim solution is to fill it by hand with item lists but this isn't very satisfying.

Can somebody help me? Maybe another of you has encountered the same error or problem!

Best Regards,
Martin

Hi Martin!
Did you convert the data connections to UDCs? You'll need to configure these correctly to use SSO or some other form of authentication. The double hope scenario - Browser to Form Server to SQL is somewhat challenging to set up but it can be done.

Ok this worked fine.

I've created a Data Connection Library and now everything works fine!

Thanks for the help!

Regards
Martin