|
Home > Archive > BizTalk Server Applications Integration > August 2004 > BTS2004 SQL Adapter Error
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 |
BTS2004 SQL Adapter Error
|
|
| Everett Yang 2004-07-27, 5:53 pm |
| The XML looks good. Have you checked all the column names to make sure
they all match?
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
| |
| Jeff Lynch 2004-07-27, 5:53 pm |
| Everett,
Everything matches the table. I found this in the BTS2004 documentation.
"Database object names (tables, columns, stored procedures, and parameters),
which are retrieved from sysobjects need to be scanned for the following
special characters. ! @ # $ % ^ & * ( ) _ - + = { [ } ] | \ : ; " ' < , > .
? / ~ ` If one or more are present, add an XSD restriction to the schema. "
My table columns currently use the "_" such as "po_date". Could this be
causing the problem? If so, the documentation says to add an XSD
restriction. What is an XSD restriction????
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/
"Everett Yang" <evyang@online.microsoft.com> wrote in message
news:LqzSKGBdEHA.2972@cpmsftngxa10.phx.gbl...
> The XML looks good. Have you checked all the column names to make sure
> they all match?
>
> Sincerely,
>
>
> Everett Yang
> DSI - Microsoft BizTalk Server
>
> This posting is provided “AS IS” with no warranties, and confers no
rights.
> Subscribe at
>
http://support.microsoft.com/defaul...msdn/nospam.asp
> &SD=msdn
>
| |
| Jeff Lynch 2004-07-27, 8:52 pm |
| I've changed all the column names in my table to remove the "_" character
and now the insert works fine. The BTS2004 documentation note (see my
previous post) says if the object name contains a special character such as
"_" then I need to add an XSD restriction to my schema.
Not being an XSD expert, could someone explain what this is and how to add
it using BTS2004?
--
Jeff Lynch
"A BizTalk Enthusiast"
http://dotnetjunkies.com/WebLog/jlynch/
"Jeff Lynch" <jeff.lynch@houston-lynch.com> wrote in message
news:%231LlsqBdEHA.3728@TK2MSFTNGP09.phx.gbl...
> Everett,
>
> Everything matches the table. I found this in the BTS2004 documentation.
>
> "Database object names (tables, columns, stored procedures, and
parameters),
> which are retrieved from sysobjects need to be scanned for the following
> special characters. ! @ # $ % ^ & * ( ) _ - + = { [ } ] | \ : ; " ' < , >
..
> ? / ~ ` If one or more are present, add an XSD restriction to the schema.
"
>
> My table columns currently use the "_" such as "po_date". Could this be
> causing the problem? If so, the documentation says to add an XSD
> restriction. What is an XSD restriction????
>
>
> --
> Jeff Lynch
> "A BizTalk Enthusiast"
> http://dotnetjunkies.com/WebLog/jlynch/
>
>
>
> "Everett Yang" <evyang@online.microsoft.com> wrote in message
> news:LqzSKGBdEHA.2972@cpmsftngxa10.phx.gbl...
> rights.
>
http://support.microsoft.com/defaul...msdn/nospam.asp
>
>
| |
| Everett Yang 2004-08-06, 5:51 pm |
| I will do some research and clarify this part of documentation.
Thanks!
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
| |
| Everett Yang 2004-08-13, 5:51 pm |
| You will need to add a XSD restriction similar to the following:
<xs:simpleType name="BAMName">
<xs:restriction base="xs:Name">
<xs:pattern
value="[^`~!@#$%^&*()+=\[\]{}\|;'"><,\?\\]+" />
</xs:restriction>
</xs:simpleType>
You set the base type on the field you want to modify to string, set
derivation type to “restriction” then build a pattern facet.
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
|
|
|
|
|