I have a develop machine for our web site. On this machine I have a copy of a database from the production site. The database on the production site is being replicated. When I copied the database to the develop machine and started testing some new developments I got the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'sysmergearticles'
This tells me that some replication data is also copied to the develop database.
Can anyone tell me how I can clean this data, or if I should copy the databse in a different way. (Now I create a new databse and do an import of the tables and stored procedures)You could try to remove replication by going under Tools(in EM)-->Replication-->Disable publishing,Distri...If it allows you to do so then it's fine.Or else you could try to first set the replication on your Test system and then remove ot by using the Tools-->Replication.
Or you may try the script below:
USE [DBNAME]
GO
-- Drop all replication triggers from the database
PRINT 'Drop all replication triggers from the database'
SELECT trigs.name AS TriggerName,
trigs.id AS TriggerID,
tables.name AS TableName
INTO #Triggers
FROM sysobjects trigs
INNER JOIN sysobjects tables
ON trigs.parent_obj=tables.id
where trigs.category=2 and trigs.xtype='TR'
DECLARE @.TriggerName varchar(100), @.TriggerID INT, @.TableName varchar(100)
DECLARE cur CURSOR for SELECT * FROM #Triggers
OPEN cur
FETCH NEXT FROM cur INTO @.TriggerName, @.TriggerID, @.TableName
WHILE @.@.FETCH_STATUS=0
BEGIN
EXECUTE ('DROP TRIGGER ' + @.TriggerName)
FETCH NEXT FROM cur INTO @.TriggerName, @.TriggerID, @.TableName
END
CLOSE cur
DEALLOCATE cur
GO
-- Drop all replication constraints from the database
PRINT 'Drop all replication constraints from the database'
DECLARE @.ConstName varchar(100), @.ConstID INT, @.TableName varchar(100)
SELECT CONST.name AS ConstName,
CONST.id AS ConstID,
tables.name AS TableName
INTO #Constraints
FROM sysobjects CONST
INNER JOIN sysobjects tables
ON CONST.parent_obj=tables.id
where CONST.xtype='C'
DECLARE cur CURSOR for SELECT * FROM #Constraints
OPEN cur
FETCH NEXT FROM cur INTO @.ConstName, @.ConstID, @.TableName
WHILE @.@.FETCH_STATUS=0
BEGIN
EXECUTE ('ALTER Table ' + @.TableName + ' DROP CONSTRAINT ' + @.ConstName)
FETCH NEXT FROM cur INTO @.ConstName, @.ConstID, @.TableName
END
CLOSE cur
DEALLOCATE cur
GO
-- Drop all replication User tables
PRINT 'Drop all replication User tables'
DECLARE @.TableName varchar(100), @.TableID INT
SELECT Tables.name AS ConstName,
Tables.id AS ConstID
INTO #Tables
FROM sysobjects Tables
where Tables.xtype='U' AND Status < 0 AND category=2050
DECLARE cur CURSOR for SELECT * FROM #Tables
OPEN cur
FETCH NEXT FROM cur INTO @.TableName, @.TableID
WHILE @.@.FETCH_STATUS=0
BEGIN
EXECUTE ('DROP Table ' + @.TableName)
FETCH NEXT FROM cur INTO @.TableName, @.TableID
END
CLOSE cur
DEALLOCATE cur
GO
-- Drop all replication User procedures
PRINT 'Drop all replication User procedures'
DECLARE @.ProcName varchar(100), @.ProcID INT
SELECT Procs.name AS ConstName,
Procs.id AS ConstID
INTO #Procedures
FROM sysobjects Procs
where procs.xtype='P' AND Status < 0
DECLARE cur CURSOR for SELECT * FROM #Procedures
OPEN cur
FETCH NEXT FROM cur INTO @.ProcName, @.ProcID
WHILE @.@.FETCH_STATUS=0
BEGIN
EXECUTE ('DROP Procedure ' + @.ProcName)
FETCH NEXT FROM cur INTO @.ProcName, @.ProcID
END
CLOSE cur
DEALLOCATE cur
GO
-- Drop all replication User Views
PRINT 'Drop all replication User Views'
DECLARE @.ViewName varchar(100), @.ViewID INT
SELECT MyViews.name AS ConstName,
MyViews.id AS ConstID
INTO #Views
FROM sysobjects MyViews
where MyViews.xtype='V' AND Status < 0 AND Name NOT LIKE 'sys%'
DECLARE cur CURSOR for SELECT * FROM #Views
OPEN cur
FETCH NEXT FROM cur INTO @.ViewName, @.ViewID
WHILE @.@.FETCH_STATUS=0
BEGIN
EXECUTE ('DROP View ' + @.ViewName)
FETCH NEXT FROM cur INTO @.ViewName, @.ViewID
END
CLOSE cur
DEALLOCATE cur
GO
-- Drop all replication rowguids, defaults and indexes
PRINT 'Drop all replication rowguids, defaults and indexes'
SELECT tables.name as TableName,
defaults.name AS DefaultName,
Indexes.IndexName,
cols.name AS ColumnName
INTO #Defaults
FROM sysobjects defaults
INNER JOIN syscolumns cols
ON defaults.ID=cols.cdefault
INNER JOIN sysobjects tables
ON tables.id=cols.id
INNER JOIN
(select sysindexes.name AS IndexName,
Tables.Name AS TableName,
Tables.id as TableID,
cols.Name AS ColumnName
from sysindexes
INNER JOIN sysobjects Tables
ON sysindexes.id=tables.id
INNER JOIN sysindexkeys k
on sysindexes.id=k.id
AND sysindexes.indid=k.indid
INNER JOIN syscolumns cols
ON k.id=cols.id
AND k.colid=cols.colid
where cols.name='rowguid') Indexes
ON Indexes.TableID=tables.id
where cols.name='rowguid'
DECLARE @.DefaultName varchar(100), @.IndexName varchar(100), @.TableName varchar(100), @.ColName varchar(50)
DECLARE cur CURSOR for SELECT * FROM #Defaults
OPEN cur
FETCH NEXT FROM cur INTO @.TableName, @.DefaultName, @.IndexName, @.ColName
WHILE @.@.FETCH_STATUS=0
BEGIN
EXECUTE ('ALTER TABLE ' + @.TableName + ' DROP CONSTRAINT ' + @.DefaultName)
EXECUTE ('DROP INDEX ' + @.TableName + '.' + @.IndexName)
EXECUTE ('ALTER TABLE ' + @.TableName + ' DROP COLUMN rowguid')
FETCH NEXT FROM cur INTO @.TableName, @.DefaultName, @.IndexName, @.ColName
END
CLOSE cur
DEALLOCATE cur
GO|||I've been trying to delete the conflict tables left over after EXEC sp_removereplication
Your script did it!
Showing posts with label develop. Show all posts
Showing posts with label develop. Show all posts
Sunday, March 25, 2012
Clean input before submitting to database
Is there some recommended way to clean input before submitting it to the database? We'd like to develop a library that can be used on our ASP/ASP.NET apps to filter input before it's sent to the SQL Server and Oracle databases. Is there a way to create a .NET DLL that can be used for both ASP.NET and classic ASP apps. Thanks.What's the meaning of "clean input before submitting it to the database"? Can you explain more? Where does the input locate? If you're talking about input for operations towards database, there seems no way to filter it, since the communication between databases and clients are based request packages. In this case I think it's better to implement this logic on database level, you can use some CONSTRAINTs,TRIGGERs, and so on to prevent 'bad' input to the databas.|||Sorry. Let me clarify. With "clean" I mean free from malicious code. In other words, I'd like to clean it so to prevent SQL injection attacks. I'm implementing the steps outlined in this article:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/THCMCh04.asp. Thanks.|||Use parameterized queries.sqlsql
Thursday, March 8, 2012
Chinese Characters in SQL 2000
Hi All
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
JigneshAll you should need to do is use Unicode character types (NCHAR, NVARCHAR, and NTEXT) and SQL Server should handle the Chinese characters gracefully. Getting SQL Server to provide Chinese error messages is a bit more complicted, but let's deal with one problem at a time!
-PatP|||I have declared the table column as nvarchar. I was searching on google and found out that the only thing I need to do is declare them as either nvarchar or nchar etc..
I guess it does not work in my case. I am sure I am doing something wrong, but not sure what.|||I installed windows XP language bar on my machine. So when I go to enterprise manager, I can type in chinese characters in the database directly and then can view them on my ASP.net page.
But when I try to insert a record from an ASP.net page by typing chinese characters in the text box, they are all converted to ??.|||Something between your keyboard and the web page control is only passing 8 bit values. Since you can successfully enter Unicode (the Chinese characters) via SQL Enterprise Mangler, I think we can assume everything is Ok as far as your OS, which leads me to think the problem is either in your browser or beyond (probably the web page).
-PatP|||I guess you are right. The problem seems to be in the web page. I just created a sample ASP.net webpage, which have one text box and a button.
When user clicks chinese characters in textbox with help of language bar and press enter, the data goes to database. But the data are converted to ????|||I was doing some more trials and found out that only time when I can enter proper data in SQL is when I go to enterprise manager and type in the data in the cell myself ( just like Excel).
But when I run the following query
Insert into TestTable(Comments, Language) values('彰','chinese') even on the enterprise manager or query analyzer, the chinese characters are converted to ???|||Just for the jolly factor, let's cut SQL Server out of the problem altogether for a moment. try to construct a "hello world" sort of web page with just a text control and a button. Have it simply allow the user to enter text into a control, then create a popup that contains that text when the user presses the button. This will allow you to get the web page working first, then we can concentrate on getting the data back and forth from the database.
-PatP|||Hi Pat
I tried exactly what you said. The code is below:
Private Sub btnTemp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTemp.Click
ShowMessage(txtComment.Text)
End Sub
Private Sub ShowMessage(ByVal message As String)
Dim scriptString As String = "<script language=JavaScript>"
scriptString += "alert('" + message + "');"
scriptString += "</script>"
Page.RegisterStartupScript("ShowMessage", scriptString)
End Sub
The code works absolutely fine. I enter chinese characters in textbox and onclick of a button show a messagebox with javascript, which shows the chinese text perfectly fine.|||Good! Now, can you modify that same sample script so that a new button simply sticks the Textbox contents into a column in the database? If you can do that, then modify the existing button to pull the data from the column and display that data from the column.
-PatP|||I guess thats when it fails. Below is my code:
**********************The same button click event ***************
Dim sqlConnection1 As SqlConnection = New SqlConnection("Data Source=(local); Initial Catalog = ChineseTest; UID=jop; PWD=jop2279")
Dim cmd As SqlCommand = sqlConnection1.CreateCommand
sqlConnection1.Open()
cmd.CommandType = CommandType.Text
cmd.CommandText = "Insert into TestTable (Comments, Lang)values('" + txtComment.Text + "','Chinese')"
cmd.ExecuteNonQuery()
sqlConnection1.Close()
************************************************** ***********************
But when I go to the database, I can only see >???|||Try running the statement in Query Analyzer like this
Insert into TestTable(Comments, Language) values(N'彰','chinese')
and see if that works.
How are you constructing your INSERT statement in your asp.net code?
Is it something like
string cmd="Insert into your_table(Comments) values('"+someTextBox.Text"')";
// Execute cmd
?
Edit: I see from your post that that is the case. You should really consider using a parameterized query for this. It ought to solve your unicode issue AND help protect you against SQL injection attacks.|||Just for the jolly factor, I'd apply the latest MDAC to both the web server, and the client PC (this is just "iron underware" for the development environment, it is not needed in production).
-PatP|||I changed the SQL statement as per ded's instruction to:
Insert into TestTable(Comments, Language) values(N'彰','chinese')
and it start working fine. I can run the same query from ASP.net webpage and it works fine too..
Thanks for your support guys. Without you, it would have been impossible for me to figure out this thing.
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
JigneshAll you should need to do is use Unicode character types (NCHAR, NVARCHAR, and NTEXT) and SQL Server should handle the Chinese characters gracefully. Getting SQL Server to provide Chinese error messages is a bit more complicted, but let's deal with one problem at a time!
-PatP|||I have declared the table column as nvarchar. I was searching on google and found out that the only thing I need to do is declare them as either nvarchar or nchar etc..
I guess it does not work in my case. I am sure I am doing something wrong, but not sure what.|||I installed windows XP language bar on my machine. So when I go to enterprise manager, I can type in chinese characters in the database directly and then can view them on my ASP.net page.
But when I try to insert a record from an ASP.net page by typing chinese characters in the text box, they are all converted to ??.|||Something between your keyboard and the web page control is only passing 8 bit values. Since you can successfully enter Unicode (the Chinese characters) via SQL Enterprise Mangler, I think we can assume everything is Ok as far as your OS, which leads me to think the problem is either in your browser or beyond (probably the web page).
-PatP|||I guess you are right. The problem seems to be in the web page. I just created a sample ASP.net webpage, which have one text box and a button.
When user clicks chinese characters in textbox with help of language bar and press enter, the data goes to database. But the data are converted to ????|||I was doing some more trials and found out that only time when I can enter proper data in SQL is when I go to enterprise manager and type in the data in the cell myself ( just like Excel).
But when I run the following query
Insert into TestTable(Comments, Language) values('彰','chinese') even on the enterprise manager or query analyzer, the chinese characters are converted to ???|||Just for the jolly factor, let's cut SQL Server out of the problem altogether for a moment. try to construct a "hello world" sort of web page with just a text control and a button. Have it simply allow the user to enter text into a control, then create a popup that contains that text when the user presses the button. This will allow you to get the web page working first, then we can concentrate on getting the data back and forth from the database.
-PatP|||Hi Pat
I tried exactly what you said. The code is below:
Private Sub btnTemp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnTemp.Click
ShowMessage(txtComment.Text)
End Sub
Private Sub ShowMessage(ByVal message As String)
Dim scriptString As String = "<script language=JavaScript>"
scriptString += "alert('" + message + "');"
scriptString += "</script>"
Page.RegisterStartupScript("ShowMessage", scriptString)
End Sub
The code works absolutely fine. I enter chinese characters in textbox and onclick of a button show a messagebox with javascript, which shows the chinese text perfectly fine.|||Good! Now, can you modify that same sample script so that a new button simply sticks the Textbox contents into a column in the database? If you can do that, then modify the existing button to pull the data from the column and display that data from the column.
-PatP|||I guess thats when it fails. Below is my code:
**********************The same button click event ***************
Dim sqlConnection1 As SqlConnection = New SqlConnection("Data Source=(local); Initial Catalog = ChineseTest; UID=jop; PWD=jop2279")
Dim cmd As SqlCommand = sqlConnection1.CreateCommand
sqlConnection1.Open()
cmd.CommandType = CommandType.Text
cmd.CommandText = "Insert into TestTable (Comments, Lang)values('" + txtComment.Text + "','Chinese')"
cmd.ExecuteNonQuery()
sqlConnection1.Close()
************************************************** ***********************
But when I go to the database, I can only see >???|||Try running the statement in Query Analyzer like this
Insert into TestTable(Comments, Language) values(N'彰','chinese')
and see if that works.
How are you constructing your INSERT statement in your asp.net code?
Is it something like
string cmd="Insert into your_table(Comments) values('"+someTextBox.Text"')";
// Execute cmd
?
Edit: I see from your post that that is the case. You should really consider using a parameterized query for this. It ought to solve your unicode issue AND help protect you against SQL injection attacks.|||Just for the jolly factor, I'd apply the latest MDAC to both the web server, and the client PC (this is just "iron underware" for the development environment, it is not needed in production).
-PatP|||I changed the SQL statement as per ded's instruction to:
Insert into TestTable(Comments, Language) values(N'彰','chinese')
and it start working fine. I can run the same query from ASP.net webpage and it works fine too..
Thanks for your support guys. Without you, it would have been impossible for me to figure out this thing.
Chinese characters in SQL 2000
Hi All
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
JigneshI have already declared the column as nvarchar.
I installed windows XP language bar on my machine. So when I go to enterprise manager, I can type in chinese characters in the database directly and then can view them on my ASP.net page.
But when I try to insert a record from an ASP.net page by typing chinese characters in the text box, they are all converted to ?.
Originally posted by patel_o
Hi All
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
Jignesh
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
JigneshI have already declared the column as nvarchar.
I installed windows XP language bar on my machine. So when I go to enterprise manager, I can type in chinese characters in the database directly and then can view them on my ASP.net page.
But when I try to insert a record from an ASP.net page by typing chinese characters in the text box, they are all converted to ?.
Quote:
Hi All
I have to develop a website which allows users to enter their comments into Chinese languages. I need sql2000 to support the chinese characters.
I am experienced .net web programmer, but have very little knowledge on the database side. Would really appreciate any help on this
THanks
Jignesh
Chinese characters doesn't print correctly
I develop my report in VS2005 and it print out with the Chinese characters
but when I deployed it to reporting service and print it I get boxes that
replaced the Chinese characters. The Chinese character is held in text boxes
in the report that are not queried from the database. The Chinese characters
are static headers.
--
Thank you,
The DiepHi Diep,
Since you were using a static report without querying from your database,
could you please send your report to me (changliw_at_microsoft_dot_com) for
further research?
Currently I performed a simple test with a TextBox header which was filled
with Chinese characters. After I deploy it to my report server, it worked
fine. The Chinese characters were displayed without any problem.
Look forward to your response. I am very glad to work with you for further
research.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||After I installed the Report Viewer 2005 service pack 1 and reboot my server
the report printed Chinese characters fine. Thank you.
--
Thank you,
The Diep
"Charles Wang[MSFT]" wrote:
> Hi Diep,
> Since you were using a static report without querying from your database,
> could you please send your report to me (changliw_at_microsoft_dot_com) for
> further research?
> Currently I performed a simple test with a TextBox header which was filled
> with Chinese characters. After I deploy it to my report server, it worked
> fine. The Chinese characters were displayed without any problem.
> Look forward to your response. I am very glad to work with you for further
> research.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Diep,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi
I have the same problem: the legend of a chart displays boxes instead of
chinese characters.
I've installed the Report Viewer 2005 service pack 1 on my local pc and it
works fine. But when I've installed the service pack on the server, in the
report the chinese characters are still replaced with boxes! Where is the
problem?
The OS on the pc used for development is Windows 2000 service pack 4; the
server OS is Windows Server 2003 standard edition service pack 1.
Thank you
Renato|||I have it working on my server 2003. I installed the service pack 1 from
here http://support.microsoft.com/kb/933137 then I installed some chinese
true font on my server as well. The chinese characters still didn't display
correctly until I rebooted my system.
--
Thank you,
The Diep
"Renato" wrote:
> Hi
> I have the same problem: the legend of a chart displays boxes instead of
> chinese characters.
> I've installed the Report Viewer 2005 service pack 1 on my local pc and it
> works fine. But when I've installed the service pack on the server, in the
> report the chinese characters are still replaced with boxes! Where is the
> problem?
> The OS on the pc used for development is Windows 2000 service pack 4; the
> server OS is Windows Server 2003 standard edition service pack 1.
> Thank you
> Renato
>|||Hi Renato,
If you are a MSDN Managed Newsgroup user, could you please have a new post
so that we can assist you more dedicatedly?
Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
=========================================================This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
but when I deployed it to reporting service and print it I get boxes that
replaced the Chinese characters. The Chinese character is held in text boxes
in the report that are not queried from the database. The Chinese characters
are static headers.
--
Thank you,
The DiepHi Diep,
Since you were using a static report without querying from your database,
could you please send your report to me (changliw_at_microsoft_dot_com) for
further research?
Currently I performed a simple test with a TextBox header which was filled
with Chinese characters. After I deploy it to my report server, it worked
fine. The Chinese characters were displayed without any problem.
Look forward to your response. I am very glad to work with you for further
research.
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||After I installed the Report Viewer 2005 service pack 1 and reboot my server
the report printed Chinese characters fine. Thank you.
--
Thank you,
The Diep
"Charles Wang[MSFT]" wrote:
> Hi Diep,
> Since you were using a static report without querying from your database,
> could you please send your report to me (changliw_at_microsoft_dot_com) for
> further research?
> Currently I performed a simple test with a TextBox header which was filled
> with Chinese characters. After I deploy it to my report server, it worked
> fine. The Chinese characters were displayed without any problem.
> Look forward to your response. I am very glad to work with you for further
> research.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> =====================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================>
>|||Hi Diep,
Thank you for your reply and the detailed additional feedback on how you
were successful in resolving this issue. This information has been added to
Microsoft's database. Your solution will benefit many other users, and we
really value having you as a Microsoft customer.
If you have any other questions or concerns, please do not hesitate to
contact us. It is always our pleasure to be of assistance.
Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi
I have the same problem: the legend of a chart displays boxes instead of
chinese characters.
I've installed the Report Viewer 2005 service pack 1 on my local pc and it
works fine. But when I've installed the service pack on the server, in the
report the chinese characters are still replaced with boxes! Where is the
problem?
The OS on the pc used for development is Windows 2000 service pack 4; the
server OS is Windows Server 2003 standard edition service pack 1.
Thank you
Renato|||I have it working on my server 2003. I installed the service pack 1 from
here http://support.microsoft.com/kb/933137 then I installed some chinese
true font on my server as well. The chinese characters still didn't display
correctly until I rebooted my system.
--
Thank you,
The Diep
"Renato" wrote:
> Hi
> I have the same problem: the legend of a chart displays boxes instead of
> chinese characters.
> I've installed the Report Viewer 2005 service pack 1 on my local pc and it
> works fine. But when I've installed the service pack on the server, in the
> report the chinese characters are still replaced with boxes! Where is the
> problem?
> The OS on the pc used for development is Windows 2000 service pack 4; the
> server OS is Windows Server 2003 standard edition service pack 1.
> Thank you
> Renato
>|||Hi Renato,
If you are a MSDN Managed Newsgroup user, could you please have a new post
so that we can assist you more dedicatedly?
Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@.microsoft.com.
=========================================================This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
Subscribe to:
Posts (Atom)