Bug #28572 Expanding Table Listing in Visual Studio 2005 Causes Error
Submitted: 21 May 2007 18:49 Modified: 22 May 2007 16:40
Reporter: Mark Moline Email Updates:
Status: Unsupported Impact on me:
None 
Category:Connector / NET Severity:S1 (Critical)
Version:5.1.0 OS:Windows (XP SP2)
Assigned to: CPU Architecture:Any
Tags: connector, Database Explorer, visual studio 2005

[21 May 2007 18:49] Mark Moline 
Description:
After creating the connection to the database, the server shows up in the Server Explorer Window. Expanding the server shows 2 folders (Tables, UDFs).  Clicking on the (+) by Tables returns the following error:

"Input string was not in a correct format.Couldn't store <Dynamic> in VERSION Column. Expected type is Int64."

I am trying to connect to a MySQL database version 4.0.24 on a Linux server.  I can successfully connect using the MySQL Query Browser and other tools.

How to repeat:
Create Visual Studio connection to a MySQL database.
Expand the server link.
Attempt to expand the Tables link.

Suggested fix:
None
[22 May 2007 16:40] Tonci Grgin 
Hi Mark and thanks for your report. This is not a bug:
"The MySQL Visual Studio Plugin is designed to work with MySQL version 5.0, but is also compatible with MySQL 4.1.1 and provides limited compatibility with MySQL 5.1."
Please read http://dev.mysql.com/doc/refman/5.0/en/connector-vstudio.html carefully.
[13 Dec 2007 16:10] James Gough 
Reading that document provides no answers at all. I've followed the instructions to the letter and still get the error reported originally.
[14 Dec 2007 7:26] Tonci Grgin 
Guys, first page of manual exactly explain this won't work:
"The MySQL Visual Studio Plugin is designed to work with MySQL version 5.0, but is also compatible with MySQL 4.1.1 and provides limited compatibility with MySQL 5.1."