Devart Forums

I am using SQL Server 2012 RC0 (SSAS 2012). This version only supports Visual Studio 2010 for BI Studio. So, technically, it's not a released product yet so that's probably the issue. MSFT will be releasing SQL Server 2012 soon, though.

1. Are you using SSAS 2005 or SSAS 2008?
I am using SQL Server 2012 RC0 (SSAS 2012)

2. Is your IDE Visual Studio 2008?
I am using Visual Studio 2010 (which comes with SQL Server 2012)

3. Tell us the exact version (x.xx.xxx) of your dotConnect for MySQL.
6.50.214.0

4. Which exact steps should we follow to reproduce the issue in our environment?
1. Install SQL Server 2012 RC0 (or RC1)
2. Install MySql Windows v5.5.11
3. Install DotConnect for MySql 6.50.214.0
4. Open Visual Studio 2010, create a new cube, create a new DSV, try to add a MySql table to the data source view (DSV)

5. Did the Devart.Data.MySql.xsl file and instructions how to use it help you
No. I did follow the directions and this worked for my using SQL Server 2008 R2

When adding a new table to my Data Source View (DSV) in VS 2010 (Business Intelligence Studio) I get an error. It's adding brackets ('[', ']') to the table name which is causing the syntax error.

Here's the call stack of the 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 '[exacttargetreport] limit 0,0' at line 2 (Microsoft Visual Studio)

------------------------------
Program Location:

at Devart.Data.MySql.bk.t()
at Devart.Data.MySql.bk.d()
at Devart.Data.MySql.u.a(af[]& A_0, Int32& A_1)
at Devart.Data.MySql.u.a(Byte[] A_0, Int32 A_1, Boolean A_2)
at Devart.Data.MySql.a2.e()
at Devart.Data.MySql.a2.o()
at Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.DataWarehouse.Design.DataSourceConnection.FillDataSet(DataSet dataSet, String schemaName, String tableName, String tableType)
at Microsoft.AnalysisServices.Design.DataSourceDesigner.AddRemoveObjectsFromDSV()

In Visual Studio 2008 for Business Intelligence (BIDS), adding a new object in the data source view (DSV) will only show me tables (not views) in the 'Add/Remove Tables' dialog.

I am using the latest build of dotConnect for MySQL.

Hi,

I'm having the same problem as described in this post. SSAS is place brackets around column and table names which is causing the SQL to fail. Can you share the workaround you offered in this post?

I am using the latest version (v6.3.6) of the MySql-Net driver.

Thanks.