WCF / ASMX :: Unable To Access Web Service From Excel VBA
Feb 4, 2011
I 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.
View 4 Replies
Similar Messages:
May 28, 2010
I have added a web service as a reference to a windows application using "AddWebRefrence" option. And I am unable to access the funtions in the web service but instead i get the functionnames followed by the completedeventargs and completedeventhandler.
What am I doing wrong and how can i access the funtions in the web service.
View 3 Replies
May 25, 2010
My 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]....
View 1 Replies
Dec 21, 2010
I 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?
View 2 Replies
Apr 30, 2010
I receive the following error, when trying to consume Wcf service:
"An existing connection was forcibly closed by the remote host". Consuming the service works fine when the host and the client are on the same machine. When I move the client to Hyper-V virtual machine (I didn't try it on a real computer) - it throws the error. Both firewalls are turned off Do you know what can cause such behaviour? Here are the details:
Both the client (hyper-v) and the service are on Windows server 2008 R2
Service url - http://wcftest/CalculatorService.svc (wcftest is the website and is mapped in the hosts file to localhost)
Service config:
[Code]....
Client config:
[Code]....
Are there any configuration settings which I'm missing?
View 1 Replies
Mar 31, 2011
I have a website(X) hosted on a Windows server .
This Website is running under a AppPool= "CustomAppPool" ( Im using a specific AD Username and Password as the credentials for the apppool)
Website Is running under Credentials "DomainNameUsrName"
This Website should access a WCF service which is running under "MAchineNameASPNET" process
When i try to get the details of the calling method (UsrName) from the client calling the WCF ..... Im unable to to do so
I am always gettting the MachineNameASPNET as the credentials
How can i get the "DomainNameUsrName" from the callign website
View 1 Replies
Nov 29, 2010
i have developed a webservice using wcf. and i deployed on IIS 7.
when i try to browse the svc file(http://localhost/service1.svc) it is opening .
But when i browse with ( http://localhost/service1.svc ?wsdl ) it is saying page canot be diplayed.
View 2 Replies
May 24, 2010
I want to access simple web service inside WCF service. How can i achieve it?
View 2 Replies
Oct 28, 2010
I 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
View 1 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
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
Sep 8, 2010
am new to webservice accessing from javascript.I call a webmethod from javascript which returns a string array. whith this array i bind a dropdown list at client.At dropdownList selectedIndexchanged event I found there is no item in DropDownList. Is there any way how to bind the DropDownList using webMethod so that on postback i can get the dropdowns item.
View 3 Replies
Aug 4, 2010
have two different applications. The only access between those two applications is Web Service.I want to delete records in the another application database by passing primary key of that table.I don't have access to database where I have to delete the records.For this, where I have to write the delete functionality.? In web service or or in my application.
View 14 Replies
Apr 29, 2010
How to Access Webservice Webmethod in Javascript
View 4 Replies
Oct 26, 2010
[Code]....
this method i can access using asp.net but not by using a android.. i have checked for the headers etc.. the response is OK in android while debugging but the data is not inserted..
what is the equivalent of stringbuilder in android??
in android i use
StringEntity se = new StringEntity(json.toString());
//and post the data to my service...
post.setEntity(se);
what is the equivalent of stringentity in C# and what can i do for this prob?
View 2 Replies
Mar 29, 2011
In my ASP.net website we are going to use Silverlight to display some interactive diagrams. The users can add, edit and delete various diagrams on the silverlight front end. Silverlight will call Web Service methods to save the changes into the database. Besides the data being passed by silverlight to web service call, we also need to pass some data from the session (like logged on user id etc.) to the web service call.
My question is that how silverlight can access session data? I am trying to pass session information via a webservice method call over to Silverlight but, the session variables inside the web service methods are returning null value.
The Web Service is running under the same web root where the ASP.net website using Silverlight is also hosted. I have made EnableSession = True for web properties.
View 1 Replies
Dec 14, 2010
I have created a dynamic web page . It gets loaded using a file keys.txt. This file holds the keys which are used to display a web page like panels order, text of labels , number of buttons and so on..It is consuming a web service written in delphi. All works fine but when 2 users try to access this service simultaneously then a error is displayed (Internal Server Error 500) "Access violation at address 0040404C in module "accelerate_gateway.dll". Read of address 00000000"Accelerate gateway is the name of delphi web service.It seems to me the problem of multi threading in delphi service ??But I have not done any multi threading in client asp.net page as well. ??It simply creates web service object and access its methods.As I am using a file contents to load a page, so I am concerned if it can create trouble as well ?? . Although I have used FileShare.ReadWrite in it.
View 2 Replies
Jan 26, 2011
I have a silverlight application that uses WCF service and i need to provide windows authentication using wcf.In order to achieve this i am trying to retrieve the client's credentials (windows credentials)inside wcf.
View 1 Replies
Dec 8, 2010
i have added a service reference but i am unable to access the methods, there is a method call "GetContactById" which i can see when i add the service but i am unsure how i can get to this in code. i have tried creating an instance first but i get this error
Error 116 Core.omnetService.OMWCoreSoap' is a 'type', which is not valid in the given context
omnetService.OMWCoreSoap test = omnetService.OMWCoreSoap();
test.GetContactById(strKey, UserId.ToString());
what is the best way to solve this?
View 4 Replies
Jun 16, 2010
Web service is referenced fine (called "tuWs") and I can refer to it in standard web form code behind:
Dim myWs As tuWebSvc.tuWs = New tuWebSvc.tuWs
View 3 Replies
May 15, 2010
I am a newbie to ASP.NET (but not to C#)I have a project I am developing that may seem unconventional at this point but it is a project that I hope to eventually expand and provide a new type of service on the internet. Currently the project makes use of an Excel spreadsheet that is generated by another application I wrote. Basically the spreadsheet is an index to a specific type of file that exists on a host computer and the files are directly linked from within the excel document. When the link is clicked it opens the file using the operating system default program which then processes the file (this takes some time).
This is fine and dandy but when I click on another file, the default program immediately stops processing one file and opens the latest submission and thus interrupting the previous job. To prevent this I am now writing a queuing application. Here is where ASP.NET comes in. I do not want the link to open the queuing application with the file to add into the queue as a parameter because that pops one or more nnoying/scary "you are opening an executable" dialogs and because I want to be able to access the queuing service from a remote computer, and possibily in the future over the web. Instead I am trying to use an ASP.NET service application that will accept the name of a file as a parameter, access the external queue class (defined in an external dll of which only one universal instance is allowed), and add the request to the queue. Whether or not the table is an excel table or on a web page, using a form in this instance is tedious, not only for me but for a user. I want the user to be able to simply click on an html link and have the file be queued without anything except maybe a confirmation page pop up saying that the file has been queued and it will take x amount of time before the file is finished processing.
My problem is I cannot for the life of me find a way to do this. I have searched the interenet for over a week now looking for a way to call a "WebMethod" using a link and I am getting the impression that it cannot be done. Even when I use a form and try to have the form pass a string (representing the file name) as its "action" it comes up with an application error saying that I am missing the parameter I am trying to pass. Here are some examples of what I have tried:Here an example method I would try to access:
[Code]....
Here is an example of how I tried to access directly by way of a link (which results in an application error: InvalidOperationException)"
[Code]....
View 3 Replies
Jan 28, 2010
The extent of my ability is in vba and asp. I'm interested in consuming a SOAP web service from Excel or Access, mostly because it's easier for me. I've also got the wsdls for the web service which is using ws-security. Is this even possible? From what I've read, .net is my logical option, but there's obviously a gap in my skill.
View 1 Replies
Feb 9, 2010
we have a situation where we need to host two certificates on the same server and because we can't have two different certificates on the same server running off the same port we have assigned one certificate run through another port, which is 4443.
So the URL to our web app is now....
[URL]
If I punch this into a web browser I can access it fine, however, if I create a web reference using this URL in Visual Studio (2005) it can create the web reference fine and it builds ok. But whenever I call a web method on this service instance I get a HTTP 404 page not found Exception.
Is there any properties I need to set on the web service object to get this to work? I'm confused as to why it's not working.
View 3 Replies
Dec 15, 2010
We have a customer who are using HP Web Inspect to test for vulnerabilities in our software.
The web inspect tool is complaining about about error messages being returned when a request such as the following is made [URL].
The ASP.Net framework returns a page with the following text content and a 500 status code.
System.IndexOutOfRangeException: Index was outside the bounds of the array.
[code]....
but the error seems not be an unhandled error and so neither 500 page is shown.
View 1 Replies
