Page 1 of 1

Connection Lost during query

Posted: Thu 14 Apr 2005 08:39
by Stephan Wild
i use the mysql components with the unidirect components in a server program. when the connection is not used over the interactive timeout and then used again i get this exception.
in my code i call connection.open() before and connection.Close() after the db access.

does anyone know this problem?

thx

Posted: Thu 14 Apr 2005 09:18
by Serious
Use Ping() method and recreate connection if necessary.

Posted: Fri 15 Apr 2005 12:04
by Stephan Wild
I use UniDirect i dont know if the connection is an mysql or mssql or whatever.

the unidirect connection doesnt have an ping method.

i think the cleaner way would be that this ping method is called in the open method of the Mysql provider.

Posted: Mon 18 Apr 2005 06:48
by Serious
Which version of MySQLDirect version do you use?
Do you have this problem when you use native MySqlDirect .NET MySqlConnection component instead of UniConnection?

Posted: Thu 21 Apr 2005 09:03
by Stephan Wild
I use version 2.50 of the mysqldirect components.
I dont know whether the problem exists when using mysql direct.

Posted: Thu 21 Apr 2005 09:16
by Serious
Please download latest version of MySQLDirect .NET.