|
Home > Archive > BizTalk Server General > April 2004 > SQL Adapter and Char datatype?
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 |
SQL Adapter and Char datatype?
|
|
| Johanna Rossi 2004-04-26, 5:35 am |
| Hi All!
Why can't I use SQL Adapters receive function with SQL datatype Char?
I tried using updategram and Stored Proc but both failed giving an error
message.. something like XML Schema doesn't support data type Char...
I also tried Select clause with convert command like tihis "SELECT
CONVERT(varchar(xx), column) AS ColumnName FROM table for xml auto" in both
the updategram and the stored procedure. Both failed.
So my question is, how to read a table with char datatype information?
Thanks in advance,
Johanna
| |
| Johanna Rossi 2004-04-26, 9:37 am |
| Has this got someting to do with the SQL Server Service Pack level?
The remote server I'm trying to read from succees to insert data with SQL
adapter but fails on read attemps unless the data is not in char format.
I'm talking about BTS2004 native SQL Adapter here..
"Johanna Rossi" <johanna.rossi@kotiportti.fi.invalid> wrote in message
news:enO0Vz2KEHA.3596@tk2msftngp13.phx.gbl...
> Hi All!
>
> Why can't I use SQL Adapters receive function with SQL datatype Char?
> I tried using updategram and Stored Proc but both failed giving an error
> message.. something like XML Schema doesn't support data type Char...
>
> I also tried Select clause with convert command like tihis "SELECT
> CONVERT(varchar(xx), column) AS ColumnName FROM table for xml auto" in
both
> the updategram and the stored procedure. Both failed.
>
> So my question is, how to read a table with char datatype information?
>
> Thanks in advance,
> Johanna
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.668 / Virus Database: 430 - Release Date: 24.4.2004
| |
| Matt Milner 2004-04-26, 11:35 pm |
| just change your schema from char to xs:string. This should fix it up for
you. If you want, you can use the restriction feature to limit the size of
the string.
Matt
"Johanna Rossi" <johanna.rossi@kotiportti.fi.invalid> wrote in message
news:eKSUL64KEHA.2236@TK2MSFTNGP09.phx.gbl...
> Has this got someting to do with the SQL Server Service Pack level?
> The remote server I'm trying to read from succees to insert data with SQL
> adapter but fails on read attemps unless the data is not in char format.
> I'm talking about BTS2004 native SQL Adapter here..
>
>
> "Johanna Rossi" <johanna.rossi@kotiportti.fi.invalid> wrote in message
> news:enO0Vz2KEHA.3596@tk2msftngp13.phx.gbl...
> both
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.668 / Virus Database: 430 - Release Date: 24.4.2004
>
>
| |
| Johanna Rossi 2004-04-27, 4:35 am |
|
Hmm.. I haven't get that far with the adapter wizard. After finishing the
select clause, the last part of the wizard, it fails so the schema get never
created.
"Matt Milner" <matt.milner@m3technologypartners dot com> wrote in message
news:#uGIfWALEHA.1348@TK2MSFTNGP12.phx.gbl...
> just change your schema from char to xs:string. This should fix it up for
> you. If you want, you can use the restriction feature to limit the size
of
> the string.
>
> Matt
> "Johanna Rossi" <johanna.rossi@kotiportti.fi.invalid> wrote in message
> news:eKSUL64KEHA.2236@TK2MSFTNGP09.phx.gbl...
SQL[vbcol=seagreen]
error[vbcol=seagreen]
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.668 / Virus Database: 430 - Release Date: 24.4.2004
|
|
|
|
|