MySQL Bugs: #13609: MYODBC Causing Excel-VBA error

Bug #13609	MYODBC Causing Excel-VBA error
Submitted:	29 Sep 2005 14:16	Modified:	31 Jul 2007 6:29
Reporter:	Marcel van Lochem	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	4.1.12	OS:	Windows (Windows Server 2003)
Assigned to:		CPU Architecture:	Any

Description:
I'm using MYSQL Server 4.1.12 with MYSQL ODBC 3.51.11 running on Windows Server 2003.  My application is based in Microsoft Excel 2002 (10.2614.2625) VBA.

The VBA interface uses ADODB to connect to the ODBC driver.  The VBA applications purpose is to simply collect (add) and update information in the database.

The error that the users are getting is:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10038)

When I look at the MYSQL Adminstrator Error Log the following error appears:

[Warning] Aborted connection 26900 to db: 'data' user: 'generalUser' host: `localhost' (Got an error reading communication packets) 

How to repeat:
I'm currently not able to consistently create this error.  The users will have it occur once or multiple times in a row.

This problem appears to be occuring more frequently now that more users are logged in and are collecting more information.

Suggested fix:
I'm wondering if it has anything to do with opening/re-opening the database connection with each step in the data collection procedure.  I'm also wondering if the ODBC and VBA don't like each other and as a result consistently do not generate connections.

Hi!

I was unable to reproduce this bug.  Can you please find a manner to reproduce this problem consistently or provide us with a test-case that reproduces this bug ?

Thanks a lot!

After some forscenic investigation by one of the project leads the problem has been isolated to the following application:

Keyboard Logger 1.1 from PanteraSoft.com

This application was setup to help with debugging user created errors but it seems to randomly interfere with ODBC communication between MYSQL and Excel-VBA.

Once the application was remove the error messages ceased.

Marcel, thanks for info provided.