BizTalk Server General - Biztalk 2004 SQL Adapter only support For XML Auto?

Author

Biztalk 2004 SQL Adapter only support For XML Auto?

EastOx

2004-07-19, 5:52 pm

Hi, There:
I got the answer from some post, which answer by Microsoft support Rep. It said, Biztalk SQL Adapter only support For XML Auto. not For XML Explicit. We have Biztalk 2002 running with SQL SP using for xml explicit, which fix by downloading add on plugin f
rom Microsoft. We are now moving to 2004 version. Anybody know how to fix it for the new version.
If we can only use For XML Auto with SQL query. Any good way to map un-controlale auto generated level nest nodes schema to expected nested nodes schema?

Any help will be very appreviated! Thanks.

Darrin Curtis [MSFT]

2004-07-19, 5:52 pm

Hi,

The BizTalk 2004 SQL Adapter only supports 'XML AUTO' and 'XML AUTO,
ELEMENTS'. However, BizTalk 2004 does have a very nice Mapper for mapping
one schema to another. This might work very well for you.

Thanks,
Darrin
--------------------[vbcol=seagreen]
It said, Biztalk SQL Adapter only support For XML Auto. not For XML
Explicit. We have Biztalk 2002 running with SQL SP using for xml explicit,
which fix by downloading add on plugin from Microsoft. We are now moving to
2004 version. Anybody know how to fix it for the new version.[vbcol=seagreen]
un-controlale auto generated level nest nodes schema to expected nested
nodes schema?[vbcol=seagreen]

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

Neal Walters

2004-10-06, 5:51 pm

Darrin,

Are you 100% positive that Biztalk 2004 does not support "FOR XML
EXPLICIT"?

I'm reading help page:
ms-help://BTS_2004/Operations/htm/ebiz_prog_adapt_tbdk.htm

and it does not state any such limitations. Is the doc just wrong or vague
on this subject?

Yes, "for xml explicit" it has caused a problem so for now we have switched
to XML AUTO, but we have an upcoming requirement where it will be useful or
mandatory.

Neal Walters
http://Biztalk-Training.com

Darrin Curtis [MSFT]

2004-10-07, 5:47 pm

Neal,

Yes, I am sure that BizTalk 2004 SQL Adapter is not supported when using
"FOR XML EXPLICIT."

If you look at
http://www.msdn.microsoft.com/libra...y/en-us/operati
ons/htm/ebiz_ops_adapt_sql_esig.asp it does explicitly say that "XML AUTO"
and "XML AUTO, ELEMENTS" are support and "XML RAW" is not supported, but it
does not say anything about "FOR XML EXPLICIT." I will try to get this
corrected in the next doc refresh.

I am sorry for the confusion here.

Thanks,
Darrin

--------------------[vbcol=seagreen]
<CZky3PebEHA.3848@cpmsftngxa06.phx.gbl>[vbcol=seagreen]
vague[vbcol=seagreen]
switched[vbcol=seagreen]
or[vbcol=seagreen]

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team

Tony

2004-10-07, 5:47 pm

Well, VS.NET will generate error when tried to generate schema with SQL
Adapter with For XML Explicit.
But you can manually create schema "SQLService.xsd", it will work with SP
with For XML Explicit. My configuration and schema works well.

"Darrin Curtis [MSFT]" wrote:

> Neal,
>
> Yes, I am sure that BizTalk 2004 SQL Adapter is not supported when using
> "FOR XML EXPLICIT."
>
> If you look at
> http://www.msdn.microsoft.com/libra...y/en-us/operati
> ons/htm/ebiz_ops_adapt_sql_esig.asp it does explicitly say that "XML AUTO"
> and "XML AUTO, ELEMENTS" are support and "XML RAW" is not supported, but it
> does not say anything about "FOR XML EXPLICIT." I will try to get this
> corrected in the next doc refresh.
>
> I am sorry for the confusion here.
>
> Thanks,
> Darrin
>
> --------------------
> <CZky3PebEHA.3848@cpmsftngxa06.phx.gbl>
> vague
> switched
> or
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBusiness Server Team
>
>

Niklas E

2004-11-09, 7:46 am

I use for xml explcit in my SP which returns data to BizTalk's SQL Adapter
so it works. The schema could not be generated if I remember correctly, so
you have to make that yourself. I think I did some other similar thing with
for xml auto which could generate a schema and then altered that generated
schema afterwards and then changed the SP to use for xml explicit.

MS:
Perhaps you could fix this manual hack so we can "Do more with less" in the
future?

Best regards
Niklas E

"Tony" <Tony@discussions.microsoft.com> wrote in message
news:5B9B92EF-20AB-4E48-993E-BD0BE2AABD71@microsoft.com...[vbcol=seagreen]
> Well, VS.NET will generate error when tried to generate schema with SQL
> Adapter with For XML Explicit.
> But you can manually create schema "SQLService.xsd", it will work with SP
> with For XML Explicit. My configuration and schema works well.
>
> "Darrin Curtis [MSFT]" wrote:
>
http://www.msdn.microsoft.com/libra...y/en-us/operati[vbcol=seagreen]
AUTO"[vbcol=seagreen]
it[vbcol=seagreen]
<NealWalters@discussions.microsoft.com>[vbcol=seagreen]
useful[vbcol=seagreen]
rights.[vbcol=seagreen]

Darrin Curtis [MSFT]

2004-11-19, 5:48 pm

Thank you for your feedback.

We are aware that many people would like support of XML EXPLICIT and we are
looking at our options.

Currently, you many get this to work, but there are many cases where it
might not. And right now, we connot support you if you do use XML EXPLICIT.

Thanks,
Darrin
--------------------[vbcol=seagreen]
<CZky3PebEHA.3848@cpmsftngxa06.phx.gbl>
<A4DD6213-577A-4DC7-9472-7914938937E2@microsoft.com>
<amB4ZsJrEHA.740@cpmsftngxa06.phx.gbl>
<5B9B92EF-20AB-4E48-993E-BD0BE2AABD71@microsoft.com>[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl[vbcol=seagreen]
with[vbcol=seagreen]
the[vbcol=seagreen]
SP[vbcol=seagreen]
using[vbcol=seagreen]
ti[vbcol=seagreen]
but[vbcol=seagreen]
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl[vbcol=seagreen]
XML[vbcol=seagreen]
or[vbcol=seagreen]

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team