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'