Web Services are not able to Extract Data from Database

Question

0.00/5 (No votes)

See more:

Hi,

I have a website in Asp.NEt mvc3, Services that are Configured on Remote Server are perfectly Working but I want to test the Site on My Local to Judge How Fast it could work, In Fact I have Added some telerik Control in, Now I don't have Idea How could I do this

For example I have following Line of code in my Web Config for Account Memebership Service, When I try to Login from Admin Account it does not get into account, and give error UserName Or Password is incorrect from my Views.

SQL

<endpoint address="http://localhost:5229/Services/AccountMembershipService.svc"
        binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IMembershipService"
        contract="MembershipService.IMembershipService" name="BasicHttpBinding_IMembershipService" />

This Service I have Checked its running but I cannot login to Account or why it is not Showing me data that it should Extract from DB

when I use following line of Code It works

SQL

<endpoint address="http://www.masjidzamzam.com/services/AccountMembershipService.svc"
         binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_IMembershipService"
         contract="MembershipService.IMembershipService" name="BasicHttpBinding_IMembershipService" />

So What should I do, any Idea

thank you

Posted 26-Jun-12 2:12am

M Ali Qadir

Add a Solution

1 solution

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)

Tim Corey · Accepted Answer · 2012-06-26T02:25:00

There is a lot more going on behind the scenes than you are showing us here (or can show us). Right now the code you posted looks fine. However, that all depends on your setup. It looks like there could be a couple different issues based upon what I see.

First, you might not have transferred the web service to your computer with the same settings as the server. It sounds like you are accessing a database inside your web service. Your machine might not have the ability to access that database server (because of firewall settings). Also, it could be that the account IIS Express is running your application pool under doesn't have rights to the database (if you are using trusted authentication).

Second, your pathing might be wrong inside your service. For instance, if your database is on the web server with your service, you might have referenced it with the dot (which means "this computer"). That won't work remotely. Also, if the web service accesses any files or other items by path, that path might be messed up.

In the end, I'm not sure that bringing all of this local in order to test maximum speed is a good idea. For instance, your local machine is most likely slower than the server (in terms of processor, RAM, etc.) Also, if you run the site with your debugger, it will be even slower. Finally, the results of the test won't give you good information to work with. If the site becomes blazingly fast locally, what does that show you? That it can? Real-world tests are the only true indicator of speed.

Update
If you are trying to operate your web service locally using the development server (Casinni), that is probably your problem. Casinni is not designed to be accessed by other websites/services on your computer. I would recommend moving to IIS Express. IIS Express is designed to handle this and it is free. I wrote an article about how to use IIS Express recently. Here is a link: Make Web Development Easier with IIS Express[^]