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

• • Reply
  micnie2020

  Member

  119 Points

  748 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

• • Reply
  smirnov

  All-Star

  35159 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.