none
Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked server

    Question

  • Hi

     

    I run following query in sql server 2005

    select * FROM         OPENQUERY(collegedc01,
                          'select samAccountName from ''LDAP://collegedc01/ou=students,dc=mycollege,dc=local''
    where objectclass = ''user'' and objectcategory=''person''') ;

    I got 17500 records

    When I run same script in sql server 2008 64 bit  I got the error message

    Msg 7330, Level 16, State 2, Line 1
    Cannot fetch a row from OLE DB provider "ADSDSOObject" for linked server "collegedc01"

    Then I run the following query in sql server 2008 and it is returning result without any error

    select top 17401 * FROM         OPENQUERY(collegedc01,
                          'select samAccountName from ''LDAP://collegedc01/ou=students,dc=mycollege,dc=local''
    where objectclass = ''user'' and objectcategory=''person''') ;

    Maximum I can use 17401 without error. If I tried to use any value more than 17401 or without top clause, I am receiving error messgae.

    I filter out 17401 record using different method and analyed missing records but could not find any different

    Please advise

    Thanks

    Friday, September 24, 2010 10:02 AM

Answers

All replies