How to Fix a Common SharePoint 2010 OData Error

Published by on May 4th, 2011

OData capabilities are appearing all over the place in recent Microsoft products like SharePoint Server 2010, Excel 2010 (using SQL PowerPivot), Windows Azure Storage, SQL Server 2008 R2 and others.

According to Microsoft, OData “… applies web technologies such as HTTP, Atom Publishing Protocol (AtomPub) and JSON to provide access to information from a variety of applications, services, and stores.”.

Recently I was working with OData for a Fpweb.net SharePoint Server 2010 hosting client, and encountered the following error:

"Could not load type 
'System.Data.Services.Providers.IDataServiceUpdateProvider' 
from assembly 'System.Data.Services, Version=3.5.0.0, Culture=neutral, 
PublicKeyToken=b77a5c561934e089'."

So what the heck does that mean?!?!
This error indicates that there is a missing assembly (System.Data.Services) on the SharePoint 2010 Web server which is required for processing the OData requests from ListData.svc.

How can I fix this SharePoint Ninja-Style?!?!
Good question, grasshoppa… To remedy this error you will need to install the ADO.Net Data Services Update for .NET Framework 3.5 SP1 (x64).

Important Notes About Installing the Update:

  • Notice that there are different versions for different operating systems.
  • Be aware that the installer will ask you to reboot after the installation completes.

How do I know if I fixed the OData Error?

Browse to http://[yourdomain]/_vti_bin/ListData.svc. If your XML SharePoint data is returned, you’ve done it!

WINNING! As always, please hit me with your questions/comments/success stories in the comments area below!

About Andy Milsark

Andy Milsark has written 43 posts in this blog.

Andy, a proud new daddy, enjoys learning as much as humanly possible about SharePoint, PowerShell, and Private Cloud Automation. When he needs a break from battling SharePoint, he can be found throwing around weights at the local Crossfit gym. Follow Andy on Google+

VN:F [1.9.22_1171]
Rating: 9.5/10 (2 votes cast)

 
  1. May 4th, 2011 at 16:12 | #1

    Great post, Andy!

  2. May 4th, 2011 at 16:13 | #2

    @Derek Watson
    Thank you sir!

  3. June 4th, 2011 at 12:03 | #3

    Cool! That’s a clever way of looinkg at it!

  4. Michael
    June 13th, 2012 at 09:31 | #4

    I have to ask, why does this change “all of a sudden,” I’ve had users running REST queries without an issue and then out of nowhere this error is generated. I haven’t installed any patches or anything.

    Weird.

  5. June 22nd, 2012 at 10:33 | #5

    @Michael
    Michael, I haven’t heard of any specific patch or update that may have broken this recently. Maybe one of your web servers doesn’t have the same patch level as the rest?

  6. December 12th, 2012 at 20:40 | #6

    I’m experiencing an unusual issue. When I try to use the ListData.svc it hangs forever. The browser thinks it’s still downloading, but the progress bar never advances past the half way mark. Have you ever experienced this behavior or do you have any idea how to troubleshoot it?

  7. December 13th, 2012 at 19:06 | #7

    @Dan Kline
    Hi Dan.

    I have not seen this behavior. Have you tried an IISRESET to clear out the webserver’s memory?

  8. Muhammad Ali
    November 15th, 2013 at 03:46 | #8

    Hi

    I have installed, the update, restarted IIS and the machine, still getting the same error. Windows is Standard Server 2008 and .Net framework 3.5 SP1 is installed. Can you suggest something??

  9. June 4th, 2014 at 13:42 | #9

    Do you have any kind of guidance on establishing a blog
    site? I’m really tired of doing the same kind of thing in the office and want something mroe challenging.

  10. June 4th, 2014 at 13:48 | #10

    Ok, 100 % agreee. You have hit the nail on the head completely

  1. May 4th, 2011 at 17:08 | #1

Leave a Reply

Your email address will not be published. Required fields are marked *


× nine = 18

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>