XMLPort problem with Cornous database

navnoob
Member Posts: 26
Hi, I am playing with the XML port and trying to export the Cornous's Customer table to my hard drive as an xml file. The export is fine, but when I want to open the xml file either in a web browser, datagrid from .NET, it keep telling me
Exception System.Xml.XmlException was thrown in debuggee:
'.', hexadecimal value 0x00, is an invalid character.
from the C# compiler
and
XML Parsing Error: not well-formed
Location: file:///C:/test.xml
from web browser.
However, If i open the exported XML file from notepad, and resave it, I can see the XML file through my browser and datagrid.
So what is causing that problem? And is there a way to be able to export the table without having 0x00 character or something in it? Beecause I want to retrieve an xml from the messaging queue and display to a datagrid, but each time i do a dataset.readXml(msg.BodySteam); It'll keep crashing due to weird character somehow from the XML file that is export through xmlport..
Any help is appreciated.
Thanks.
Exception System.Xml.XmlException was thrown in debuggee:
'.', hexadecimal value 0x00, is an invalid character.
from the C# compiler
and
XML Parsing Error: not well-formed
Location: file:///C:/test.xml
from web browser.
However, If i open the exported XML file from notepad, and resave it, I can see the XML file through my browser and datagrid.
So what is causing that problem? And is there a way to be able to export the table without having 0x00 character or something in it? Beecause I want to retrieve an xml from the messaging queue and display to a datagrid, but each time i do a dataset.readXml(msg.BodySteam); It'll keep crashing due to weird character somehow from the XML file that is export through xmlport..
Any help is appreciated.
Thanks.
0
Comments
-
Try to open the XML in some editor allowing to view it in Hexadecimal. Search for the 00 character. Can you post the example, where the character is placed in the file?0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions