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!

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

About Fpweb.net Crew

Our business is centered on bringing enterprise-class strategy, support, and security to your hosted or managed platforms no matter where you choose to deploy your environment. We specialize in providing managed services, cyber security, and expert, USA-based, 24/7 Absolute Support® on-premises, or in any cloud.
This entry was posted in SharePoint Tips & Tricks and tagged , , , , , , , , . Bookmark the permalink.

12 Responses to How to Fix a Common SharePoint 2010 OData Error

  1. Derek Watson says:

    Great post, Andy!

  2. Pingback: How to Fix a Common SharePoint 2010 OData Error | Translogistics

  3. Mircea says:

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

  4. Michael says:

    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. Andy Milsark says:

    @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. Dan Kline says:

    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. Andy says:

    @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 says:

    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. 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. Lowell says:

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

  11. Raja Bhowmick says:

    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 Reply

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

Let's make sure you're human first: *