Bug #26960 Connector .NET 5.0.5 / Visual Studio Plugin 1.1.2

• Submitted: 8 Mar 2007 15:18
• Modified: 26 Mar 2007 6:26
• Reporter: Nalle Jacobsson
• Status: Closed
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 5.0.5
• OS: Windows (Windows)
• CPU Architecture: Any
• Tags: invalid data specifier

[8 Mar 2007 15:18] Nalle Jacobsson

Description:
After upgrading to MySQL Connector.NET 5.0.5 (from 5.0.3) I can't connect to an existing MySQL data connection or add a new in Visual Studio 2005. I get the error "invalid data specifier". Database is MySQL 5.0.32 enterprise.

How to repeat:
Install MySQL Connector.NET 5.0.5
Install Visual Studio plugin 1.1.2 Alpha
Try to add a new data connection in VS 2005.
When you press ok you will get the error "invalid data specifier".

[8 Mar 2007 18:53] Tonci Grgin

Hi Nalle and thanks for your report.

Verified as described with MySQL 5.0.34BK on WinXP Pro SP2 localhost.
 - Uninstall c/NET 5.0.3
 - Install c/NET 5.0.5
 - Problems with server explorer

Here is general query log when you try browsing tables with server explorer:
070308 19:49:09	      5 Connect     root@localhost on test
		      5 Query       SHOW VARIABLES
		      5 Query       SHOW COLLATION
		      5 Query       SET character_set_results=NULL
		      5 Init DB     test
		      5 Query       SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE != 'VIEW' AND TABLE_SCHEMA='*Invalid data specifier*'

[21 Mar 2007 4:49] Reggie Burnett

Fixed in 5.0.6

[26 Mar 2007 6:26] MC Brown

A note has been added to the 5.0.6 changelog.