|
Home > Archive > BizTalk Server Applications Integration > March 2004 > SQL Adapter - Stored Proc Error
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 |
SQL Adapter - Stored Proc Error
|
|
| claudio.santos@csit.com.br 2004-03-18, 2:00 pm |
| In the SQL Transport Schema Generation Wizard, after
Generate Script I receive a error: "Failed to execute SQL
statement. Please ensure that the supplied syntax is
correct", but when I use the same structions in the
Select Statement works.
I receive this error for all stored procedures.
Anyone can help me?
Tanks, Claudio Santos
| |
| Jack Blalock 2004-03-18, 2:00 pm |
| This could be two different things:
1. Your stored procudure must have the FOR XML AUTO, XMLDATA in it
2. You could have name resolution issues. Things would work in Query
Analyzer and not in the wizard since we are using dtc and it involves
transactions in dtc which heavily rely and good netbios name resolution. If
this is the case, test by adding a host file entry on the SQL and BTS
machines for each others IP. Then test the wizard. If it works track down
your DNS entries for these servers.
Jack Blalock [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.
| |
| Andre Xavier 2004-03-25, 9:55 am |
| Ok Jack, so I can use only stored procedure that have a
Select Statement? How I can use the FOR XML AUTO, XMLDATA
if I am doing a insert?
| |
| John Plummer [MSFT] 2004-03-25, 12:54 pm |
| If you are using a Stored Procedure for your insert, you need to use the
OPENXML function. Take a look at SQL Server Books On Line where the use of
this function is covered extensively
rgds
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Andre Xavier" <acxavier@bhs.com.br> wrote in message
news:1337e01c41274$8c7ff980$a301280a@phx
.gbl...
Ok Jack, so I can use only stored procedure that have a
Select Statement? How I can use the FOR XML AUTO, XMLDATA
if I am doing a insert?
|
|
|
|
|