How to Fix a Common SharePoint 2010 OData Error

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!

2011-05-04T15:55:34+00:00 May 4th, 2011|

12 Comments

  1. Derek Watson May 4, 2011 at 4:12 pm - Reply

    Great post, Andy!

  2. Andy Milsark May 4, 2011 at 4:13 pm - Reply

    @Derek Watson
    Thank you sir!

  3. […] the original post: How to Fix a Common SharePoint 2010 OData Error Share on bebo Blog this! Bookmark on Delicious Digg this post Recommend on Facebook Share on fark […]

  4. Mircea June 4, 2011 at 12:03 pm - Reply

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

  5. Michael June 13, 2012 at 9:31 am - Reply

    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.

  6. Andy Milsark June 22, 2012 at 10:33 am - Reply

    @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?

  7. Dan Kline December 12, 2012 at 8:40 pm - Reply

    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?

  8. Andy December 13, 2012 at 7:06 pm - Reply

    @Dan Kline
    Hi Dan.

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

  9. Muhammad Ali November 15, 2013 at 3:46 am - Reply

    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??

  10. https://Twitter.com/ June 4, 2014 at 1:42 pm - Reply

    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.

  11. Lowell June 4, 2014 at 1:48 pm - Reply

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

  12. Raja Bhowmick November 27, 2014 at 7:50 am - Reply

    previously http://[yourdomain]/_vti_bin/ListData.svc was working for my server but after installing SharePoint 2010 Administration Toolkit for sharepoint CMIS connector it is not working. Can u tell me what is the problem? or we can’t use both web service.

Leave A Comment