2008年4月15日

[BizTalk] SQL Adapter 0x8000405 error

When querying database via SQL adapter, I got a 0x8000405 error on event log

SQL Adapter send/receive Xml data, when creating SQL request/response xml schema, we need to add "for xml auto,xmldata" in your stored procedule so the wizard can have xml schema returned from stored procedule.

After schema is generated, you will need to remove "xmldata" from your stored procedule, or 0x800405 error will be logged, and your query failed with the following error description "Streaming not supported over multiple column result".

沒有留言:

Blog Archive

About Me