VB.Net and PHP communicating through Web Service

[rizwan6feb]

I am working on an application in Vb.NET the pulls data from an online MySQL server. The problem i was facing was that my application had no direct access to internet. The application connects to a proxy server which was blocking access to database server because the proxy server only allowed web requests.

Now i have decided to build a Web Service to send data from my online server to Vb.NET application, I am using PHP at the other end to communicate with MySQL database. This way the application will be based on standard protocols only. This is the point to which i have planned my application.

My question is:
What should be the format of data sent from PHP application to Vb.NET and vice versa. Can i create an XML file which is acceptable by ADO.NET and how will i process DiffGram XML (generated by Vb.NET ) received by the PHP application. I even have no idea how to output XML from using Web Service. I am using NUSOAP in PHP to create SOAP services.

Thanks

[Atli]

Hi.

If the XML generated by your .Net application is valid XML, then PHP can handle it fine.
There are a great many XML handlers in PHP. Take your pick, although I would recommend trying SimpleXML.

PHP can output any data you want. Anything from a string of one's and zero's to an audio recording of your computer sining it to your national anthem. (Granted, the singing could be tricky :P)

My point is that PHP doesn't care what it outputs. I've got my latest project set up to provide XML to my AJAX application by simply printing the XML structure. No XML function or class required.

If you know how your ADO.Net application likes it data, you can have PHP provide it.

[rizwan6feb]

Thanks Atli, I always learn something from your posts

I am sorry for late response actually i started to work on some other application

I still have lot of confusion in my mind as the two applications are communicating through web service not through simple XML. In other words the communication is based on SOAP and I have no idea how to create soap services using SimpleXML as you recommended

I have started with the following PHP and SOAP tutorial

http://www.devarticles.com/c/a/PHP/Building-XML-Web-Services-with-PHP-NuSOAP/

Is there a better way i can develop my application?

[rizwan6feb]

Please help ........

[caraga]

while i read this post as part also of my research as hobby i would also to create a vb.net -> XML -> PHP CRUD and back vice versa PHP -> XML -> vb.net is this possible with 300 users at a time to access back and forth the data.