Hey we have a project in which a company produces a XML page in reply to
actions on it's site.
I see that SQL 2000 works well with XML so Can someone point me in the right
direction,
I would like to take the XML from thier SQL and have it "post" to own sql
server (add,create, data, modifity and delete data on the fly).
I was looking at doing XML to HTML and then passing to some a ASP but if we
can grab from the responsetext then we could save time and headaches.
Now I really know next to nothing about XML but I am reading all the
newsgroups and pulled now TONS of xml / sql stuff to play with.
So should I be looking at openxml or what
Background info..
we run server 2000 / SQL 2000 and have good ASP / SQL programmers on staff
(not me)
Below is the data which comes back from our "POST" to their server.
Our customer go to "our" website they fill in forms the forms are posted to
our server
and to a second compaines server which then response to the post with the
the xml data which we are at this time using MANY work arounds to get the
data into our database.
We have all the client data in our sever we just need to "post" the currenty
status code to the customer records.
------------------>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE CDR SYSTEM "http://theotherdomain.com/xml/push/cdr.dtd">
<CDR>
<ClientID>RETURN_id_1</ClientID>
<DID>Deliv_Id_1</DID>
<Status="100" Description="Successful"/>
<Product>
<ClientTID>RETURN_id_2_1</ClientTID>
<DID>-1</DID>
<Status="101" Description="Service not needed at this time"/>
</Product>
</CDR>
Thanks for any and all help.
Bubba
<---------------------------------------------------------------------