problem: how to connect XML in java to SQL server , and how to add a record

[daphne]

Hello,
I have the problem is how to connect XML in java to microsoft SQL server
7.0, and i don't know how to add a record in XML document and SQL server
database. Hope anyone can help me .Hope can with an example source code.
Thank you
from daphne

[Sathya]

Hi Daphne,

There is XMLDOM component which is supported by Microsoft. You add that DLL
into your application. Then you can declare like this.
Dim xmlDoc

Set xmlDoc = Server.CreateObject("MSXML.DOMDocument")

xmlDoc.async = False
xmlDoc.validateOnParse = true


After adding all the elements, atttributes into your XML document you can
save your XML file.


"daphne" <daphneyem@mail.com> wrote:
>
>Hello,
>I have the problem is how to connect XML in java to microsoft SQL server
>7.0, and i don't know how to add a record in XML document and SQL server
>database. Hope anyone can help me .Hope can with an example source code.
>Thank you
>from daphne