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

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

Postby dmariani » Tue 12 Jul 2011 23:38

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.
dmariani
 
Posts: 4
Joined: Thu 26 May 2011 18:28

Postby Shalex » Fri 15 Jul 2011 14:59

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
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

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

Postby Shalex » Wed 28 Aug 2013 09:52

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
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

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

Postby Shalex » Thu 12 Dec 2013 11:35

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
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

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

Postby Shalex » Thu 12 Dec 2013 14:14

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.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL