Questions on SQLXML

Hello all,
Newbie here and have a few questions. I wish to use the classes
SqlXmlAdapter,SqlXmlCommand,etc in my ASP.NET project but when I add
'using Microsoft.Data.SqlXml', the IDE doesn't see the namespace. I
tried to add the reference but I dont see it.
1. Why is that? Do I have to download and install SqlXml 3.0 SP2? Does
that add the namespace? I searched for Microsoft.Data.SqlXml.dll on my
hard drive and didn't find it.
2. If I do need to install this patch, why can I do a "Select * from
Product FOR XML AUTO" and have it work already? Does SQL need this
patch or is it a development thing.
3. What does this patch change. I don't mind installing it on my
development PC but kinda worried about my production server. Can I
uninstall this if anything goes wrong?
4. Production server is Windows Server 2003. I am using Windows
Professional. Does WinSvr 2003 need this patch?
5. The patch has XML 3.0 in it. Is this install xml 3.0 or 4.0? I have
already installed MSXML 4.0 on my production server, would installing
this patch downgrade it to xml 3.0 if in fact it is install xml 3.0?
Thanks
Ralph Krausse
www.consiliumsoft.com
Use the START button? Then you need CSFastRunII...
A new kind of application launcher integrated in the taskbar!
ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg
Some, but not all, answers below.
Best regards
Michael
"Ralph Krausse" <gordingin@.consiliumsoft.com> wrote in message
news:49eb6317.0408191143.37ca057f@.posting.google.c om...
> Hello all,
> Newbie here and have a few questions. I wish to use the classes
> SqlXmlAdapter,SqlXmlCommand,etc in my ASP.NET project but when I add
> 'using Microsoft.Data.SqlXml', the IDE doesn't see the namespace. I
> tried to add the reference but I dont see it.
> 1. Why is that? Do I have to download and install SqlXml 3.0 SP2? Does
> that add the namespace? I searched for Microsoft.Data.SqlXml.dll on my
> hard drive and didn't find it.
Yes, you need SQLXML 3.0 (SP1 or SP2) downloaded.

> 2. If I do need to install this patch, why can I do a "Select * from
> Product FOR XML AUTO" and have it work already? Does SQL need this
> patch or is it a development thing.
That is because FOR XML is a server side command that is executed on the
database server and not part of ASP.Net or any other mid-tier component.

> 3. What does this patch change. I don't mind installing it on my
> development PC but kinda worried about my production server. Can I
> uninstall this if anything goes wrong?
It fixes some bugs and adds identity propagation for Bulkload.
I don't know about uninstall, but I assume that you can.

> 4. Production server is Windows Server 2003. I am using Windows
> Professional. Does WinSvr 2003 need this patch?
WinSvr 2003 does not ship with SQLXML. So you need the ASP.Net enabled
version downloaded.

> 5. The patch has XML 3.0 in it. Is this install xml 3.0 or 4.0? I have
> already installed MSXML 4.0 on my production server, would installing
> this patch downgrade it to xml 3.0 if in fact it is install xml 3.0?
No. MSXML 4.0 should not be affected by you installing SQLXML 3.0.

>
>
>
> Thanks
> Ralph Krausse
> www.consiliumsoft.com
> Use the START button? Then you need CSFastRunII...
> A new kind of application launcher integrated in the taskbar!
> ScreenShot - http://www.consiliumsoft.com/ScreenShot.jpg