WCF / ASMX :: Web Service To Retrieve Data In Excel?
Dec 21, 2010I need to write a web service which will generate excel file by using the records present in the database or depending upon the query fired.
So how should I try this?
Similar Messages:
WCF / ASMX :: Unable To Access Web Service From Excel VBA
Feb 4, 2011I have a web service which is accessible from the browser. When I try to access the same web service which is hosted on Windows Server 2008 R2, from an excel Macro, it says
Run-time error '-2147220991' (80040201)':
Server was unable to process request --> The request failed with HTTP status 404: Not Found.
The excel macro works fine when I try to access the same web service on the other server(Windows 2000 Server)
The web service is developed using .Net 2.0.
I'm posting the URL for the web service for your reference.
URLs which are not being accessible from Excel.
[URL]
[URL]
URLs which are being accessible from Excel.
[URL]
[URL]
Both Web services and Excel macros are old applications which have been running fine for years. The only change is that the application is being migrated to a new server(MCDEAGDWEB202) which has Windows Server 2008 R2 and SQL Server 2008.
The Old server(MCDEAGLWEB005B) has Windows Server 2000 and SQL Server 2000.
WCF / ASMX :: Unable To Retrieve The Attachment From Soap Message Returned From SAP XI Service
Oct 28, 2010I am trying to get attachment from the SAP XI Web Service which is returning the following soap response..
--SAP_db9e7598-e284-11df-9fcf-001125a6de68_END
WCF / ASMX :: Retrieve Blob Data / How To Store The Value
Jun 18, 2010I am using C#. I am consuming a webservice. The webservice has a method, which has the return type as blob. The webservice serializes the data before sending as blob.I am able to access the webservice method, but I am not sure how to store the value, as the return type is a blob.I have tried this:
Service1.TestService serv = new Service1.TestService();
? = serv.Custom_methodname(true);
How to assign the output as it is a blob variable?
Databases :: How To Fetch Or Retrieve Complete Excel Data In A Gridview
Aug 12, 2010I have a excel sheet it contain 4 worksheet (spreadsheet), i want to fetch all data into a gridview ?
How To fetch or retrive complete excel data(sheet1+sheet2+ bla bla) in a gridview...
How To Retrieve Data From An Excel Worksheet And Present As A Gridview Table
Aug 10, 2010I am using Visual Studio 2005 version, DOTNET Framework 2.0, Technologies C#.NET and ASP.NET and Operating System WindowsXP.In my excel sheet i have two columns of data. Using Gridview i am retrieving data from excel sheet and presenting data. While i am writing RowDeleting event i am getting error primary key not exist.Below code i am using in my program: Default.aspx
View 2 RepliesIs Better To Retrieve Data Using Web Service Or Directly From Database
May 5, 2010i was wondoring which thing is better from below two... first one- retrive data by creating webservice second one- create database connection from code behind call storeprocedure and retive data
View 6 RepliesRetrieve The Data From Web Service And Keep In Process Memory?
Feb 15, 2010I have to retrieve the data from the web service and this data should be kept in process's memory and use it where needed.Do not like to call web service every time.Is there any method to do this?
View 2 RepliesJQuery :: Ajax Unable To Retrieve Data From Wcf Service
Feb 16, 2011i am running with an unfamilier issue with jquery ajax and wcf service . i have created a simple wcf service and trying to show it on a asp.net label... the wcf service just returns a string which has to b shown on a label. the url has been set on jquery ajax url to call the wcf service using rest. but somehow i am not getting the desired thing done . the ajax cannot retrieve the data from the wcf service , here are the code snippets.
The Ajax Portion in default.aspx :
[Code]....
The Service Contract for WCF :
[Code]....
The implemented Method :
[Code]....
and the Web.Config :
[Code]....
can someone figure out here i am going wrong .... that the ajax is unable to retrieve the data from the above wcf Service .. its just a very basic and simple one .. but unable to figure out the Real Prblem.
WCF / ASMX :: Get Data XML From Web Service
May 18, 2010I´m new to web services and currently working with an integration to a third party system. I have created a web service that creates and exports a <List> of objects. The challange I have is that the third party company consuming my created web service wants to have the data as a XML document just as it is presented when I push the "Invoke button" when testing my web service on the server it resides on. Doing so I get all my exported data presented as a nice XML document. Since a web service actually exports this XML it should be a fairly simple task, but I do not know how? Would perhaps anyone have a code snippet consuming a web service and present the data just as an XML document? Or could point me to an example? I´m using VS 2008.
View 3 RepliesWCF / ASMX :: Create Web Service - How To Web Page Call Sales_Services.asmx
May 5, 2010if i have the web application with many pages like add order page, edit order page, and delete order page actually they also interact with the Sql Server 2008 and i also create web service page call Sales_Service.asmx. i know just i need to put something like query into Web Method in Sales_Service.asmx but i have a lot of queries, i don't know which query i should put into it and how the web page call the Sales_Services.asmx
View 2 RepliesWCF / ASMX :: IIS Memory Increasing For Each Client Request In Asmx Web Service?
Nov 8, 2010A customer reported that our asmx web service is continually increasing in memory (mem usage as well as private bytes). We are able to reproduce the problem in our lab with Windows 2003 Server SP2 (fully patched) on some of the machines. The customer is using Windows 2008.
We created a Hello World web service targeting the 2.0 framework built under VS2005 SP1 and a test client that continues to call it. The memory increases steadily - approximately 40K per client request. If the test app is paused, the memory remains the same. When it is closed, the memory drops. Explicit calling of GC.Collect does not drop the memory.
We have run the memory profiler on the service and the leak is all native memory. We have uninstalled/re-installed the Framework on one of the machines but no difference. To our knowledge all of the security and IIS settings are not modified. We have compared app pool, default web site and virtual directory properties to machines that have no problem and they are identical.
WCF / ASMX :: How To Call Asmx Web Service In A .net App From Classic Asp App Js File
Mar 17, 2011I have a .net app developed in .net 4.0 version. And I implemented an asmx web service in this. Now I want to call one of the webservice method in another classis ASP application java script function.
View 2 RepliesWCF / ASMX :: First Data Web Service API Integration
Jan 27, 2011I'm trying to use the First Data Global Gateway web service API. I was able to reverence the WSDL file in VS and get the classes to show up. I get the error "Object reference not set to an instance of an object." I can't figure out what I'm doing wrong.
[Code]....
WCF / ASMX :: Running A Web Service User Service / Domain Account?
Mar 28, 2011Is it possible to run a web service as a particular user/service account in the same way a Windows service can?I have a service account used for connecting to the DB and want to run the webservice under this account as the users using the webservice won't have DB access.The way I see to do it is to include the Impersonate option in the Web.config file, but is there any better way to do this?
View 1 RepliesWCF / ASMX :: Create An Instance Of Web Service Without Adding Web Service Reference?
Mar 17, 2011How to create an instance of web service without adding web service reference? How to identify the server address/name where the web service is hosted from C# code?
View 1 RepliesUnable To Pass User Credentials From WCF Web Service To ASMX Web Service
May 25, 2010My WCF Client calls my WCF Service which then calls ASMX Web Service. The problem is i have configured my wcf client and wcf service to windows credentials type but when wcf service calls asmx service the user credentials (default windowsidentity) is not passed to asmx service.
In WCF Service i am able to get user identity by using : Thread.CurrentPrincipal.Identity.Name;
WCF Service - i have disabled anonymous access and enabled windows authentication. ASMX Web Service - i have disabled anonymous access and enabled windows authentication.
WCF Service Config
[Code]....
WCF / ASMX :: How To Call Web Service Hosted In Window Service And Having End Point Over Tcp
Aug 4, 2010i have created a normal web service and i want to host it outside IIS. one idea i got is to use window service as hosting environment. i have created a web service and hosted it window service and its window service is running now.would anybody please let me know that how can i call web service hosted in window service binded over soap.tcp. here is my sample code.
[Code]....
[Code]....
WCF / ASMX :: Develop A Web Service That Handle Another Web Service's Event (C#.Net 3.5 Framework)?
May 26, 2010I want to develop a web service that handle another web service's event. (C#.Net 3.5 framework)
View 1 RepliesWCF / ASMX :: Sort Data Returned From Web Service?
May 12, 2010I have a web service that returns an object that I attach to a gridview's datasource. is there a way to sort the data from the web service before attaching it to the datasource?
[Code]....
WCF / ASMX :: Merge Using JQuery With Data Service
Aug 26, 2010I'm a bit new to the whole asp.net thing so this is probably a silly question, but here it goes: I have created a WCF Data service based based on a ADO.net Entity--it's very basic:
[Code]....
WCF / ASMX :: Reading Data From Database Using Web Service
Apr 25, 2010I have a requirement in which i have a database table which has 4 columns Id,Name,position,city.....now i have a form in which the user will be filling in the id and then the other three columns should auto populate ....now i want a web service which will make a data connection and get the Id from the form and then query the database and get the other three columns..i am pretty new to web services ..can somebody give me some heads up on how to achieve this...let me know if i have to provide more details.
View 8 RepliesWCF / ASMX :: How To Get Data From An Asynchronous's Service Call
May 12, 2010I have an process that take about 15minutes to execute. And i have toput this process in a service, and managed his statWell, i placed this process in a service and in some specific pointi have one variable telling me how much % the process have done.So my service reference im my consumer project its typed to let asynchronous calls.When i start my process with a
[Code]...
WCF / ASMX :: WCF Service Returns Blank Data?
Jul 22, 2010I'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]...
WCF / ASMX :: Data Service Skiptoken Not Working
Jan 17, 2011I created a WCF data service and i've set the service config params like;
config.SetEntitySetAccessRule("PROFILEs", EntitySetRights.All);
config.SetEntitySetPageSize("*", 100);
So, in the returned xml feed, the link to goto next page is: <link rel="next" href="http://localhost:4760/oData.svc/PROFILEs?$skiptoken=4105" />
However, if I browse to that url I get an HTTP 404 error "The resource cannot be found."
Also, none of the URI querystrings seem to work.