Hi
My query works, but when I add the attribute description, I have the following error:
---
Msg 7346, Level 16, State 2, Line 2
Cannot get the data of the row from the OLE DB provider "ADSDSOObject" for linked server "ADSI". Could not convert the data value due to reasons other than sign mismatch or overflow.
---
Query :
SELECT * FROM
OpenQuery(ADSI, 'SELECT
sAMAccountName
,sn
,cn
,givenname
FROM ''LDAP://ou=XXX,ou=Companies,DC=XXXXX,DC=net''
WHERE objectClass = ''User'' AND objectCategory=''person''')
Thanks in advance,
Stever