SL application to syncronize sharepoint lists with SQL server database

Dear All,

I created a Silverlight application that connect to Sharepoint site and reads list data using client object model.

This application was not using .web project for deployment and it works fine, until I needed to connect to SQL database to update the correspondent tables. So I decided to create another Silverlight application that using .web project in order to use EF and RIA Serivces. at this point the application couldn't connect to Sharepoint site although it can connect to the central administration site and load the lists.

The interesting part is that the standalone SL app was accessing SP site using the computer name as http://Computername:3030, but the .web project cannot retrieve the same information unless I replace the computername:3030 with localhost:3030 where I got the prompt to enter username & password, when I try to access the other sites using the same approche I got Nothing.

when I trace this in fiddler when accessing the sites, I can see that :

1- The application try to find the clientaccesspolicy.xml and it returns : 304 Not Modified

2- The application try to get _vti_bin/sites.asmx and it returns : 404 Not Found

while the result is a little bit differetn when I access the central administration site, I can see this:

1- The application try to find the clientaccesspolicy.xml and it returns : 304 Not Modified

2- The application try to get _vti_bin/sites.asmx and it returns : 200 OK.

I hope I explained the situation well, Could someone tell me where is the issue.

Best regards

July 14th, 2013 11:31pm

Hi Trevor,

Based on my search, I find a very similar case with you your scene. It is solved by the document properties.

<webServices>

    <protocols>

        <remove name="Documentation"/>

    </protocols>

</webServices>

You can refer to the following case.

http://social.msdn.microsoft.com/Forums/sharepoint/en-US/772d0c36-5e83-435f-8ef7-f1da7301785f/sharepoint-ootb-web-services-asmx-to-wsdl-conversion-not-working

Thanks,

Jack

Free Windows Admin Tool Kit Click here and download it now
July 17th, 2013 6:24am

Hello,

How come this is an answer to my question!! can you explain more please

Regards

July 22nd, 2013 2:44pm

IMO, using localhost:3030 would not be appropriate. What would be appropriate is to make use of the URL in SharePoint AAM. To me that appears to be the problem; although I cannot confirm with just that information. Going by the nature of the issue, I would encourage you to open an Advisory support case with the Microsoft SharePoint Developer support team. A dev. engineer would then be assigned to scope the issue, and investigate the issue further. I also presume that your Silverlight application isn't attempting to impersonate credentials of a user who has appropriate access to the site content.
Free Windows Admin Tool Kit Click here and download it now
August 1st, 2013 4:16pm

Dear all,

I have copied the clientaccessproxy to where the .web.config is located and then access the site using localhost plus port number from my silverlight application. I was able to pull the data with no problem from sharepoint sites.

Cheers,

Waleed

August 3rd, 2013 4:19am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics