topic Re: Connect to LDAP using ADsDSOObject in QlikView

Connect to LDAP using ADsDSOObject

qw_johan — Thu, 12 Apr 2018 11:53:51 GMT

I am connecting to LDAP using ADsDSOObject to read information about users. Found a great example by Rob Wunderlich on how to do this.

One problem though, I need to include my own user "Admin" in my connect string (no password needed) to be able to access ALL data.

This is where I have a problem. I've tried to use "User Id=ad\Admin" I get an error saying

ErrorSource: Active Directory, ErrorMsg: An operations error occurred.

CONNECT TO [Provider=ADsDSOObject;User Id=ad\Admin;Data Source=LDAP://ad.mycompany.com:636/DC=ad.mycompany,OU=Users,OU=MyCompany,DC=ad,DC=MyCompany,DC=com;
Mode=Read];

Does anyone know how I can correctly include a username/userid in the connect string ?

Thanks,

Johan

Re: Connect to LDAP using ADsDSOObject

petter — Thu, 12 Apr 2018 12:10:49 GMT

Have you tried this: https://www.connectionstrings.com/active-directory-ole-db-provider/‌ ?

Re: Connect to LDAP using ADsDSOObject

qw_johan — Thu, 12 Apr 2018 13:05:38 GMT

Thanks for your reply Petter.

Unfortunately including User Id=Admin or User Id=ad\admin generates an error when connecting to the active directory. ErrorSource: Active Directory, ErrorMsg: An operations error occurred.

Johan

Re: Connect to LDAP using ADsDSOObject

MarcoWedel — Thu, 12 Apr 2018 20:35:33 GMT

did you try adding

(UserID is YourDomain\YourAccount, Password is YourPassword)

after the end of the connection string?

Re: Connect to LDAP using ADsDSOObject

qw_johan — Fri, 13 Apr 2018 09:22:04 GMT

Yes, I've tried adding it to the end of the connection string but that doesn't help.

As soon as I add "User Id=ad\admin" and reload my app I get an error when it tryies to creat a connection.

According to the guys that are responsible for active directory I don't need a password.