Page 1 of 1

Problem with Stored Procedure and MYDAC 5

Posted: Sat 24 Mar 2007 07:47
by iad
HI,
i just upgraded from 4 to 5 and i encounter problem with Stored procedure.
issue is this:
1. PUt Stored procedure on the form and set the parameters. run the procedure and all is OK.
2. put Data source and conect it to the SP - all is OK
3. connect Data Grid ( any) and run the SP ( in design time) i'm getting the error
ReceiveHeader:_Net packets out of order:_received[13], expected[1].
and from now on non of any calls to DB is OK and i get the error.
only switch the MySQLConnection Active to False and Then True is able to solve the problem that happened again when i run the SP again.

Any Idea ?

Lior,

Posted: Tue 27 Mar 2007 12:57
by Antaeus
I could not reproduce the problem.
Please send me a complete small sample at evgeniyD*crlab*com to demonstrate it, including script to create the stored procedure.

Also supply me the following information:
- exact version of Delphi, C++Builder or Kylix;
- exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- exact version of MySQL server and MySQL client. You can see it in the Info sheet of TMyConnection Editor.

Posted: Thu 29 Mar 2007 07:04
by Antaeus
We managed to reproduce and fix the problem. This fix will be included in the next MyDAC build.
As a temporary solution you can disable or uninstall the DataSet Manager (the "CoreLab DataSet Manager" package in the Component | Install Packages menu of your IDE).