Bug #30614 Connector .Net 5.1.2 problems with MySQL 4.0.20

• Submitted: 24 Aug 2007 3:50
• Modified: 21 Sep 2007 22:39
• Reporter: First Last
• Status: Duplicate
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 5.1.2
• OS: Windows (XP Professional)
• CPU Architecture: Any

[24 Aug 2007 3:50] First Last

Description:
Documentation says:
"Connector/NET 5.1 includes support for MySQL 4.0, MySQL 5.0, MySQL 5.1 and MySQL 6.0 (Falcon Preview) features."

Setting up connection string in Visual Studio 2005 give alternating errors when testing the connection:
First is "Packets larger than max_allowed_packet are not allowed"
Second is "Object reference not set to an instance of an object."

Answer seems to be to switch to MySQL 5 or greater but the documentation indicates that it should work with 4.0. And changing versions is not easy for live databases.

MySQL 4.0.20 database is running on a Linux server.

How to repeat:
In Visual Studio:

Click <Website><Add Reference> from menu and add the MySQL.data component.
In Server Explorer click "Connect to database" Icon
Select MySQL Database.
Complete the information requested the form (Server Name, User Name, Password and Database Name).
Press Test Connection.

[21 Sep 2007 22:39] Reggie Burnett

I think this is a duplicate of 29476 which is already fixed in 5.1.3