0 Replies Latest reply: Jul 12, 2017 11:34 PM by Priyabrata Das RSS

    Help needed to get data from AD

    Priyabrata Das

      Hi All,

       

      I am trying to connect to AD. The connection is successful but not able to see the database.

      Code :

      OLEDB CONNECT32 TO [Provider=ADsDSOObject;User ID=usename;Encrypt Password=False;Data Source=LDAP://Domain Name.Local;Location=LDAP://Domain Name.Local Mode=Read;Bind Flags=0;ADSI Flag=-2147483648] (XPassword is WcfUUGFMNLYYWUBIUbYGXYIGTBNKTcA);
      A:

      SQL select name, sAMAccountName FROM 'LDAP://Domain Name.Local; WHERE objectCategory='person' AND objectClass = 'User' ;

       

      Error :

       

      Message was edited by: Priyabrata Das