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

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]

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
>
>

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]