Bug #26960 Connector .NET 5.0.5 / Visual Studio Plugin 1.1.2
Submitted: 8 Mar 2007 16:18 Modified: 26 Mar 2007 8:26
Reporter: Nalle Jacobsson
Status: Closed
Category:Connector/Net Severity:S2 (Serious)
Version:5.0.5 OS:Microsoft Windows (Windows)
Assigned to: Target Version:
Tags: invalid data specifier

[8 Mar 2007 16: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 19: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 5:49] Reggie Burnett 
Fixed in 5.0.6
[26 Mar 2007 8:26] MC Brown 
A note has been added to the 5.0.6 changelog.