.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

WCF Data Service to Sharepoint returns items on my machine but not on server

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :ASP.Net

In my ASP.NET 4.0 webapplication I have added a reference to our Sharepoint server. 

I then present some items using

      Dim Context As New Data.SharePoint.DataITDataContext(New Uri("http://sp01/data/_vti_bin/listdata.svc"))
        Context.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials
        ASPxGridView1.DataSource = Context.Dokumentation.Where(Function(Item) Item.KundNr = customer.CustomerID).ToList

While running it locally on my development machine (Using Visual Studio 2010) everything works. But as soon as I publish it to the IIS, which happens to be the SharePoint server, I no longer see any records. No exception is thrown or anything, I just do'nt get any data.

Any ideas on why?

      Dim Context As New Data.SharePoint.DataITDataContext(New Uri("http://sp01/data/_vti_bin/listdata.svc"))
        Context.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials

View Complete Post

More Related Resource Links

Server call client machine and pick data from client service.


HI All,

Does anyone have any opinions over the best ways to connect a server to client service over internet to get data on server website.

If you have any idea and solution then please feedback me . Thanks 




Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

SharePoint Portal Server 2001: Search and Access Disparate Data Repositories in Your Enterprise


The knowledge worker is greatly empowered if she is able to access information across the enterprise from a central access point. With the SharePoint Portal Server 2001 Search Service you can catalogue information stored in Exchange public folders, on the Web, in the file system, and even in Lotus Notes databases. This article discusses the use of ActiveX Data Objects and the Web-based Distributed Authoring and Versioning protocol for creating search solutions based on SharePoint Portal Server 2001.

Kayode Dada

MSDN Magazine April 2002

RDL Rendering (500 Internal Server) Error at Sharepoint Integrated Reporting Service


I have a serious problem that cannot be solved by googling around the keywords below:
sharepoint, moss 2007, reporting service, ssrs 2008, rendering, internal server error, ....

The error is;

"An error occurred during client rendering. The remote server returned an error: (500) Internal Server Error. "

Everything is O.K.;

* When I render the report from the REPORTSERVER (http://localhost/ReportServer)
* When the reports are scheduled to be sent by the reporting service (planned via MOSS 2007) 

But if I open (render) the RDL file from the sharepoint REPORTS LIBRARY interface, all of the reports fail with that internal error message above. 

It is weird also that parametrized reports are displayed without errors although the parameters are queried from a sql dataset. But I got the error when rendering the report after I've chosen a parameter  and order "apply/report"...

Possible causes how I met that error may be;

After I have installed (then uninstalled) AJAX extensions
After I have re-configured IIS Web Service Extensions list items

Possible solution alternatives I've found;

I've found a solution on MSDN replying a similar issue with an ideal cause of the error but an evreka answer but no sol

Sample: SharePoint Server 2010: Aggregating Data Using BCS and .NET Assemblies

Use the BCS Data Aggregation sample with BCS in SharePoint Server 2010 and to aggregate data from two external systems.

Consuming External Data Using SharePoint Server 2010 Business Connectivity Services and an Excel 201

Learn how to use BCS in SharePoint Server 2010 to access and update external data by using Microsoft Excel 2010 as a client.

Accessing BLOB Data from External Systems Using Business Connectivity Services in SharePoint Server

Learn how to use BCS in SharePoint Server 2010 to access and surface BLOB data in the SharePoint user interface and search.

Video: Accessing SharePoint 2010 Data on the Server

This video provides an overview of approaches for accessing SharePoint 2010 data by using the server-side APIs. (Length: 3:32)

Importing SharePoint List Data into Project Server 2007 Custom Fields

Learn how to use the programmability features of Project Server 2007 and Windows SharePoint Services 3.0 to import SharePoint list data into an enterprise custom field.

Facing MSDTC related issues while archiving data from one database server machine to another databas

I have a question with respect to distributed transactions when carried out between two database server machines on the same network.   Consider there are two database server machines \SOURCE_DATABASE_SERVER\ and \DESTINATION_DATABASE_SERVER\. Now we have to archive the data from one database server to other database server.   Let us suppose the database server \SOURCE_DATABASE_SERVER\ is the live production database server and \DESTINATION_DATABASE_SERVER\ is Long term storage database server. Now data from \SOURCE_DATABASE_SERVER\ needs to be archived into the database server \DESTINATION_DATABASE_SERVER\.   So I have written a dynamic stored procedure which includes distributed transaction (begin Tran, commit Tran, rollback            Tran) coding in it.   Now initially when I executed the procedure, it gave some of the following errors   1) OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" returned message "The partner transaction manager has disabled its support for remote/network transactions.". Msg 7391, Level 16, State 2, Line 1 The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "\DESTINATION_DATABASE_SERVER\" was unable to begin a distributed transaction.    

Cannot add SQL Server 2008 R2 Report items to SharePoint Server 2010 document library

Using account which is the primary parent site administrator, can upload RDS and RDL files to the document library (however, cannot open report). User is also a domain admin with SA on the database instances. Cannot add Report Data Source with "New Document" icon. The permissions granted to user '[domain]\[user]' are insufficient for performing this operation. Under "Site Settings", "Managed Shared Schedules" fails with same error. Attempting to deploy from BIDS results in the same permissions error. Sharepoint Server 2010, Report Server 2008 R2. RS and SP databases hosted on remote server (SQL Server 2008 R2). All connections (SharePoint services, RS services, users) except SQLAgent authenticating to remote SQL Server with Kerberos (all SPNs look correct). Single site, site collection "/". Document directory called "Reports". Windows Integrated Security (Negotiate). How would I troubleshoot/solve problem?

User Profiles Service Application and Import of SharePoint 2007 SSP data

I have setup a test SharePoint 2010 Farm. I will be using this as a test upgrade of a current live SharePoint 2007 Farm. The database attach method will be used. I have replicated the web application and AAM settings of the SharePoint 2007 Farm to the SharePoint 2010 Farm and have made the 2010 Farm a DC in a new Forest. I don't want to join this to the current domain at the moment. It also has SQL server 2005 with SP3 and cumulative update 3 installed. I have just setup the User Profiles Serice Application and when I go to Manage it, I get this. Error An unexpected error has occurred.   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: a1760e87-372f-4711-afac-3ceba34bc599 Date and Time: 8/31/2010 4:22:56 PM I have verified and configured the following. Created the Managed Metadata Service. The status is started via Service Applications and Services on Server. Created the User Profiles Service Application and ensured status is started via Service Applications. I started the User Profile Service and User Profile Synchronisation Service via Manage Services on Server.      

SharePoint 2010 Search Service Application: "All Content" scope contains 0 items?

I've encountered a nasty bug in our setup. Our Search Service Application manages to crawl all content just fine. However, the scopes don't work. We've got a total of 570 items currently in our crawl database. 350 of these are of class 'People', and appear in the 'People' scope. The remaining 220 items should appear in 'All Content' as part of the intra (sites, documents etc), however the 'All Content' scope reports 0 items. I've tried the following: -Creating custom scopes (still 0 items) -Recreating the Search Service Application twice -Tried different accounts as the content access account. -Ensuring that the content access accounts do have 'full read policy' -Checked the crawl log for successful content (such as sites and documents). However, despite my efforts I still get 0 items for 'All Content'.  Has anyone else encountered this problem, or do you have any recommendation for us? Currently I don't see any other option than to reinstall everything.

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

Do SharePoint 2007 and VS2010 have to be installed to the same Windows Server machine?

For WSS 3.0 development using VS 2005, I learned that we need to install VSeWSS to the Windows Server where the WSS 3.0 was installed.  For MOSS 2007 development using VS 2010, do we need to have VS 2010  nstalled to the same Windows Server?  Thanks, Jeffrey

Team Foundation Server and WSS 3.0 SharePoint Service Search not visible

I am having issues with setting up SharePoint Search service on the TFS 2008 server WSS 3.0. The Windows SharePoint Service Search service doesn't appear in Central Administration>Operations>Services on Server page. Only the Central Administration, Windows SharePoint Services Incoming E-Mail, and Windows SharePoint Services Web Application appear. I have Windows SharePoint Service Search running through Services in Windows and still it doesn't appear on the page to configure it. The service account that this service running under has db_reader role access to the WSS_Content database and is a db_owner for the WSS_AdminContent and WSS_Config database as well as for the WSS_Search database. I have executed iisreset and even rebooted the server to no avail. The installation/set up of TFS was done prior to me join the team. It was a default set up with dual servers. The Event Logs show nothing out of the ordinary to help me troubleshoot the issue. Does anyone have any other suggestions I should try or other things I should be looking for? Thank you in advance, WillWill Piedmont
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend