Hi,

I am trying out the sql adapter supplied with Biztalk 2004 but I am getting
the following error.

"Failed to execute sql statement. please ensure that the supplied syntax is
correct. Invalid object name 'xmldata'.

when using the Sql transport schema generation wizard. Has any one face this
problem earlier. If so, kindly let me know how to solve this. I am not able
to proceed forward.

Any help will be greatly appreciated. Thanks in advance!

P.S : The connection info provided is correct. I am trying to connect to the
default pubs database in sql server 2000.

Regards,
red

[ Post a follow-up to this message ]

What is the SQL statement you are trying to execute?


--

Kind Regards,

Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx


"red" <red@discussions.microsoft.com> wrote in message
news:17C534C3-CF45-4073-B734-374BF75EF045@microsoft.com...
> Hi,
>
> I am trying out the sql adapter supplied with Biztalk 2004 but I am
> getting
> the following error.
>
> "Failed to execute sql statement. please ensure that the supplied syntax
> is
> correct. Invalid object name 'xmldata'.
>
> when using the Sql transport schema generation wizard. Has any one face
> this
> problem earlier. If so, kindly let me know how to solve this. I am not
> able
> to proceed forward.
>
> Any help will be greatly appreciated. Thanks in advance!
>
> P.S : The connection info provided is correct. I am trying to connect to
> the
> default pubs database in sql server 2000.
>
> Regards,
> red

[ Post a follow-up to this message ]

Did you check the "Save password" option ? also try using integrated securit
y.

ravi

"red" wrote:

> Hi,
>
> I am trying out the sql adapter supplied with Biztalk 2004 but I am gettin
g
> the following error.
>
> "Failed to execute sql statement. please ensure that the supplied syntax i
s
> correct. Invalid object name 'xmldata'.
>
> when using the Sql transport schema generation wizard. Has any one face th
is
> problem earlier. If so, kindly let me know how to solve this. I am not abl
e
> to proceed forward.
>
> Any help will be greatly appreciated. Thanks in advance!
>
> P.S : The connection info provided is correct. I am trying to connect to t
he
> default pubs database in sql server 2000.
>
> Regards,
> red

[ Post a follow-up to this message ]

I have not yet tried integrated security. I will try out and let you know.

I have saved the password. My sa password is "sa". I have tested the
connection and it is successfully.

The sql statement is select phone from authors. This query returns data from
query analyzer.

"ravi" wrote:
[vbcol=seagreen]
> Did you check the "Save password" option ? also try using integrated secur
ity.
>
> ravi
>
> "red" wrote:
> 

[ Post a follow-up to this message ]

You sql statement needs to be

select phone from authors FOR XML AUTO

BizTalk adds ", XMLDATA" at the end when generating the schema - so I think
it is trying to run the following statement:

select phone from authors XMLDATA

--

Kind Regards,

Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx


"red" <red@discussions.microsoft.com> wrote in message
news:E2A413C2-A5C4-45AD-92E3-5875B57BC748@microsoft.com...[vbcol=seagreen]
>I have not yet tried integrated security. I will try out and let you know.
>
> I have saved the password. My sa password is "sa". I have tested the
> connection and it is successfully.
>
> The sql statement is select phone from authors. This query returns data
> from
> query analyzer.
>
> "ravi" wrote:
> 

[ Post a follow-up to this message ]

Thanks a lot Nabeel. It works fine now.

"Nabeel Prior" wrote:

> You sql statement needs to be
>
> select phone from authors FOR XML AUTO
>
> BizTalk adds ", XMLDATA" at the end when generating the schema - so I thin
k
> it is trying to run the following statement:
>
> select phone from authors XMLDATA
>
> --
>
> Kind Regards,
>
> Nabeel Prior
> Web: http://www.brainjar.co.za
> Blog: http://www.brainjar.co.za/blog.aspx
>
>
> "red" <red@discussions.microsoft.com> wrote in message
> news:E2A413C2-A5C4-45AD-92E3-5875B57BC748@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]