Silverlight app hosted in IIS cannot access database.

Question

4.00/5 (1 vote)

See more:

I have a simple Silverlight Login application, which uses WCF services to interact with database(Mysql) on my system.
I hosted this app in IIS 7.5. It is running fine when I am browsing from my system. But when I open the application on another system (within same LAN) main page opens without any problem. When i try to login, it doesn't throw any error but it is unable to open open the child page.

I don't know much about this thing and i don't know what to do. I am looking for all sorts of guidance. If anybody had same problem and fixed it, please let me know.

Thanks in advance. :)

Posted 10-Jul-13 2:11am

Suraj Pawar

Updated 11-Jul-13 2:15am

Mohammed Hameed

v2

Add a Solution

2 solutions

Solution 2

I did everything rite port was also open in firewall only thing was service was not accessible.
After digging for answers i figured out i did below changes.
[AspNetCompatibilityRequirements (RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

in my service and proper endpoint configuration.

Posted 23-Aug-13 2:35am

Suraj Pawar

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

demius · Accepted Answer · 2013-07-10T19:59:00

Solution 1

Silverlight applications can run in two modes, In-Browser and Out-of-Browser. When running In-Browser (when you host it in a website in IIS), you cannot access a database directly. In-Browser Silverlight applications typically run with low-privilege.

You will need to create a WCF service to perform database queries and your Silverlight application will then have to communicate with the WCF service.

If you're using Silverlight 5 and your application is not public, perhaps consider enabling elevated trust: http://msdn.microsoft.com/en-us/library/gg192793(v=vs.95).aspx[^]

Posted 10-Jul-13 19:59pm

demius

Comments

Mohammed Hameed 11-Jul-13 8:17am

Good explanation :thumbsup:

Suraj Pawar 12-Jul-13 1:06am

I'm using silverlight 4 and i am using WCF service for database communication.
i have published both .web and wcf services in same folder. Any reasons why database interaction is not happning from LAN.

Suraj Pawar 12-Jul-13 6:54am

when i click on browse *:8085 in IIS main page opens up but login does not happen in my local desktop also.......... Please help!

demius 12-Jul-13 6:57am

This is a separate problem. Do you have an HTML page hosting your Silverlight application?

Suraj Pawar 12-Jul-13 7:22am

i accidentally deleted it but i have .aspx page

demius 12-Jul-13 7:23am

Ok, so does the Silverlight plugin exist on the page?

Suraj Pawar 12-Jul-13 7:24am

ya...

demius 12-Jul-13 7:28am

The only thing I can think of (apart from coding/config errors) is the port perhaps being a problem. Is there any chance you can bind your local IIS to port 80 instead of 8085?

Suraj Pawar 12-Jul-13 7:46am

Ya i even tried by creating application.When i run the application through Visual studio database interaction is working, i am able to see the child window. Again if i publish both project.web and WCF service to iis and click browse from there database interaction is not happening. I'll be very glad if u can suggest some solution.

demius 12-Jul-13 7:52am

Without seeing your code and how you've implemented everything, it's very difficult to suggest a solution.

It could be that there's an HTTP error occurring between Silverlight and WCF that isn't being reported to you. I suggest installing fiddler and looking to see whether there's a call being made to your WCF service when you expect. If it is, inspect the HTTP traffic (in Fiddler) to see what's being sent to WCF and what's coming back.

What I would suggest doing is perhaps creating a simple application from scratch with the interactions you require (Silverlight -> WCF -> Database).

Suraj Pawar 12-Jul-13 9:19am

Thank you for your time.I will test with finder.