Load Error...Getting started

I have just purchased DiscountAsp and I am looking to publish my first Silverlight application to DASP. I am at the point now where it seems that I am not getting connected to my SQL Server database online (I think).

I am getting the following error when a page loads...
"System.ServiceModel.DomainServices.Client.DomainOperationException: Load operation failed for query "GetSchedules". The remote server returned an error: Not Found. ---->...."

My app runs fine locally. I have recreated my tables in my DASP database and the database is a different name than my local database...but all tables are named the same.

Any help would be appreciated.

Thanks
-Tony

 

Load Error...more detail...

This is what my Web.Config had when running local..

<add name="ssyflEntities" connectionString="metadata=res://*/ssyflDbModel.csdl|res://*/ssyflDbModel.ssdl|res://*/ssyflDbModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=MW7IMBC7BHF2BS;Initial Catalog=sqlWAYA;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

...and from my investigating it looks like I should remove that above and use the following:

<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=tcp:sql2k805.discountasp.net;Initial Catalog=SQL2008R2_820515_sldb1;User ID=SQL2008R2_820515_sldb1_user;Password=UPJsean1;" providerName="System.Data.SqlClient" />
<remove name="ssyflEntities" />
<add name="ssyflEntities" connectionString="metadata=res://*/ssyflDbModel.csdl|res://*/ssyflDbModel.ssdl|res://*/ssyflDbModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=tcp:sql2k805.discountasp.net;Initial Catalog=SQL2008R2_820515_sldb1;Integrated Security=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

...However, it still does not connect.

Thanks

 

Run fiddler and see what errors you get.

http://blog.discountasp.net/how-to-troubleshoot-silverlight-ria-applications/