Qdabra Database Accelerator

Re: ADUserInfo key not working.

ErnestoM — Thu, 24 Jul 2008 22:25:22 GMT

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

Re: ADUserInfo key not working.

pmcdou2 — Thu, 24 Jul 2008 19:49:31 GMT

Hi Ernesto.

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

Re: ADUserInfo key not working.

ErnestoM — Thu, 24 Jul 2008 19:10:08 GMT

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

Re: ADUserInfo key not working.

pmcdou2 — Thu, 24 Jul 2008 18:57:18 GMT

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.

Re: ADUserInfo key not working.

ErnestoM — Thu, 24 Jul 2008 16:59:52 GMT

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" ?>

- <ArrayOfADProp xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://qdabra.com/webservices/">

- <ADProp>

<Key>objectClass</Key>

</ADProp>

- <ADProp>

<Value>Ernesto Machado</Value>

</ADProp>

- <ADProp>

<Value>Machado</Value>

</ADProp>

- <ADProp>

</ADProp>

etc...

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

Re: ADUserInfo key not working.

Hilary Stoupa — Thu, 24 Jul 2008 16:47:28 GMT

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...

Re: ADUserInfo key not working.

pmcdou2 — Thu, 24 Jul 2008 16:11:43 GMT

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" ?>

Re: ADUserInfo key not working.

Jim Cantwell — Thu, 24 Jul 2008 15:51:40 GMT

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

Re: ADUserInfo key not working.

Hilary Stoupa — Thu, 24 Jul 2008 15:44:54 GMT

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.

ADUserInfo key not working.

pmcdou2 — Thu, 24 Jul 2008 14:10:03 GMT

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.