BizTalk Server Applications Integration - AIC SQL Quotation Mark Problem

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server Applications Integration > April 2004 > AIC SQL Quotation Mark Problem





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 AIC SQL Quotation Mark Problem
Phil

2004-03-20, 9:23 pm

Does anyone know why I get a particular Transmission
failure when using BizTalk with AIC SQL Adaptor to write
to an SQL database via a Stored Procedure? The failure
only occurs when field data contains either a literal "
(quotation mark) or the " (entity encoding)! This
data parses correctly and is well formed XML. All other
XML special characters work fine (> < ' &)
except this one. In fact, a literal quotation mark (")
gets converted to " but still fails with a
Transmission error. Answers to this problem much
appreciated.

Phil Wales UK.

Roger Jerrell

2004-04-19, 12:36 pm

Hello Phil,

Did you ever get resolution to this issue. We are having the same issue. Any
assistance is greatly appreciated.

Roger Jerrell

Tampa, FL USA



"Phil" <anonymous@discussions.microsoft.com> wrote in message
news:1021c01c40dc0$0dedb2a0$a401280a@phx
.gbl...
> Does anyone know why I get a particular Transmission
> failure when using BizTalk with AIC SQL Adaptor to write
> to an SQL database via a Stored Procedure? The failure
> only occurs when field data contains either a literal "
> (quotation mark) or the " (entity encoding)! This
> data parses correctly and is well formed XML. All other
> XML special characters work fine (&gt; &lt; ' &)
> except this one. In fact, a literal quotation mark (")
> gets converted to " but still fails with a
> Transmission error. Answers to this problem much
> appreciated.
>
> Phil Wales UK.
>



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com