Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

retrieve LDAP info based on user login

Avatar of kalittaair
kalittaair asked on
Oracle DatabaseApplication ServersDB Dev Tools
7 Comments1 Solution932 ViewsLast Modified:
I am trying to retrieve the name and employeeID from LDAP with the users login name. If I hard code the the samAccountName with my user login in name, rsmith, I can retrieve the info I need. How do I replace hard coding 'rsmith' with my  network login name.

I am using this in Adobe LiveCycle Designer 8.0. In DataView, I selected the "New Data Connection". I then selected the OLEDB Database option. In the connection string under the Provider tab I selected "OLE DB Provider for Microsoft Directory Services" and chose the "SQL Query" option. When a user opens the form, some fields on the form would be filled in with data from LDAP based on their user login.

SELECT name, employeeID FROM 'LDAP://DC=MyServerName,DC=COM' where samAccountName='rsmith'
ASKER CERTIFIED SOLUTION
Avatar of crawfordits
crawfordits

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers