C# - Cannot Access WCF OData Service With DateTime Key Because Of Colon?
Nov 22, 2010
I have an OData WCF service in my ASP.NET project that i use to read and update an SQL-Server database.For one of the tables, the primary key is a DateTime field. When trying to access specific rows through the OData service, the uri looks like this: "http://server/odataservice/stats(datetime'2009-12-12T00:00:00')".When trying to update this table through the service, or browsing to it, it gives only an error. The error is sent before the WCF service is ever contacted, and as far as i've been able to find it's because the IIS does not allow colons in uri's, only in queries, for security reasons (something about NTFS).
The actual IIS error is "HTTP Error 500.19 - Internal Server ErrorThe requested page cannot be accessed because the related configuration data for the page is invalid", but it seems a bit misleading.If i remove the colons and browse to "http://server/odataservice/stats(datetime'2009-12-12')" it works as expected. However i'm clueless as how i'm supposed to be able to do this in by C# client that is bound to the OData service. It also feels very hacky to edit the uri on the client or on the server on the fly, i would rather have a proper solution.I'm using a hosted IIS, so i cannot as far as i know change it's configuration to allow colons, even if that was possible.
View 1 Replies
Similar Messages:
Feb 7, 2011
I am selecting some data from a access database which is in Date/Time format in the Database and also in the programme the variable the information is stored in is registered as Date/Time.
However when I run the programme it says there is a data type mismatch.
[Code]....
View 3 Replies
Mar 11, 2011
I have an existing RESTful webservice that I consume (I did not create) from a 3rd party. I currently use WebRequest and WebResponse to create and read the request and response. I access the service by url with query string parameters to pass what type of data I am requesting. I get the results back in XML, then have to load it into a new XmlDocument, create a bunch of DataSets, XmlNodeReaders, DataTables, etc. It's really messy in my opinion.
What I am looking to accomplish is to take advantage of the Entity Framework Model, OData, and WCF. I have never create or used WCF yet. The webservice that I am accessing is some sort of service created from within Apache, it is not .Net. I don't know whether or not I can utilize the new .Net Framework 4.0 services to make the consumption of this service any better, easier, or cleaner.
View 5 Replies
Apr 27, 2010
I am getting the error "The return URL specified for request redirection is invalid" when using forms authentication. I found this thread that says this is a known issue with return URLs that contain colons (mine indeed contains a few). The workaround in that thread is to catch the error and use a default return URL ... hardly an acceptable solution. I can try to avoid colons in URLS, but that's a bit of a pain. Is there another alternative?
View 1 Replies
Jul 27, 2010
(probably a bot) sent a request with the following URL to my ASP.NET 4.0 web forms application (running on IIS 7.0):http://ipaddress-of-my-applications-domain/bla1.bla2.bla3.bla4.bla5:)This caused an System.Web.HttpException. I received a logging email from ASP.NET HealthMonitoring I had configured, telling me:A potentially dangerous Request.Path value was detected from the client (:).
System.Web.HttpRequest.ValidateInputIfRequiredByConfig()
System.Web.HttpApplication.PipelineStepManager.ValidateHelper(HttpContext context)
Why is a colon in the URL "potentially dangerous"? What dangerous things can be done with such a URL? Do I have any security hole here I am not aware of?
View 3 Replies
Feb 5, 2011
I tried to pass datetime from a textfile to the form and using it to get the classes from web service.
the site has 4 countries. based on the country value from session , i load the text file.
It works perfectly for 3 countries without any issues. but not for the fourth country.
View 3 Replies
Nov 23, 2010
I have to bind OData feed, which is a response from WCF Data Service, to a gridview. The structure is as follows:
[Code]....
[Code]....
View 1 Replies
Feb 11, 2010
Passing a null or nothing value to a datatime datatype database field (Access)
I've been all over the internet looking at this and I have tried dozens of methods without success.
I've read a few forums where, some say you can not assign a null value or a nothing value to a datetime datatype field. Then I see others where they say...'I got it to work'.
If this is true (that you can not pass a null value), how come I can create a record in the Access table and not assign a value to this date field? (The field is defined as not required).
Yet, once a value is in the field, I can not update that field back to a null or a nothing value.
So I'm hoping someone has the definitive answer to this.
I am using VB.Net Vs 2003 and updating an Access data base.
I have an update statement (see below) that uses parameters for updating.
what will work, so that I can put back the null or nothing value?
Or if it really can not be done, I guess I'll have to take that as truth.
[Code]....
View 5 Replies
May 24, 2010
I want to access simple web service inside WCF service. How can i achieve it?
View 2 Replies
Nov 18, 2010
I need this up and running quick but I spent the last few hours researching/worrying about which would be better:
Asp.net Forms Authentication
vs
Custom Header Token:
On the server
[code]...
View 1 Replies
Jan 14, 2011
My issue is that , need to change the column name(following format "Remove first character and after 3rd character insert colon") of the gridview (which is binded with XMLTextReader). Without changing directly XML file, Required to change the column name dynamically at runtime .
Performance.xml
<Performance>
<Departments>
<Heading>FS</Heading>
<S0015>1</S0015>
<S0020>2</S0020>
<S0025>5</S0025>
<S0030>5</S0030>
<S0035>6</S0035>
</Departments>
<Departments>
<Heading>BS</Heading>
<S0015>0</S0015>
<S0020>3</S0020>
<S0025>5</S0025>
<S0030>1</S0030>
<S0035>3</S0035>
</Departments>
</Performance>
Heading S0015 S0020 S0025 S0030 S0035
FS 1 2 4 5 6
BS 0 3 5 1 3
Required Format: Remove first character and after 3rd character insert colon (S0015 -- 00:15)
Heading 00:15 00:20 00:25 00:30 00:35
FS 1 2 4 5 6
BS 0 3 5 1 3
View 2 Replies
Sep 2, 2010
I am really struggling with this! Using the regular expression validator I created an expression, thus ":" to show an error message if the user tries to enter in a name that contains a colon. What I am getting is the error message showing even when there is no colon (:) in the string. What am I doing wrong?
View 4 Replies
Jan 21, 2010
I created a UserControl and added a public DateTime property. I want to set this property in Markup (ie. <cc1:MyControl runat="server" id="MyControl1" DateTimeProp="1/1/2010" /> ) however I live in a place with a dd/mm/yyyy date format so it complains if I set something like "20/1/2010". Is there a way to set markup in my local datetime format or do I have to conform to "mm/dd/yyyy"?
View 2 Replies
Apr 1, 2011
I have a problem:
I've created usual Controller and View(Edit view) for editing my Entity (EntityFramework)
Here is view example:
<div class="editor-field">
@Html.EditorFor(model => model.BirthDate)
@Html.ValidationMessageFor(model => model.BirthDate)
</div>
BirthDate is Nullable<DateTime>
but during loading my View I get this exception
The model item passed into the dictionary is null, but this dictionary requires a non-null model item of type 'System.DateTime'.
That's because of BirthDate is null in database but it is nullable and I expect that it just leaves the filed empty.
And I have Shared EditorTemplate:
@model System.Nullable<System.DateTime>
@if (Model.HasValue)
View 2 Replies
Feb 9, 2010
I have an XML string which contains Dates formatted "dd/MM/yyyy hh:mm:ss".
I'm loading this XML into a dataset using DataSet.ReadXml().
How can I ensure that this Date is stored in the DataSet as a typed DateTime so that I can Sort, Format and RowFilter on it accordingly.
My test harness is as below:
ASPX Page:
[code]....
View 1 Replies
Jun 1, 2012
obj.From = DateTime.Parse(txtFrom.Text, ci);
And it will give error String was not recognized as a valid DateTime. How it can be solved..
View 1 Replies
Jun 2, 2010
How show local time in datagridview collumn DateTime from database with universal datetime
View 2 Replies
Jun 9, 2010
Im using VS 2008, 3.5 framework I want to use wcf, but javascript cant access to myservice.svc error : Message: 'MapService' is undefined;
calling mapservice ;
function getselectedIl() {
var firstLetter =
"caglar";
var proxy =
new MapService();
proxy.GetSuggestions(firstLetter);
defining mapservice;
<asp:ScriptManager ID="ScriptManager2" runat="server">
<Services>
<asp:ServiceReference Path="MapService.svc" />
</Services>
</asp:ScriptManager>
mapservice.svc.cs;
[ServiceContract(Namespace = "")]
[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
public class MapService
{
[OperationContract]
public string GetSuggestions(string firstLetter)
{
return "basarili";
}
}
View 6 Replies
Jun 29, 2010
I'm getting a strange data download from an Access database.Using Visual Web Developer 2010 Express, I created a web service that places records from an Access database in server cache and then reads the records, one at a time, from the cache. The data in the records is converted to a delimited string. The web service is called from an e-learning program called Toolbook that places Http Post calls to the web service. The web services uses vb and .Net Framework 2.0.
All works correctly with one exception. When a record in the Access db contains "&", it is downloaded to the Toolbook e-learning program as "&". If I place && in the record, I get "&&".If I download the data from the Access db using a classic.asp file rather than the web service, the "&" displays correctly.
View 2 Replies
Jun 2, 2014
How to access my webservice below from browser?URL.... I hope it display random no in my browser 8 and URL... I hope it display 8 in my browser
public class WebService1 : System.Web.Services.WebService
{
[WebMethod(Description = "Get Random Number")]//Description about web method
public string GetNumber() // Declaration of Method
{
Random RM = new Random();
return RM.Next(1, 100).ToString();
[code]....
View 4 Replies
Sep 30, 2010
I am trying to store a SQL Server datetime into MySQL datetime field, but MySQL stores the date value as all zeros. I use this function to trim the fractional part from the SQL Server datetime, but get the same result when trying to store it in MySQL.
[Code]....
View 1 Replies
Nov 15, 2010
I am trying to get data from mysql database and store in sqlserver database. i am getting the following error
The given value of type MySqlDateTime from the data source cannot be converted to type datetime of the specified target column.
View 5 Replies
Oct 3, 2010
I get this error when trying to access a self hosted wcf service...
[Code]....
Can someone explain what I need to do to get this to work, I do not have any cross domain policy file. And don't know how that is supposed to look like.
View 1 Replies
May 2, 2010
We have two servers, both are containing a local application connecting to local web service, applications and services are identical on both servers. One of the servers work just fine, The other one is just dead, I have impression the the security configuration are different on those servers. What prevents an application X from connecting a web-service, given that another application y on the same server can connect to it. and X is a windows service. What I should check, what is chances?
View 2 Replies
Dec 28, 2010
I need to read the data from the COM port in a web application, so I have written a Windows Service for reading data from serial ports. Now I need to access that data in a web application. Can anyone tell me how to access it? Is using threads the best way to do this or not? What other possible ways are there?
View 3 Replies
