|
Home > Archive > BizTalk Server General > March 2006 > syntax incorect for sql statements?
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 |
syntax incorect for sql statements?
|
|
| Luis Esteban Valencia 2005-07-15, 5:55 pm |
| Hello I am using the add generated items. Add adapter. Sql. Receive Port.
When I choose select statement or stored procedure it always gives me a
syntax error
for stored procedure
exec [seleccionarCustmers]
Failed to execute statement, ensure the sql syntax is correct, I execute
this on query analyzer and it works perfectly.
If use a select
select * from customers where sent=0
Failed to execute stament,Please ensure the sql syntax is incorrect Invalid
object name xmldata.
What I need to do is to listen to sql server table if sent=0 it must then
insert in an oracle database, after it, it must update the sent rows with
sent=1.
| |
| Doug Girard [MSFT] 2006-03-25, 11:38 am |
| Please review the "Workign with BizTalk Adapter for SQL Server" article in
our documentation.
http://msdn.microsoft.com/library/d...-us/BTS_2004WP/
html/74cfc9d0-0974-4f4a-81f5-6768ff245df1.asp
You are probably not returning the result set as XML. Are you using the
FOR XML AUTO clause in your query statements and stored procedures?
HTH,
Doug Girard [MSFT]
Note: This posting is provided "AS IS" with no warranties, and confers no
rights.
--------------------
>From: "Luis Esteban Valencia" <levalencia@avansoft.com>
>Subject: syntax incorect for sql statements?
>Date: Fri, 15 Jul 2005 08:44:21 -0500
>Lines: 22
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.0
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Message-ID: <OeRNuJUiFHA.1460@tk2msftngp13.phx.gbl>
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: 200.124.170.10
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:15631
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hello I am using the add generated items. Add adapter. Sql. Receive Port.
>When I choose select statement or stored procedure it always gives me a
>syntax error
>
>for stored procedure
>exec [seleccionarCustmers]
>
>Failed to execute statement, ensure the sql syntax is correct, I execute
>this on query analyzer and it works perfectly.
>
>If use a select
>
>select * from customers where sent=0
>Failed to execute stament,Please ensure the sql syntax is incorrect Invalid
>object name xmldata.
>
>What I need to do is to listen to sql server table if sent=0 it must then
>insert in an oracle database, after it, it must update the sent rows with
>sent=1.
>
>
>
>
|
|
|
|
|