Last post May 29, 2013 10:53 AM by smirnov
May 29, 2013 09:01 AM|micnie2020|LINK
i try to run:-
sn, mail, manager, userPrincipalName')
i got error:-
Msg 7346, Level 16, State 2, Line 1
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.
If i remove description from the sql, it work fine.
May 29, 2013 10:53 AM|smirnov|LINK
If you use your AD/LDAP management tool, do you see that users from that query (OU=Singapore,OU=.AP...) have description values set? I guess the error might occur when description field is not set. You can try to execute that query (using
(&(objectClass=User)(&(sAMAccountName=xxx)))) against 2 particular accounts who has description set and who didn't and see if this will leads to that error.
Also, you can try to do
SELECT * FROM OpenQuery....
to get all available columns.