SQL Management Studio 2014 with dotConnect produces "Syntax error exception "

SQL Management Studio 2014 with dotConnect produces "Syntax error exception "

Postby pnatov » Wed 06 Aug 2014 05:00

We have licensed version of the dotConnect for MySQL data provider. So far we were using Sql Server 2012 and its corresponding products SSRS, SSAS. We don't use the relational storage of SQL server, but MySQL instead (for reasons I won't explain) and that is why we need dotConnect. It was working fine until we migrated to SQL Server 2014.

When trying to process OLAP cube we receive the following error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[XXX_D_ACQUIRER].[acquirer_id] AS [XXX_D_ACQUIRERacquirer_id0_0],[XXX' at line 3.

Obviously the problem lies with the '[' while the correct SQL produced shall be like this (working fine on SSAS 2012 and SQL Management Studio 2012):
SELECT
DISTINCT
`XXX_D_ACQUIRER`.`acquirer_id` AS `XXX_D_ACQUIRERacquirer_id0_0`,`XXX_D_ACQUIRER`.`acquirer_name` AS `XXX_D_ACQUIRERacquirer_name0_1`
FROM `XXX`.`D_ACQUIRER` AS `XXX_D_ACQUIRER`

Is this a known bug ot what could possible went wrong when we migrated to SSAS 2014? Is there a way arround this issue?

Thanks
pnatov
 
Posts: 2
Joined: Wed 06 Aug 2014 04:46

Re: SQL Management Studio 2014 with dotConnect produces "Syntax error exception "

Postby Pinturiccio » Wed 06 Aug 2014 13:37

Unfortunately, SSDT-BI for Visual Studio 2013 is currently not supported. We will notify you when the corresponding support is implemented.
As a temporary workaround, please use the dotConnect for MySQL SSIS components in VS 2008, 2010, or 2012.
Pinturiccio
Devart Team
 
Posts: 1928
Joined: Wed 02 Nov 2011 09:44

Re: SQL Management Studio 2014 with dotConnect produces "Syntax error exception "

Postby Shalex » Wed 25 Mar 2015 14:01

The new build of dotConnect for MySQL will include the following improvements:
  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
  • SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
We will notify you when the corresponding build is available for download.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44

Re: SQL Management Studio 2014 with dotConnect produces "Syntax error exception "

Postby Shalex » Thu 26 Mar 2015 17:29

New build of dotConnect for MySQL 8.3.379 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=2&t=31497.
Shalex
Devart Team
 
Posts: 7530
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL