Not able to query tables with special characters in table name for MySQL-C# (.Net FW)

[former_member504676]

Hello, we develop a custom viewer for a Crystal Report file using mysql as database. We have multiple tables with fields names with special characters. When we design the report using the Crystal Reports Editor, we apply the article

https://userapps.support.sap.com/sap/support/knowledge/en/2631163

and the report works perflecty.

But when we try to use the same report inside our custom viewer developed in C#, it returns an error :

check the manual that corresponds to your MariaDB server version for the right syntax to use near '% AEL_MP....'

the error is because Crystal Reports libraries are not using the string value DoubleQuotation defined in the they:

HKEY_CURRENT_USER\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\QueryBuilder\NameBuilder

Where we can configure o enable the DoubleQuotation for a C# (.Net FW). application because it is not working for a custom application with mysql database?

[DellSC]

Which SP of the SDK are you using?

[former_member504676]

Hello! i forgot the versions of my installation. We are using VS2019, with .NET FW 4.7.2 and this is the Service Pack:

Service Pack 30.

[former_member11696 · Accepted solution]

That's because you need to add those registry keys under the cR for VS tree.

See this KBA for what those are:

https://userapps.support.sap.com/sap/support/knowledge/en/2165260

And be aware CR Designer Formula Editor will also have reserved characters:

https://userapps.support.sap.com/sap/support/knowledge/en/2042551

Don

[former_member504676 · Accepted solution]

Excellent! it works!, i have to add the key to registry and be care about the version (x32 vs x64).