Problem in executing a Web Service in a Window Service

Question

5.00/5 (1 vote)

See more:

Dear Friends,

I am running a window service in which the data is fetched from the access sheet into a datatable and then with the help of foreach loop; A XML file is created in the bin/debug folder of the same project and the same information with the Id and Details is written into the XML file.

Now the Window service will read the data from the XML file and the ID and details for a particular person will be sent to a web method through a web service (of which reference I have added into the window service).

But when I am calling the web method, the window service is not able to copy(or create) the xml file into the specified folder and an error is coming like:- "Error 2 Unable to copy file "obj\Debug\TrackingSystem.exe" to "bin\Debug\TrackingSystem.exe".
The process cannot access the file 'bin\Debug\TrackingSystem.exe' because it is being used by another process. TrackingSystem
" :(

The exception error is coming as: "Client found response content type of 'application/wsdl+xml', but expected 'text/xml'.".

Today exception is coming as: "
MSIL

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.DataException: Connection must be valid and open at executeOperations.insertRecords(String strSQLQuery) in d:\webServiceForPHP\App_Code\connectionClassForMySQL.cs:line 95 at Service.insertStudentDetails(Int32 userId, String dateTime, String inOutStatus) in d:\webServiceForPHP\App_Code\Service.cs:line 27 ---> End of inner exception stack trace --->

".

The window service is running absolutely fine if I don't use the Web Method (through web service).

Kindly help :)

Thanks

Varun Sareen
Software Developer

Posted 26-Sep-10 20:57pm

Varun Sareen

Updated 27-Sep-10 19:39pm

v3

Add a Solution

Comments

DavidKiryazi 27-Sep-10 5:34am

Hi Varun,

Have you tried to access the webservice through internet explorer and seeing what result you get for a particular query?

The error sounds like it has something to do with the way the webservice is being configured and the permissions for its use. I had a similar problem when I was doing webservices, (but dont know much about them and cant remember how i ended up fixing the problem)

Varun Sareen 28-Sep-10 1:00am

Dear David,

I have executed and tested the web service through a windows based application and it is running absolutely fine and showing appropriate results also.

Now as mentioned in question I am trying to access it through a window service but not able to execute the same. :( and getting the following error:-

"Client found response content type of 'application/wsdl+xml', but expected 'text/xml'."

2 solutions

Solution 1

Hi David,

Check if the location where you copy the file to has enough permissions to copy it. You can even check the permission and try to paste it there.

Posted 27-Sep-10 20:16pm

ashokbusybee

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)

Varun Sareen · Accepted Answer · 2010-09-27T20:45:00

Dear Friends,

Thanks to all for the nice suggestions but i solved the problem myself. Actually I was calling the window service after every 1 sec and the web service was not getting much time to open the connection to MYSQL.

So, i increased the time of the window service call and hence the problem is solved.

Varun Sareen
Software Developer