Beowulf
13th-January-2007, 07:07 PM
or are you all smelly greasy beggars? (Thought I'd get the oh-so-obvious and oh-so-unfunny jokes out of the way at the onset)
Ok, here's the low-down. We have a legacy application here (and by legacy I mean Noah used it on the Arc!) It's part of our online condition monitoring system it exports data from our various applications into (dare I say it) MS Access where it's chopped , sliced , diced and puréed and mixed into one homogeneous dataset then uploaded via ODBC to our MySQL server where it's later queried by our PHP scripts for web viewing. With me so far?
Our current server is/was a Linux box running Apache and MySQL. We now have a Windows server box, running IIS and are in the process of using ASP to generate the webpages.
However, it's been asked that we look at other ways of getting the data up to the server. and SOAP seems to be they current buzzword in the meetings at the moment. it's been passed from person to person and it's ended up in my lap.
Now I'm familiar with XML and on first inspection SOAP didn't seem to difficult. But can I get the B*ggering thing to work! We've discussed many options, having a local SQL Server database and use their native SOAP tools to pass data up and down from local to t'internet.
However, we're extending the software so our clients can upload their data to the webserver. At the moment they send it to us, we process it and we upload it (ODBC needing direct access to the server) we'd like to upload the data over HTTP or HTTPS from their sites and the processing being done by them , that way they can control how much and how often data is refreshed.
The development platform I'm using is a hodgepodge of ASP.NET , C# (Visual Studio 2005) and there's been discussion of using the .Net compact framework so data can be uploaded over wifi from out Pocket PC data collectors directly
hehe.. I'm drowning in information. There's loads of info out there but it's either so abstract to be useless or so specific for C++ or Apache or something else it doesn't port easily to out development platform.
I know I'd be better asking this on a specific database / web services forum.. but I know there's some very clever people here and I thought I'd ask the question here as well.
Anyone used soap, and can give me any pointers/information?
Thanks in advance.
and please, if at all possible lets us keep the witty and unhelpful comments to the chit chat threads? thanks.
Pete
Ok, here's the low-down. We have a legacy application here (and by legacy I mean Noah used it on the Arc!) It's part of our online condition monitoring system it exports data from our various applications into (dare I say it) MS Access where it's chopped , sliced , diced and puréed and mixed into one homogeneous dataset then uploaded via ODBC to our MySQL server where it's later queried by our PHP scripts for web viewing. With me so far?
Our current server is/was a Linux box running Apache and MySQL. We now have a Windows server box, running IIS and are in the process of using ASP to generate the webpages.
However, it's been asked that we look at other ways of getting the data up to the server. and SOAP seems to be they current buzzword in the meetings at the moment. it's been passed from person to person and it's ended up in my lap.
Now I'm familiar with XML and on first inspection SOAP didn't seem to difficult. But can I get the B*ggering thing to work! We've discussed many options, having a local SQL Server database and use their native SOAP tools to pass data up and down from local to t'internet.
However, we're extending the software so our clients can upload their data to the webserver. At the moment they send it to us, we process it and we upload it (ODBC needing direct access to the server) we'd like to upload the data over HTTP or HTTPS from their sites and the processing being done by them , that way they can control how much and how often data is refreshed.
The development platform I'm using is a hodgepodge of ASP.NET , C# (Visual Studio 2005) and there's been discussion of using the .Net compact framework so data can be uploaded over wifi from out Pocket PC data collectors directly
hehe.. I'm drowning in information. There's loads of info out there but it's either so abstract to be useless or so specific for C++ or Apache or something else it doesn't port easily to out development platform.
I know I'd be better asking this on a specific database / web services forum.. but I know there's some very clever people here and I thought I'd ask the question here as well.
Anyone used soap, and can give me any pointers/information?
Thanks in advance.
and please, if at all possible lets us keep the witty and unhelpful comments to the chit chat threads? thanks.
Pete