LDAP description raise err 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[Answered]RSS
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.
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.
Member
124 Points
793 Posts
LDAP description raise err Cannot get the data of the row from the OLE DB provider "ADSDSOObject"...
May 29, 2013 09:01 AM|micnie2020|LINK
Hi All,
i try to run:-
SELECT sAMAccountName='av\'+sAMAccountName,description,department,givenName, LE = 'ASG', sn,mail, manager=Replace(Replace(SUBSTRING(manager,1,CHARINDEX(',',manager,0)-1),'CN=',''),' ','.'), userPrincipalName
FROM OpenQuery(ADSI, '<LDAP://av.com/OU=Users,OU=Singapore,OU=.AP,DC=av,DC=com>;(&(objectClass=User)(&(objectCategory=Person)));sAMAccountName,description,department,givenName, 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.
Please advise.
Regards,
Micheale
All-Star
35149 Points
9075 Posts
Re: LDAP description raise err Cannot get the data of the row from the OLE DB provider "ADSDSOObj...
May 29, 2013 10:53 AM|smirnov|LINK
Micheale,
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.