Can't see views in BIDS 'Add/Remove Tables' dialog

[dmariani]

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.

[Shalex]

We have reproduced the mentioned issue for the "Select Tables and Views" menu of the Data Source View wizard in Integration Services Project. We will investigate it and notify you about the results as soon as possible.

[Shalex]

The reason of the difference in behaviour between two providers is in different result sets of conn.GetSchema("Tables"):

• Devart.Data.MySql returns only tables
• System.Data.SqlClient returns tables and views

With dotConnect for MySQL, the views are returned by conn.GetSchema("Views").

A workaround for SSIS projects: use a provider-specific component Devart MySql Source (the Common tab in SSIS Toolbox) instead of ADO NET Source (the Other Sources tab in SSIS Toolbox).

[Shalex]

The bug with retrieving views in Business Intelligence Solutions projects is fixed. We will post here when the corresponding build of dotConnect for MySQL is available for download.

[Shalex]

New build of dotConnect for MySQL 8.2.55 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=28504.