Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am very new to using LDAP queries. We have setup LDAP connection as below:
OLEDB CONNECT32 TO [Provider=ADsDSOObject;User ID="cn=user,ou=serviceaccounts,ou=ops,ou=abc,ou=xyz,ou=ad,dc=xyz,dc=com";Encrypt Password=False;Data Source="LDAP://directoryservices.xyz.com:636/Base DN: ou=XYZ,ou=XYZInternalView,ou=XYZViews";Mode=Read;Bind Flags=0;ADSI Flag=-2147483648] (XPassword is DDIeLIBIEBJOXXJOELMAFAREEZdeGZRMRBTB);
I am just getting started and tried the below script:
LOAD *;
SQL
SELECT sn FROM 'LDAP://directoryservices.xyz.com:636/Base DN: ou=XYZ,ou=XYZInternalView,ou=XYZViews' WHERE objectCategory='person';
I am receiving the below error:
Can someone help me with the query please?
TIA
Your best bet is going to be going to someone on the LDAP team to have them give you the correct information to access things, they are going to be the experts, not us.
That being said, I want to clarify something as well, what you are trying to do is actually pull data from your LDAP via the Load Script and NOT configure a Directory Service DSP? Either way, I would expect your LDAP admins are the guys to best help you here.
Regards,
Brett