Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

"Data provider or other service returned an E_FAIL status"

  Asked By: Umesh    Date: Nov 14    Category: Sharepoint    Views: 1450

I got a problem here with something that works smoothly with everthing else
I did.
I am making the simplest possible query to the SPS database and i get the
error "Data provider or other service returned an E_FAIL status" when I try
to "movenext"

here's the code:

sql="select ""DAV:href"",
""DAV:displayname"",""urn:schemas-microsoft-com:office:office#Topic"" "
sql=sql & " From scope('DEEP TRAVERSAL OF """ & strWorkspaceUrl &
"/documents""')"
adoRecordset1.CursorLocation = 3 'adUseClient
adoRecordset1.Open sql, ADOConnection, 3, 3
While Not adoRecordset1.EOF
Debug.Print adoRecordset1.Fields("DAV:href")
adoRecordset1.MoveNext
Wend

I get the first record but when i try the movenext i get the error.
if i remove ""urn:schemas-microsoft-com:office:office#Topic"" from the
query, everything is fine. but guess what? i have to have that property!
only way i can think of a workaround is removeing the property from the
query, creating a knowledgedocumnet object and in the loop getting each
document from the query into the new object and ask it it's properties.

any other ideas out there?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on "Data provider or other service returned an E_FAIL status" Or get search suggestion and latest updates.




Tagged: