C# - WCF Service Returns 400 Bad Request

Mar 18, 2011

I've got this application that works locally and when deployed and using a .mdf SQL Express database file (which I usually use for testing purposes). However, when I change it to work with our SQL Server 2008 the app works but the service doesn't. For example if in my code behind of a page I have a button that adds data to a table such as this it works fine:

public static string connString = @"Data Source=server1;Initial Catalog=Project;Integrated Security=True";
protected void btnAddProj_Click(object sender, EventArgs e)
{
using (var sqlc = new SqlConnection(connString))
{
sqlc.Open();
var cmd = sqlc.CreateCommand();
int intProjectID;
// Add the project info to the database
cmd.CommandText = "INSERT INTO tblProject VALUES(@ProjName,@ProjTeam,@ProjStart,@ProjEnd)";
cmd.Parameters.Add("ProjName", System.Data.SqlDbType.NVarChar).Value = txtProjName.Text;
cmd.Parameters.Add("ProjTeam", System.Data.SqlDbType.Int).Value = ddlTeamSupported.SelectedValue;
cmd.Parameters.Add("ProjStart", System.Data.SqlDbType.NVarChar).Value = txtStartDate.Text;
cmd.Parameters.Add("ProjEnd", System.Data.SqlDbType.NVarChar).Value = txtEndDate.Text;
cmd.ExecuteNonQuery();
}
}

My web.config is setup to use impersonation on that server and all works perfectly well. However, for my service the query doesn't seem to return anything and I get a 400 Bad Request error. The code for the jquery is:

$.ajax({
type: "POST",
async: false,
url: "Services/ProjectService.svc/test",
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (data) {
console.log(data);
}
});
And for the Service:
[ServiceContract]
public interface IProjectService
{
[OperationContract]
[WebInvoke(ResponseFormat = WebMessageFormat.Json)]
ArrayList test();
}
public static string connString = @"Data Source=server1;Initial Catalog=Project;Integrated Security=True";
public ArrayList test()
{
var sqlc = new SqlConnection(connString);
sqlc.Open();
var cmd = sqlc.CreateCommand();
cmd.CommandText = "SELECT ProjectID FROM tblProject";
var reader = cmd.ExecuteReader();
ArrayList temparray = new ArrayList();
while (reader.Read())
{
temparray.Add(reader[0]);
}
sqlc.Close();
return temparray;
}

If instead of querying the database I have the service just return static data then it works fine. What could cause my service not to be able to connect to the database when the rest of the code behind for the app works?

View 3 Replies


Similar Messages:

WCF Service Returns Error 500 On / Js Request?

Jun 10, 2010

I have a wcf service that randomly begins to fail when requesting the autogenerated javascript that wcf supports making. But I have no luck tracking down why. The js thing is part of the wcf featureset, so I dont know how it can suddenly begin to fail and be unable to work until IIS is recycled.

The http log gives me:

2010-06-10 09:11:49 W3SVC2095255988 myip GET /path/myservice.svc/js _=1276161113900 80 - ip browser 500 0 0
So its an error 500, and that is about the only thing I can figure out. The event log contains no information.

Requests to /path/myservice.svc works just fine. After recycling IIS it works again, and some days later it begins to fail until I recycle IIS.

<service
name="path.myservice"
behaviorConfiguration="b">
<endpoint
address=""
behaviorConfiguration="eb"
binding="webHttpBinding"
contract="path.Imyservice" />
</service>
...
<endpointBehaviors>
<behavior name="eb">
<enableWebScript />
</behavior>
</endpointBehaviors>
<serviceBehaviors>
<behavior name="b">
<dataContractSerializer maxItemsInObjectGraph="2147483647" />
<serviceMetadata httpGetEnabled="true" />
<serviceDebug includeExceptionDetailInFaults="true" />
</behavior>
</serviceBehaviors>

I dont see any problems in the web.config settings either.

Edit:

Just to make it clear - It is the generation of javascript that fails, my code is never invoked. Calls to the service works just fine.

View 2 Replies

C# - Why Does Silverlight Reference To Wcf Service Blow Up When Add Method To The Wcf Service That Returns Generic List

Aug 17, 2010

I have built a WCF Service that is being consumed by a Silverlight app. At first I created one method that was very simple:

public String SfTest()
{
return "SF Test";
}

No poblem. My silverlight app references my service and displays "SF Test" in a textbox. Now I add a method to my wcf service like this:

public List<String> GetTest()
{
List<String> list = new List<string>();
String a = "a";
list.Add(a);
String b = "b";
list.Add(b);
return list;
}

I update the reference to the service in my Silverlight app and the using statement in my xaml cs page throws an error like the service doesn't even exist although it is there. I am assuming the problem has to do with datatypes or serialization or something like that but it is driving me up the wall. Why can't I consume a simple generic list in my Silverlight app through the WCF service.

View 1 Replies

WCF / ASMX :: Request Failed With HTTP Status 400: Bad Request Accessing Web Service

May 15, 2010

I have a webservice which works 100% fine on my developer machine. Where Web Service is installed on LOCALHOST on my developer machine,Then i went to my servers, I installed webservice on one server and map it with the server where the website is hosted, Then i tried accessing this service using BROWSER from my web server, it worked fine, That means the mapping was done perfect.Then i run my program on web server (website). It worked fine on page1, then on page2, but when i did the same and call same function on page3, It popped me any error of

View 4 Replies

Databases :: Page Returns Error Every Other Request?

Jul 28, 2010

I'm experiencing a really confusing error. Exactly every other time the page returns

ERROR [23000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Integrity constraint violation:uniqueness constraint violation (7518)and else it works nicely.

Here's the SQL:

SELECT SlsOrder.Orderdate, SlsLine.LineNum, CASE WHEN SlsLine.AllDelivered = 1 THEN 'X' ELSE '0' END AS 'AllDelivered', Item.ItemName, Item.TechName, SlsLine.IntDlvDate, SlsLine.OrderNum, SlsLine.ItemCode, SlsLine.Version, CEILING(SlsLine.Qty) AS 'Qty',
Item.QtyUnit, ROUND((SlsLine.Price*SlsLine.Qty),2) AS 'rowSum', ROUND(SlsLine.Price,2) AS 'Price', IFNULL(SysText.InfoText, '-') AS 'InfoText' FROM PUB.SlsLine INNER JOIN PUB.SlsOrder ON (SlsLine.OrderNum=SlsOrder.OrderNum) INNER JOIN PUB.Item ON (SlsLine.ItemCode=Item.ItemCode)
LEFT OUTER JOIN PUB.SysText ON (SlsLine.SlsLineKey=SysText.SysTextKey) AND SysText.NoteType = 'OrdConfRowE' AND SysText.ConsTxt = '' WHERE (SlsLine.OrderNum = '" & o & "') ORDER BY SlsLine.LineNum

View 2 Replies

When Execute The Page, It Returns The Calling Pages Url From Request?

Mar 25, 2010

I have a dynamic catalogue, where customers select products they are interested in. The manager of the company I am doing this for would like to be able to create an up to date offline catalogue at any given time, to send out to customers who dont have an internet connection. So far its going really well. I am using Server.Execute to get the content for each page, then putting it in static html pages and changing the dynamic links to static html links (ie changing all aspx links to htm). I am able to output all the pages for about us, contact us, home, and the entire catalogue. However, one of the stylesheets which is included in the page based on the URL (if the page is in the administration section then it is not included, otherwise it is) is not being included in the pages when it should be. I have tried outputting the URL but it just returns the URL of the calling page, not the page being called.

View 1 Replies

MVC :: Clearing ValidationSummary When Form Returns A Download Request?

Sep 20, 2010

Here's my setup:

Simple mvc page with a few controls that includes a validation summary area.

Once the fields are completed there's a download button.

If I enter something invalid, as expected, my controller code updates the UI with the appropriate error. However, if I then correct the error, and then click the download button a file is downloaded, but the UI never gets updated - presumeably since there's no update on the view.

View 1 Replies

WebMatrix :: Getting Data On A Post From The Request Object Returns No Values?

Mar 23, 2011

I am new to webmatix and I do not do much development. I was trying to get some values from a request object and it's probably something very stupid I am doing wrong but really I cannot see what it is. This is the code I am trying to use, but I get no value from any items from the form:

@{
Layout = "_SiteLayout.cshtml";
Page.Title = "test";
if (IsPost)

[Code]....

View 3 Replies

WCF / ASMX :: Accessing Response Of HttpWebRequest, Even When Request Returns 500 Internal Server Error

Oct 22, 2010

Hoping someone can point me to a solution, haven't been able to find one yet.

I'm using the standard way for send HttpWebRequest

[Code]....

As you can see from Fiddler/SOAPUI it does return the SOAP fault, however using HttpWebRequest i can't capture the response.

Returning 500 triggers my exception handling and Capturing the WebException doesn't expose the response.

Does anyone know how to capture this response xml in the case of 500 Internal Server Errors.

View 1 Replies

Web Service Returns IndexOutOfRangeException With Arguments?

Dec 15, 2010

I have the following web service:

[ScriptService]
public class Handler : WebService {

[WebMethod]
public void method1() {

string json = "{ "success": true }";

System.Web.HttpContext.Current.Response.Write(json);

[code]...

The first method accepts a traditional html form post and response writes a JSON string to the page.The second method accepts a JSON value posted via AJAX and returns a serialized object.Both these methods work fine on their own but when put together in the same web service I get this error when calling method1:

System.IndexOutOfRangeException: Index was outside the bounds of the array.

When I remove the arguments from method2 they work.Can anyone suggest why this is happening?

Edit:The problem spans from the argument type of method2. If I change it to a string or simple data type it works fine.As Joel suggests it's probably because Dictionaries can't be serialized.This doesn't seem to affect my requests sent by ajax and only breaks direct form posts to this handler.Therefore my workaround is to put the form post handlers in a separate file by themselves.Not ideal but works for my application.

View 1 Replies

WCF / ASMX :: WCF Service Returns Blank Data?

Jul 22, 2010

I'm new to WCF and this is definitely a rookie question. Why does my browser show/return nothing when I type this URL: http://localhost/service.svc/root, using the code below. I was hoping I would see an xml respone like: <double>56.78</double>. service.svc

--------------------------------------------------------------------------------------

<%@ ServiceHost Language="C#" Service="EssentialWCF.StockService" %>
using System;
using System.ServiceModel;
using System.ServiceModel.Web;

[code]...

View 6 Replies

AJAX :: Wcf Based Web Service Returns Data In JSON?

Jul 7, 2010

I want to make a web servcie(.svc) that returns JSON data after entering the input.....which is resulted as in the downloaded filein JSON format.i want something like that-http://209.62.6.226/GracoRest/service.svc/Rest/WheretoBuyplease help me for the above but....step by step...i m trying WCF very 1st time

View 3 Replies

ASMX Service Works On Development Server Returns 404 When Deployed To IIS 7.5?

Mar 24, 2011

I have a web application in ASP.NET 4.0. I've added an asmx service, primarily as a source for the autocomplete extender's lookup values.

When I debug on my machine locally, everything works fine. However, when I deploy the web application to IIS 7.5, I get a HTTP 404 response when trying to send data to the service.

I am able to browse to the service definition, see the available operations. Tellingly, however, when I use the test pages to test the service using POST, I receive an HTTP 404 again.

I'm not sure what is going on. I did create the asmx file within my web application and it is deployed in the virtual directory of my otherwise working production application. Is there an issue with the .asmx file being deployed in the same virtual directory, perhaps?

View 1 Replies

JQuery :: Call Asmx Service That Returns Multiple Data

Mar 3, 2011

I want to call .asmx service from jquery

.asmx service will return multiple data from database.

I need to get those data to jquery on client side

and then i need to put each data into their respective textfield on the client side

View 6 Replies

WCF / ASMX :: Calling A Remote Or Local Web Service That Returns A JSON With JQuery?

Mar 16, 2011

how to create a Web service that returns a JSON(or JSONP). That also should be able to work for cross-domain access aswell as for a local call.. help to get this working or for a few links for further reading about this

View 2 Replies

Crystal Reports :: Create A Web Service That Returns Output In JSON Format

Mar 29, 2013

How can we consume a web service using asp.net out put in json formate?

View 1 Replies

Security :: WebService Returns "The Request Failed With HTTP Status 401: Unauthorized"?

Jan 7, 2010

I wrote a web services with Windows authentication, when i consume this WS from my app inside my network all work great, but when I consume this WS outside my network the WS return "The request failed with HTTP status 401: Unauthorized"I'd try the URL in an explorer page and all works great.In my app I use this:

webservice.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials;

What alternatively can I use to get credential inside and outside of my net?

View 4 Replies

Vb.net - Request.LogonUserIdentity.Name Returns Server Credential Not The Users Credential

Feb 15, 2011

I am building a simple intranet site and want to get the employees user name, but when i use Request.LogonUserIdentity.Name , i keep getting the servers credentials and not the users. what am i doing wrong and is there a better way to do this.

View 1 Replies

How To Get Xml Web Service Request

Jan 11, 2011

I'm submitting a request to a web service, but I'm receiving some errors. They've asked to see an example of the xml request and response. I used Visual Studio to consume the web service, so I'm just calling a method in my code - I don't actually see any xml. Is there a way to grab the XML request and response as XML or at least a text string?

View 2 Replies

WCF / ASMX :: Web Service Getting Request?

Oct 5, 2010

[Code]....Web Service Getting Request

[Code]....

View 1 Replies

How To Force Web Service Request To Use HTTPS

Jun 1, 2010

I have an asp.net web service which has SSL enabled via IIS. It works fine if the user uses https, however I have a user that insists on using http on the url.

What I'd like to do is have the web service (asmx) do the equivalent of the response.redirect to change http to https automatically.

I don't believe that I can do this from a web service so does anyone know a of a similar solution for web services.

View 4 Replies

View The Xml Response Of Request To The Web Service

Apr 26, 2010

I'm developing a client of a webservice in C# with VS.NET 2008.And I would like view the xml response of my request to the web service. which i have call . Is it posible?

View 2 Replies

How To Increase The Timeout To Web Service Request

May 26, 2010

I have an ASP.NET web application that I can't modify (I only have the binaries). This application connects to a web service and it seems like the connection is closed from the client side (my web app). I have increased the "executionTimeout" in the machine.config of the destination server but my web app seems to still stop after waiting for a while.

Is there a way to increase the timeout time for my web application by simply modifying the web.config? As I said... I can't modify the timeout in the code so my only option would be through config files.

View 1 Replies

Security :: Authentication When Web Service Is Being Request?

Feb 10, 2010

I am using .NET roles and membership model to manage user accounts in my system back-end.

If the request is come from within my web-app, I can authenticate through form.

But if the user is requesting from else where, maybe their own apps, how to I do authentication?

attach username and password (GET/POST) and then secure the line by SSL? is that what I should do?

View 3 Replies

WCF / ASMX :: Encrypting A Request In Web Service?

Nov 11, 2010

Am consuming a web service for example Calculator

Calculator CALC = new Calculator();
int a = CALC.Add("23","27");
and result will be stored in a;

Please help me to encrypt this request using the X509 certificate. Am having a certificate with public key and with subject "My Calculator"and also decrypt the result with the private key "abcdef" and with subject "My Response"

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved