Connection Lost during query

Stephan Wild · Post by **Stephan Wild** » Thu 14 Apr 2005 08:39

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

Serious · Post by **Serious** » Thu 14 Apr 2005 09:18

Use Ping() method and recreate connection if necessary.

Stephan Wild · Post by **Stephan Wild** » Fri 15 Apr 2005 12:04

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.

Serious · Post by **Serious** » Mon 18 Apr 2005 06:48

Which version of MySQLDirect version do you use?
Do you have this problem when you use native MySqlDirect .NET MySqlConnection component instead of UniConnection?

Stephan Wild · Post by **Stephan Wild** » Thu 21 Apr 2005 09:03

I use version 2.50 of the mysqldirect components.
I dont know whether the problem exists when using mysql direct.

Serious · Post by **Serious** » Thu 21 Apr 2005 09:16

Please download latest version of MySQLDirect .NET.