Problem with Stored Procedure and MYDAC 5

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
iad
Posts: 34
Joined: Fri 24 Nov 2006 07:38

Problem with Stored Procedure and MYDAC 5

Post by iad » Sat 24 Mar 2007 07:47

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,

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 27 Mar 2007 12:57

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.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Thu 29 Mar 2007 07:04

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).

Post Reply