Page 1 of 1
SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Wed May 22, 2019 7:03 am
by iamyong
Good Day,
So I have a stimulsoft report that is working on SS Ultimate 2014.3 designer. However, when I tried to run the report with SS Ultimate 2019.2.3, I get the error below:
I was able to determine that the cause of the error was when my queries were trying to concatenate chinese characters, sample:
SELECT CONCAT(YEAR(GETDATE()), N'年', MONTH(GETDATE()), N'月', DAY(GETDATE()), N'日')
and when my sql statements had chinese text in the WHERE clause, sample:
SELECT N'增加'
Am I missing something in SS thats causing this error? Also, I'm connecting to one single database when running the report between the two SS versions mentioned above.
Thank You.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Wed May 22, 2019 7:30 am
by Lech Kulikowski
Hello,
We couldn't reproduce the issue. Could you provide more detailed information on how to reproduce the issue?
Thank you.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Wed May 22, 2019 9:35 am
by iamyong
Hi
I'm also able to see the data from View Query, the error shows up when I hit "Preview".
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Wed May 22, 2019 12:27 pm
by Lech Kulikowski
Hello,
Also works fine in preview.
Thank you.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Wed May 22, 2019 11:21 pm
by iamyong
Hi Lech,
We are using [OLE DB] as our datasource.
pokemon coin generator
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Thu May 23, 2019 12:14 am
by iamyong
this one specifically.
pokemon coin generator
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Thu May 23, 2019 3:46 pm
by iamyong
I found the issue, one of my datasources was of the type Stored Procedure but it was supposed to be Query. Please note that the report was working on SS Ultimate 2014.3 even if the datasource was typed as Stored Procedure instead of Table.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Sat May 25, 2019 12:27 pm
by Andrew
Hello,
Do I understand you correct that the issue is resolved and no action required from Stimulsoft side?
Thank you.
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Fri Sep 13, 2019 2:49 am
by iamyong
Hello,
Yes, that is correct. Apologies for the late reply.
Thanks,
Re: SS 2019.2.3 throwing Syntax error or access violation when trying to display chinese characters.
Posted: Fri Sep 13, 2019 7:51 am
by Andrew
Hello,
Okay, thank you for the reply.
Closing the thread.
Have a nice day!