Page 1 of 1
Can't see views in BIDS 'Add/Remove Tables' dialog
Posted: Tue 12 Jul 2011 23:38
by 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.
Posted: Fri 15 Jul 2011 14:59
by 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.
Re: Can't see views in BIDS 'Add/Remove Tables' dialog
Posted: Wed 28 Aug 2013 09:52
by 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).
Re: Can't see views in BIDS 'Add/Remove Tables' dialog
Posted: Thu 12 Dec 2013 11:35
by 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.
Re: Can't see views in BIDS 'Add/Remove Tables' dialog
Posted: Thu 12 Dec 2013 14:14
by 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.