this is the query that i use
'SELECT mail, displayName, sAMAccountName, givenName, sn, cn, userAccountControl
where objectClass = ''User'' order by cn')
and this works fine when i am on the sql server. but if i am on developer machine and use studio management, it gives me this error
An error occurred while preparing the query "SELECT mail, displayName, sAMAccountName, givenName, sn, cn, userAccountControl
where objectClass = 'User' order by cn" for execution against OLE DB provider "ADsDSOObject" for linked server "ADSI".
any help is really appreciate