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 Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:5.0.5 OS:Microsoft Windows (Windows)
Assigned to: 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.