InfoPath Dev

Hello,

I set up the secondary data connection according to the Getting Started docs but neither the email or the Logged-In AD user info is showing up in the fields.  I've saved the form after making the new changes for these fields and re-attached it to the catalog.  All else is working, now, form is submitting to DB and shredded properly with the nested tables.

Any help would be greatly appreciated!  Thank you!
Phil.

Hi, Phil:

Have you tried dragging the entire group from the secondary data connection somewhere on your form (doesn't matter if it's ugly, you can delete later, or you can add another view for debugging) just to make sure it is bringing back data? That also helps you know the correct spelling, capitalization, etc. for the keys.

Make sure you are using an upper-case K in Key="cn".

THanks Jim and Hilary.

The spelling is right for Key.  WHen I go to the AD webservice (http://servername/QdabraWebService/ADUserInfo.asmx/GetMyInfo) and Invoke, I get the following...

I did not get back any AD or LDAP results just this.  My domain name is XYZ_HODC but in tweb.config, it was just HODC in 2 places. I changed it to XYZ_HODC but nothing happens.

 Hilary, I'm not exactly sure what you mean by dropping the secondary group to the form.  Do you mean you want me to drag and drop the repeating group with Value and Key to the form and edit their rules?

 Thanks again for the help!

   <?xml version="1.0" encoding="utf-8" ?>

Sorry -- I should have been more clear. I had meant for you to create a secondary data connection to GetMyInfo that automatically runs the query when the form opens, then add a repeating table to your form with fields connected to Value and Key.... that way you can see if you are getting data, and what data you are getting...

We have the LDAP test tool to verify that all your settings are correct. You can find it here: http://www.infopathdev.com/files/folders/misc/entry30201.aspx

For reference, when I run the GetMyInfo method from http://<localmachine>/qdabrawebservice/ADUserInfo.asmx?op=GetMyInfo, I get this:

<?xml version="1.0" encoding="utf-8" ?>

etc...

It looks like you're not getting back a full response from AD.

Thanks Ernesto and Hilary.

 I used the LDAP tool and got back all the correct information. But when I run the GetMyInfo, I don't.  Thew web.config file has the proper ldap://dc=ABC,dc=XYZ,dc=company,dc=com

I also added the repeating table and connected the field to the GetMyInfo data connection but I still don't get anything in the form.  Could this be a security related issue with web service?

Thank you!

Phil.

Are you using XP? There is a known issue with XP the workaround is explained here: http://www.infopathdev.com/files/folders/installation_and_setup/entry30050.aspx

Hi Ernesto.

Eureka!  That was it!  Thank you for your help!

Great! Note that if you later reinstall DBXL you'll need to carry out these steps again.