BizTalk 2002 SQL Adapter
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > BizTalk Server > BizTalk Server Framework > BizTalk 2002 SQL Adapter




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    BizTalk 2002 SQL Adapter  
Jonlar


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
10-16-04 02:09 AM

Hi there
I have Doc specs and map to insert into a sql-table. During tests in Editor
and Mapper there is no error, but when I run this I get:

[0x80004005] Failed to parse the XML Document, please refer to the trace
 log
for more information
[0x0159] The server encountered a transport error while processing the
messaging port "messPutToSQL", which uses a transport component with a ProgI
D
of "AICSQL.SQLPipeline.1".

[0x012b] A transmission attempt failed.


Any clues anyone? The tutorial works just fine...

Simular problem as Judy Harper (in this community). Judy, have you solved
your problems?

Best Regs

/J





[ Post a follow-up to this message ]



    RE: BizTalk 2002 SQL Adapter  
Vikram


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
01-03-05 10:49 PM

Please Tell me if you have solved this issue ... I have a similar issue ...
thank you for the help
Vikram

"Jonlar" wrote:

> Hi there
> I have Doc specs and map to insert into a sql-table. During tests in Edito
r
> and Mapper there is no error, but when I run this I get:
>
> [0x80004005] Failed to parse the XML Document, please refer to the tra
ce log
> for more information
>  [0x0159] The server encountered a transport error while processing th
e
> messaging port "messPutToSQL", which uses a transport component with a Pro
gID
> of "AICSQL.SQLPipeline.1".
>
>  [0x012b] A transmission attempt failed.
>
>
> Any clues anyone? The tutorial works just fine...
>
> Simular problem as Judy Harper (in this community). Judy, have you solved
> your problems?
>
> Best Regs
>
> /J





[ Post a follow-up to this message ]



    Re: BizTalk 2002 SQL Adapter  
Jan Eliasen


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-15-05 10:50 PM

Hi

During the installation of the SQL Adapter, you can also install a
trace utility. The error mentioned below only means that the AIC
couldn't deliver the data to SQL Server. The reasons can be many - use
the trace utility to get a better idea of what went wrong.

Jan Eliasen

On Mon, 3 Jan 2005 14:39:03 -0800, Vikram
<Vikram@discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Please Tell me if you have solved this issue ... I have a similar issue ...
>thank you for the help
>Vikram
>
>"Jonlar" wrote:
> 

--
Jan Eliasen, representing himself and not the company he works for.





[ Post a follow-up to this message ]



    Re: BizTalk 2002 SQL Adapter  
Arjun Luthra [MSFT]


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
02-16-05 01:51 AM

Ensure that the Encoding is correct on the document being passed in.  I
believe the 2002 SQL adapter expects UTF-16 little endian (unicode)
documents without the byte-order-mark.

--
Arjun

"Jan Eliasen" <eliasen@nospam.nospam> wrote in message
 news:vk0411lno78pilv65rlse6tcnsk2plfiv5@
4ax.com...
> Hi
>
> During the installation of the SQL Adapter, you can also install a
> trace utility. The error mentioned below only means that the AIC
> couldn't deliver the data to SQL Server. The reasons can be many - use
> the trace utility to get a better idea of what went wrong.
>
> Jan Eliasen
>
> On Mon, 3 Jan 2005 14:39:03 -0800, Vikram
> <Vikram@discussions.microsoft.com> wrote:
> 
>
> --
> Jan Eliasen, representing himself and not the company he works for.







[ Post a follow-up to this message ]



    Sponsored Links  




 





   All times are GMT. The time now is 12:32 PM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register