how to receive xml data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

srid - 21 Sep 2006 02:15 GMT

I am developing a vb.net windows application.The backend is sql server2000.
presently company is receiving data in email format. the data entry person
checks the email every hour and enter the new info to the application/db. in
the future the website company will send the data in xml format.
my question:
1)how to write a windows application that listen continuously and receive
incoming xml data from this website and put the data to sql server 2000?
2)is there any built feature in sql server to do this?
3)any advice?
thanks

Reply to this Message

Joseph Bittman MVP MCSD - 08 Oct 2006 06:57 GMT

October 7, 2006

An easy way is for the other company to send you the information through a
web service. The web service can handle multiple calls at the same time, and
your custom logic can insert the data into the SQL DBs. Also, the web
service can run under IIS which makes administration easier.

I'm not sure whether there is a for-sure feature of SQL which can do this...
but Biztalk may be able to help in this case. - You'd have to research more
about this idea because I'm not sure.

Signature

Joseph Bittman
Microsoft Certified Solution Developer
Microsoft Most Valuable Professional -- DPM

Blog/Web Site: http://CactiDevelopers.ResDev.Net/

>I am developing a vb.net windows application.The backend is sql server2000.
> presently company is receiving data in email format. the data entry person
[quoted text clipped - 7 lines]
> 3)any advice?
> thanks

Reply to this Message

srid - 08 Oct 2006 12:55 GMT

thx for the info. i am doing some research on .net namespace

> October 7, 2006
>
[quoted text clipped - 18 lines]
> > 3)any advice?
> > thanks

Reply to this Message

how to receive xml data

Free Magazines