July 18, 2005 at 10:59 am
Visual Studio 2003 / C# / SQL Server 2000
Hi,
I am new to all of the technologies listed above....but that is what I am using currently. We are working on a Field System application, which has SQL CE db on the device, talking(Pushing and Pulling) to a SQL Server on a central server.
We have another application running at the hub which is a none SQL/Microsoft application (Progress). We are able to expose elements of our backend system via webservices, and I was wondering if there was anyway I could get the SQL Server backend at the hub to call these webservices? Maybe via stored procedures??
Any advice would be gratefully recieved.
Thanks
Steve
July 18, 2005 at 12:00 pm
Here is my advice:
1.Create a C# Application that Can read data from those services an schedule it so that you can accomplish your goal
2. It is possible to use COM objects from TSQL SQL2000 but it is not recommended specially for webservices calls!!
3. Can you explain what are you trying to do?
4. In SQL2005 there is back-end support built-in to call webservices (but it is still in Beta)
* Noel
July 19, 2005 at 3:26 am
Basically we are trying to write a field system for our current works management system. The main app is written in Progress, and the only real way we can expose it to the field is via web services. Originally I intended to just write a .Net client on the PDAs which would simply call these web services to get the agents jobs etc, but then I was told that the company "has a field system framework already", and that I should try and use that rather than re-inventing the wheel.
The system they have in place at the moment is a .Net client runnning on the PDAs with SQL CE DB on them. Then the backend is a SQL Server, and they just pull and push between these 2 DBs, using SSL Certificates etc. So I am trying to find a way to bolt this SQL tier of the CE Client and the SQL backend onto the top of my Progress web services. So I use the "company framework" to deal with all the connectivity to the field, and managing the security and messaging with that, then once the data hits back to the SQL backend, somehow push this on again to my Progress DB via webservices.
Could you elaborate on your 1st suggestion above? are you saying I just schedule a program to run say every minute or so pole-ing the SQL backend for any transmissions then act upon it? Also, you say that I can call webservices using COM with T-SQL, why is this a no no?
Thanks
Steve
July 19, 2005 at 11:38 am
If the PDAs already have a .NET Client, why not extend the PDA app to call the webservice? Then you are still using the company framework to accomplish your goal. Is this .NET client a third party app?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply