query problem with LDAP connection

• stever50

  Newbie

  Points: 5

  More actions

  March 18, 2008 at 8:13 am

  #184396

  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

• Cyril Carter

  SSC Journeyman

  Points: 86

  More actions

  October 10, 2008 at 8:56 am

  #883472

  Did you get this resolved by any chance? I'm trying to query the 'member' attribute and I get the same exact error that you get.

  I would appreciate any help!