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.