|
Home > Archive > BizTalk Server Applications Integration > February 2004 > BT Adapter for SQL - Error message
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BT Adapter for SQL - Error message
|
|
| Pedro Ramirezi 2004-02-16, 3:36 am |
| How do I call an SP?
I tried to call one that has a FOR XML AUTO clause in it but I still get the
error message:
Invalid SQL Script found -- "FOR XML AUTO" is required
I have SQLXML 3.0 SP2.
Thanks.
| |
| larry franks 2004-02-16, 5:36 am |
| Hi Pedro, the stored proceedure should have FOR XML AUTO, XMLDATA such as:
=====================================
CREATE PROCEDURE CustOrdersOrdersXMLDATA @CustomerID nchar(5)
AS
SELECT OrderID,
OrderDate,
RequiredDate,
ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderID
FOR XML AUTO, XMLDATA
======================================
Let me know if you have questions on this.
Larry Franks
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| From: "Pedro Ramirezi" <nospam@yahoo.com>
| Subject: BT Adapter for SQL - Error message
| Date: Mon, 16 Feb 2004 10:46:40 -0600
| Lines: 11
| Organization: Proram Inc.
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <ujiY1yK9DHA.2404@TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.biztalk.appintegration
| NNTP-Posting-Host: 64-27-159-98.novacon.net 64.27.159.98
| Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.
phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.biztalk.appintegration:6166
| X-Tomcat-NG: microsoft.public.biztalk.appintegration
|
| How do I call an SP?
|
| I tried to call one that has a FOR XML AUTO clause in it but I still get
the
| error message:
| Invalid SQL Script found -- "FOR XML AUTO" is required
|
| I have SQLXML 3.0 SP2.
|
| Thanks.
|
|
|
| |
| Pedro Ramirezi 2004-02-16, 8:36 am |
| Yep, now it's fine. Thanks.
""larry franks"" <larryfr@online.microsoft.com> wrote in message
news:uAkc2oL9DHA.3860@cpmsftngxa07.phx.gbl...
> Hi Pedro, the stored proceedure should have FOR XML AUTO, XMLDATA such as:
> =====================================
> CREATE PROCEDURE CustOrdersOrdersXMLDATA @CustomerID nchar(5)
>
> AS
>
> SELECT OrderID,
>
> OrderDate,
>
> RequiredDate,
>
> ShippedDate
>
> FROM Orders
>
> WHERE CustomerID = @CustomerID
>
> ORDER BY OrderID
>
> FOR XML AUTO, XMLDATA
> ======================================
>
> Let me know if you have questions on this.
>
> Larry Franks
>
> This posting is provided "AS IS" with no warranties,and confers no rights.
> Subscribe at
>
http://support.microsoft.com/defaul...msdn/nospam.asp
> &SD=msdn
> --------------------
> | From: "Pedro Ramirezi" <nospam@yahoo.com>
> | Subject: BT Adapter for SQL - Error message
> | Date: Mon, 16 Feb 2004 10:46:40 -0600
> | Lines: 11
> | Organization: Proram Inc.
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> | Message-ID: <ujiY1yK9DHA.2404@TK2MSFTNGP12.phx.gbl>
> | Newsgroups: microsoft.public.biztalk.appintegration
> | NNTP-Posting-Host: 64-27-159-98.novacon.net 64.27.159.98
> | Path:
>
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.
> phx.gbl
> | Xref: cpmsftngxa07.phx.gbl microsoft.public.biztalk.appintegration:6166
> | X-Tomcat-NG: microsoft.public.biztalk.appintegration
> |
> | How do I call an SP?
> |
> | I tried to call one that has a FOR XML AUTO clause in it but I still get
> the
> | error message:
> | Invalid SQL Script found -- "FOR XML AUTO" is required
> |
> | I have SQLXML 3.0 SP2.
> |
> | Thanks.
> |
> |
> |
>
|
|
|
|
|