MS BI Studio 2014 square brackets
Posted: Wed 02 Jul 2014 01:10
I am using devart dotnet connector when creating a data source. When I use this data source when creating a data source view and try and save the view I get an error:
"You have an error in your SQL Syntax; check the manual that corresponds t your MYSQL server version for the right syntax to use near '[riskanalyzercontrolresponse] limit 0,0' at line 2."
It seems to have put square brackets around the underlying MYSQL table name. This appears to have been a problem with this since 2009 - is there a fix out there somewhere?
Would appreciate your comments asap
Thank you
"You have an error in your SQL Syntax; check the manual that corresponds t your MYSQL server version for the right syntax to use near '[riskanalyzercontrolresponse] limit 0,0' at line 2."
It seems to have put square brackets around the underlying MYSQL table name. This appears to have been a problem with this since 2009 - is there a fix out there somewhere?
Would appreciate your comments asap
Thank you