TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Only Saturn
NA
1
1.6k
C# Response from XMLA (using BW SAP) french characters as ??
Apr 2 2014 11:01 AM
Hi,
I am using .Net Framework 4 C# web service project.
I am connecting with XMLA server (using as web reference) in my C# project. The issue seems to be able to handle the French characters once i am getting response back from the XMLA execute method.
At this moment the data is coming back as '??' whenever it contains french special characters.
I am pasting the code below and would appreciate help at earliest.
sapqasbwi.MsXmlAnalysis _sMxlA = new sapqasbwi.MsXmlAnalysis(); // Create XMLA reference object.
System.Net.NetworkCredential _nc = new System.Net.NetworkCredential(); // Creating Network credentials object
_nc.UserName = userid;
_nc.Password = _password;
_sMxlA.Credentials = _nc.GetCredential(new System.Uri(url), "Basic");
_sMxlA.Url = url;
sapqasbwi.ExecuteCommand cmd = new sapqasbwi.ExecuteCommand();
cmd.Statement = stText; // sText contains the query
_bwPropertyList.DataSourceInfo = "default";
_bwPropertyList.Format = "Tabular";
_bwPropertyList.AxisFormat = "ClusterFormat";
_bwPropertyList.Content = "SchemaData";
_bwParameters.PropertyList = _bwPropertyList;
_sMxlA.RequestEncoding = System.Text.Encoding.GetEncoding("ISO-8859-1"); // already tried utf 8
//Execute BW Query
System.Xml.XmlElement returnXML;
returnXML = _sMxlA.Execute(cmd, _bwParameters); // Execute method only returns an XML element object.
This particular object is containing the '??' whenever a french character is found.
Please help at earliest.
Regards
Saturn
Reply
Answers (
0
)
Second entry gives data missing error
Object Reference Not Set To An Instance Object in Gridview