| Author |
Invalid object name 'xmldata'
|
|
|
| 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
| |
| Nabeel Prior 2004-12-23, 7:46 am |
| 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
| |
|
| Did you check the "Save password" option ? also try using integrated security.
ravi
"red" wrote:
> 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
| |
|
| 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 security.
>
> ravi
>
> "red" wrote:
>
| |
| Nabeel Prior 2004-12-24, 2:46 am |
| 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:
>
| |
|
| 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 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...
>
>
>
|
|
|
|