Post reply

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

  • 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

     

  • 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

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply