xml parse error: an invalid character was found in text content

[delfy]

i am getting the error i stated in the subject when i pass my xml file to sql server here is a sample of of it

i still get the same error even after i change the first line to <?xml version="1.0" encoding="windows-1251"?> am i missing something?

<?xml version="1.0" encoding="UTF-8"?><ORDINARY_SHARE>
<ORDINARY_SHARES>
<FiftyTwo_Week_High>65.00</FiftyTwo_Week_High>
<FiftyTwo_Week_Low> 20.00</FiftyTwo_Week_Low>
<Security>BNSJ</Security>
<Prev_Yr_Div>2.13</Prev_Yr_Div>
<Current_Yr_Div> 1.25</Current_Yr_Div>
<Volume_non_block> 1,077,063</Volume_non_block>
<Todays_High> 20.50</Todays_High>
<Todays_Low> 20.00</Todays_Low>
<Last_Sale> 20.50</Last_Sale>
<Change> 0.50</Change>
<Closing_Bid> 20.00</Closing_Bid>
<Closing_Ask> 20.50</Closing_Ask>
</ORDINARY_SHARES>
</ORDINARY_SHARE>

 

[Ropje]

Seems to be nothing wrong..
Maybe it's SQL server that doesn't like the comma's in 1,270,957 ??

gr Rop

 

[Ropje]

I mean 1,077,063, of course

 

[delfy]

ok i took out the commas and i am still getting the same message

 

[JontyMC]

This XML is fine. You say it's a sample, there must be a problem elsewhere.

Jon

"I don't regret this, but I both rue and lament it.

 

[delfy]

Ok thanks i think the problem lies in the app that i am using to pass it to sql server 2000 because i parsed the whole file online and no errors were found. seem as if the the string type i am using has something that is conflicting with sql server's xml parser.