Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

trying to set-up and consume a web service within SP using azure hosted services. I have written really simple code which compiles and deploys as a package. Followed this excellent walkthough... http://blogs.msdn.com/b/steve_fox/archive/2011/11/12/leveraging-wcf-services-to-connect-bcs-with-sharepoint-online.aspx.

When i try to add the external content type within SP i get the following message.

"Error loading URL ... this normally happens when URL does not point to a valid discovery document, service description, or XSD schema"

You can see the service here...http://splobservice.cloudapp.net/SharepointCallingService.svc

Anyone ran into this?

Stephen

share|improve this question
    
Have you taken a look at the lab from Donovan Folette? blogs.msdn.com/b/donovanf/archive/2012/06/25/… Do you get any error when you create the external content type in SharePoint Designer? –  GavinB Jul 26 '12 at 3:34
add comment

1 Answer

Thanks for the reply Gavin and the link. Its taken a few days of head scratching but I eventually got the bottom of things...

The problem was the collation of the database (in my case SQL Azure) I had been using a DB created in SQL Azure which used Latin1_General_CI_AS, could not get it to work so decided to create a new DB using SQL_Latin1_General_CP1_CI_AS after reading a post on-line about the pitfalls of collation with SQL Azure.

Not sure why it has to be this collation or what can be done if your external DB is different to SQL_Latin1_General_CP1_CI_AS though...

Hope this helps someone.

Cheers,

Stephen

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.