SOAP

[DarknFuzzy]

No, not the imperial leather kind!

Hi, not been here in a while.

I have been asked to setup a system which exports data from SQL into a pre defined XML template, not much of an issue. The problem i have is that this then needs to be fired to another system via SOAP and HTTP Post requests. SOAP is something I have never had any experience with or know anything about.

Do we have any SOAP gurus around who could give a quick idea of where to start? I have downloaded a SOAP toolkit from MS however the download page appeared to say I should be using .NET instead.

Any input would be appreciated as I am rapidly getting all confuzzled.

Thx

DnF

[Bomberman]

SQL SOAP services does use .Net, and its generally a way to query the database directly.

I would recmmond building a .Net Web Service (which is SOAP) and only building in access to the data you require.

Get the Visual Web Developer Express to help get started.

[DarknFuzzy]

Thanks for the reply Col, found a couple of articles i'm gonna have a read through.

It's a SQL 2000 box so might struggle a little with some of the functionality.

[Neko]

Far be it from me to agree with Bomberman on a technical issue () but I think he's got the right idea.

Visual Studio for .NET makes web services very easy to implement, and something like Linq to Sql will generate all your data access code for you.

Also SQL2000 really isn't particularly short of features - 2005 brought a few nice things with it, but none of them are essential, and frankly none of them made life easier for the developer. 2000 is probably the easier to work with via being a little bit simpler