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.