Query Active Directory LDAP - 'Cannot fetch row from OLE DB provider'

• cathryn.crane

  SSC Veteran

  Points: 203

  More actions

  February 10, 2020 at 7:00 pm

  #3724485

  Hi Everyone

  I've got a strange issue that I think is an environment issue.

  I can query our Stage environment and return records with our ADSI linked server.

  I have the exact same linked server properties in our Dev environment which is a different server and I get this error.

  I've tried to google the issue and I've verified that the proper dlls are on this server and when I do a test connection, it's successful.

  I'm using the same login information and have tried to query even just 1 record even though we only return a total of 359 for the query I need to run.

  So the error seems to be misleading.

  Has anyone else had this or can help with this issue?

  Thank you

  Cathryn

   

• Chris Harshman

  SSC-Forever

  Points: 42192

  More actions

  February 10, 2020 at 9:03 pm

  #3724509

  If you are sure your LDAP connection string is right, could it be possible you are hitting the 1000 row limit for a resultset?  That same error is used when there are too many records in the results.

  https://docs.microsoft.com/en-us/windows/win32/adsi/retrieving-large-results-sets