Bug #16685 ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server

• Submitted: 20 Jan 2006 20:22
• Modified: 23 Jan 2006 12:14
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S2 (Serious)
• Version: 3.51.12.00
• OS: Windows (Win XP Pro)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[20 Jan 2006 20:22] [ name withheld ]

Description:
I am creating a connection to a remote instance of MySQL is a .NET app using the System.Data.ODBC.OdbcConnection object.  All goes well for a period of time (approximately 1000 queries) and then I get the above error.  Any ideas?

Bob Glover

How to repeat:
Create a connection, loop through a list of PersonID's, build a query on the fly, open the connection, send query to MYSQL.  After approximately 1000 iterations, the app fails.

[23 Jan 2006 12:14] MySQL Verification Team

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

Additional info:

Please provide the code how you are doing the connection/query.
If for every query you are creating a new connection and without
to close it, then you are without resources: maximum connection
allowed or ephemeral TCP/IP ports Windows's issue.