|
Home > Archive > BizTalk Server General > December 2005 > Failed to get Schema, SQL Excute might have return error. Please
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 |
Failed to get Schema, SQL Excute might have return error. Please
|
|
|
| error: Failed to get Schema, SQL Excute might have return error. Please
check that you have valid connection and valid script."
I really need someone help me to solve this problem.
I wrote a simple stored procedure which I only select one record from
one table, then I use BizTalk Adapter to create a job for creating XML
file by selecting the procedure from SQL database,
it give the error msg:"
Failed to get Schema, SQL Excute might have return error. Please check
that you have valid connection and valid script."
1. first we thought it may be connection problem, so we wrote a select
statement, directly selecting a record from a table same as in the
procedure, it runs, and generates XML file, the script in the procedure
is very simple, like "select * from counties". it looks like connetion
is ok.
2. about the script just very simple statement, don't see any thing
wrong.
is anyone who had same problem before can help me , please give me a
hint, show us how to solve this problem, do I need add a patch or
extra config file into BizTalk Adapter in order let BizTalk Adapter
link to SQL server smothly.
by the way, the SQL server I am using is SQL 2000, and BizTalk Adapter
for BizTalk 2002
thanx
Julie
|
|
|
|
|