Devart Forums

I have frequentely this error message . What do I have to do ?

This error happens if you have open DataReader and execute another command with the same connection. Mare sure that you always close DataReader, or open DataReader from the command with FetchAll = true.

Hi, I too am getting this error, however my app doesn't any DataReaders - All it uses is 'Fill' (for which I obviously don't manually open and close the tables) and 'ExecuteNonQuery' (where I always explicitly open and close the tables). When I switch off connection pooling (thru the connection object) the problem appears to disappear. Does anyone have any idea what might be causing this problem? I'm converting the application from OleDb to the CoreLab components and under OleDb the app runs fine.

I'm currently still using the trial version of v2.7 with VS 2003, C#, XP and MySQL v4.1.

Thanks

This problem can happen if you use the same connection from different threads. Please advise if this error raises the first or may be follow another one.

Oleg wrote:This problem can happen if you use the same connection from different threads. Please advise if this error raises the first or may be follow another one.

Big problem, we cannot just simply open and close all many connections as it degrade the performance. We might need to have multiple sql in one single form to load data. This issue does not happen in version 2.0. only 2.7 I facing this problem. In ver 2.0, I faced another set of problem of max connection pool.

If you use pooling, server connections doesn't close when you call MySqlConnection.Close(). Connection pool was created to increase perfomance of applications like yours (appications which often open and close connections).
Implementation of Connection pool in MySQLDirect .NET v2.0 is a not as good as in the last version of MySQLDirect .NET Data Provider. Please use the newest versions of the product.
To use connection pooling set "pooling=true;" option in your connection string.

Hi Oleg,
i have this problem after the first execution of datareader:
"Net packets out of order: received[51], expected[1]"

Please help me....
Nunzio

Please describe in detail your problem.
If it is possible send small test project to reproduce the problem; it is desirable to use 'test' schema objects otherwise include definition of your own database objects; don't use third party components. Please specify size of your database objects (1Kb, 1Mb, 16Mb, 100Mb...)

The table size is about 80MB and the data retraived are more than 30.000 rows for each query.

Do you have BLOB data in your tables (specify max size )?

No BLOB field.
Please i'm online [email protected]

Please send us a piece of your code.
Specify MySQLDirect .NET and MySQL Server versions, include definition of your own database objects.
Please send us your answers to the support e-mail.