MS SQL XML - Remote XML transfer

Author

Remote XML transfer

grumpy

2006-01-26, 5:16 pm

hello there,

I currently have a vb client application that outputs details to a well
formed xml document.

my question is, how can i send this information (automated) to my sql server
2005 ?

Im able to load the xml document locally, into a xml datatype and retrive it
fine, however the need is to complete this from a cleint machine across a
network.

I have looked for many examples but none seem to fit what im after.

any one help ?

regards

russ.

Galex Yen [MSFT]

2006-01-27, 8:24 pm

If you are using VB.NET then you can use ADO.NET to either insert the xml
into a table or pass the xml as a parameter to a stored procedure.

For an example of how this can be done in ADO.NET 2.0 see:

http://msdn.microsoft.com/data/Data.../sqlxml_ado.asp

Regards,
Galex Yen

"grumpy" wrote:

> hello there,
>
> I currently have a vb client application that outputs details to a well
> formed xml document.
>
> my question is, how can i send this information (automated) to my sql server
> 2005 ?
>
> Im able to load the xml document locally, into a xml datatype and retrive it
> fine, however the need is to complete this from a cleint machine across a
> network.
>
> I have looked for many examples but none seem to fit what im after.
>
> any one help ?
>
> regards
>
> russ.
>
>
>
>
>

Sponsored Links