Bug #45170 Re-configuration of Dataset causes error, fails
Submitted: 28 May 2009 20:57 Modified: 10 Dec 2009 16:07
Reporter: Alan Poletti Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.0.3 OS:Windows (XP SP3)
Assigned to: Assigned Account CPU Architecture:Any
Tags: .NET 2005, dataset, REFERENCED_TABLE_CATALOG, TableAdapter

[28 May 2009 20:57] Alan Poletti
Description:
We built a number of table adapters using an older .NET connector, version 5.2.x. (Not exactly sure which one). Using Visual Studio .NET 2005.

Recently, we upgraded to the most recent version of the .NET connector, because of speed and concurrency concerns.

When attempting to re-configure a table adapter, due to changes that were made in the database tables, we receive the following error, after clicking finish:

Failed to configure table adapter
Column 'REFERENCED_TABLE_CATALOG' does not belong to table. 

The table adapter does not save or reconfigure.

How to repeat:
Attempt to modify an existing dataset's table adapters, having been built with an older version of the .NET connector.

Appears to occur similarly in VS.NET 2008:
http://forums.mysql.com/read.php?38,263446,263446#msg-263446
[12 Jun 2009 21:43] José Francisco RangelSerrano
Hello. 

I have a similar problem. 

I'm using Visual Studio 2008 Full Edition (Spanish version), Windows XP SP3 connecting to MySQL 5.1, all on the same computer. I design my database with MySQL Workbench and export to MySQL Server 5.1. 

I have installed version 6.0.4 of connector .NET. 

But with this version I have a similar problem: "Add New Data Source", select "Database", select the data connection to your MySql database, save your connection string, and finally select the tables for your DataSet. When adding the DataSet, VS2008 will give an error that says "Relations couldn`t be addded. 
Column 'REFERENCED_TABLE_CATALOG' does not belong to table.", but the tables will be added.

Please, help me.
[19 Aug 2009 9:35] Tonci Grgin
Hi Alan and thanks for your report.

Checking on sources I've found that 6.x driver implements GetForeignKeyColumns (SchemaProvider.cs, Ln 391) which does not exist in 5.2 driver. Thus your error should originate from there. I do not see a bug here as we deliberately changed version to 6.x so we can implement new things or old things in different way. There is no guarantee of compatibility between 5.x and 6.x...
[21 Aug 2009 7:20] Tonci Grgin
Bug#46838 was marked as duplicate of this report.
[19 Sep 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[20 Sep 2009 7:08] José Francisco RangelSerrano
Please. Don't suspend this Bug.

I'm waiting for a solution.

When you can solve this problem?

Thanks.
[23 Sep 2009 16:55] Ernst Kaufmann
I can confirm this bug.
Win Vista (32 bit) 
MSVS2008
.NET 3.5 SP1
MySQL 5.1.38
MySQL Connector 6.1.2

Why is the status "No Feedback"? How can the non-author re-open the bug?
[24 Nov 2009 7:42] Tonci Grgin
Continued in Bug#48974
[10 Dec 2009 16:07] Reggie Burnett
We are marking this as a duplicate of bug #48974.  We would normally have fixed this one and marked the newer one has duplicate but since it is already fixed we are doing it this way.