Connection Lost during query

Connection Lost during query

Postby 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
Stephan Wild
 

Postby Serious » Thu 14 Apr 2005 09:18

Use Ping() method and recreate connection if necessary.
Serious
 

Postby 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.
Stephan Wild
 

Postby 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?
Serious
 

Postby 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.
Stephan Wild
 

Postby Serious » Thu 21 Apr 2005 09:16

Please download latest version of MySQLDirect .NET.
Serious
 


Return to dotConnect for MySQL