Problem with Stored Procedure and MYDAC 5
Posted: 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,
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,