Importing Error: string

Showing posts with label string. Show all posts

Monday, March 26, 2012

report data with different char-set other than english

In my report i have to display data from sql db which has this data string in
Russian language. The report object and the text box object have a very
promising property
called: language but setting this property to the required language is not
helping.
How can i make my report to display this data. We changed the language
seeting and IE encoding settging to view the data in the report to the
correct format but its not working. So far what we found is either the report
or reporting services is escaping the high (over 128) characters in the HTML
page.
Any input is appreciated.
--
TIA
-PSHello PS,
I would like to know this issue clearly.
Did you mean that you want to show the text which is in Russian and stored
in SQL Server database?
If so, I don't think you need to do any configuration in the reporting
service and the textbox will show what you stored in the SQL server
database.
Could you please let me know more clearly about which data you stored in
SQL Server and what you want to show up?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the reply!
Yes i want to just display the text (Russian language data) in the report so
that user can read the data in Russian language without any problem. The data
is stored in the sql server by another application and we just use sql query
in report to select the data and display it in the report. We are able to
see the same data that is stored in the sql server in the report but the data
is not readable. It is like this "Iiia? aa. AAeeoae." in report. when we
select the data from query analyser it shows the same data("Iiia? aa.
AAeeoae.") which is not readble in russian lang.
When we put this data in a sample html page and set the enocding to
"Cyrillic (Windows) it is readable by russian user. But when we open the
report in report manager and set the encoding in the browser to "Cyrillic
(Windows) it is not readable. what we have to do in reports to make it
readable? we tired the report object and the text box language property to
the russian lang setting but we still get the same junk data. I hope this
--
TIA
-PS
--
TIA
-PS
"Wei Lu [MSFT]" wrote:
> Hello PS,
> I would like to know this issue clearly.
> Did you mean that you want to show the text which is in Russian and stored
> in SQL Server database?
> If so, I don't think you need to do any configuration in the reporting
> service and the textbox will show what you stored in the SQL server
> database.
> Could you please let me know more clearly about which data you stored in
> SQL Server and what you want to show up?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello PS<
I would like to know the data type of your problem column and you could
send me the sample HTML file to get the data and show up correct.
I guess you are using the varchar data type for the data and varchar data
type did not support the unicode. If you insert the Unicode char into it,
it will convert into some unreadable format and you may not conver it back
directly.
I would like to suggest you modify the application which insert the data
into your sql server.
Here is a sample to insert and retrieve the unicode data for varchar data
type. Or you may consider to use the Nvarchar data type.
drop table Russia
create table Russia (id int, mytext varchar(100))
insert Russia values (3, cast(cast (N''as varbinary(100)) as varchar(100)))
select id, cast (convert(varbinary(100), mytext)as nvarchar(100)) from
Russia
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for the reply.
I changed the varchar data type column to Nvarchar data type as you said but
still getting the same issue. will my old data will be converted to nvarchar
type after changing just the column data type to nvarchar?
Regarding the html output here is the sample html snip from reporting
service. see the russian char are displayed as "#238;Ã¬.." (reporting services
is escaping the high characters) when i view source from the IE.
In the browser output it is displayed as something like this .."Ã?Ã«Ã¨Ã²Ã¥Ã«"..
when i applied the correct enocding in the IE and i still cannot view
correctly
<html>
<head>
</head><body>
Snip from Reporting Services <br>
/*+ RULE ORDERED INDEX(C IDX_TDC_PS_COST) */
N.CALLING_PARTY_NUMBER_RID as "Ã?Ã®Ã¬Ã¥Ã° Ã Ã¡. Ã?",
N.CALLED_PARTY_NUMBER as "Ã?Ã®Ã¬Ã¥Ã° Ã Ã¡. Ã?",
C.call_start as "Ã?Ã Ã²Ã ",
N.CALL_DURATION as "Ã?Ã«Ã¨Ã²Ã¥Ã«.",
decode (CALL_DIRECTION, 'O',
</html>
Below is the sample html that i consturted manually with russian data from
db directly. When i use the correct encoding i'm able to view the russioan
data
<html>
<br><br>
Non escaped high characters will convert properly with the browsers View |
Encoding | Cyrllic (Windows) <br>
/*+ RULE ORDERED INDEX(C IDX_TDC_PS_COST) */
N.CALLING_PARTY_NUMBER_RID as "Ã?Ã®Ã¬Ã¥Ã° Ã Ã¡. Ã?",
N.CALLED_PARTY_NUMBER as "Ã?Ã®Ã¬Ã¥Ã° Ã Ã¡. Ã?",
C.call_start as "Ã?Ã Ã²Ã ",
N.CALL_DURATION as "Ã?Ã«Ã¨Ã²Ã¥Ã«.", decode
(CALL_DIRECTION, 'O',
</body>
</html>
--
TIA
-PS
"Wei Lu [MSFT]" wrote:
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello PS,
Changing the data type from Varchar to char will not convert it to right.
Since when you insert the Unicode characetors into a Varchar type column,
the information have corrupted yet. And changing the data type will not fix
those old data.
You may need to contact your application vendor to re input the data.
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Wei,
Thanks for that info.
ok then i will input fresh data and test it and will let you know.
Thanks
--
TIA
-PS
"Wei Lu [MSFT]" wrote:
> Hello PS,
> Changing the data type from Varchar to char will not convert it to right.
> Since when you insert the Unicode characetors into a Varchar type column,
> the information have corrupted yet. And changing the data type will not fix
> those old data.
> You may need to contact your application vendor to re input the data.
> Hope this helps.
>
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Wei,
we tested the nvarchar changes with new set of data and it did not work.
The issue we have is not Unicode related because the original russian
characters are ISO-1251. ISO-1251 is just using single byte characters not
Unicode double byte characters.
--
TIA
-PS
"PS" wrote:
> Hi Wei,
> Thanks for that info.
> ok then i will input fresh data and test it and will let you know.
> Thanks
> --
> TIA
> -PS
>
> "Wei Lu [MSFT]" wrote:
> > Hello PS,
> >
> > Changing the data type from Varchar to char will not convert it to right.
> > Since when you insert the Unicode characetors into a Varchar type column,
> > the information have corrupted yet. And changing the data type will not fix
> > those old data.
> >
> > You may need to contact your application vendor to re input the data.
> >
> > Hope this helps.
> >
> >
> > Sincerely,
> >
> > Wei Lu
> > Microsoft Online Community Support
> >
> > ==================================================> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > ==================================================> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >|||Hello PS,
I would like to get the sample database data and your collation settings
for the table and database so that I can reproduce this issue.
Could you please get a simple database backup with only on issue table?
You could zip and send it to me.
To reach my real email, please remove the ONLINE in my display email.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello PS,
Did you send your database yet? If anything I can help, please feel free to
let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yet Sad

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()

************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:

************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d

C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:

Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yet Sad

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

Program Location:

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)

Program Location:

************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:

************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

Program Location:

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d

C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:

Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Monday, March 26, 2012

report data with different char-set other than english

Report connection fails with DNS name

Report connection fails with DNS name

Importing Error

Blog Archive

About Me