EMySQLException: "ReceiveHeader: Net packets out of order: received[6], expected[1]".
Posted: Mon 20 Feb 2006 22:15
I get an error when opening a Stored Procedure that returns a result set. The error only happens on second call to Open(). This happens when I "do the right thing" by calling Prepare() first. The help file specifically says I'll get faster execution by calling Prepare() myself (which seems really odd to me because Stored Procedures are already prepared on the Server side). If I don't call Prepare() then I get no error, but then I am really being nagged inside my head that I am yielding a slower execution. Here's the error returned:
EMySQLException: "ReceiveHeader: Net packets out of order: received[6], expected[1]"
My question is... is MyDAC the only client library that requires the programmer to call Prepare() for speedier Stored Procedure executions or is this help file in error? I am an extreme performance junkie. To the extreme. If there is a faster way to execute something then by golly, I'm going to opt for that routine. At this point though, I am thinking that Prepare() is irrelevent to Stored Procedures, plus help file is in error, plus actually calling Prepare() exposes a bug. But not sure about this.
Anyone with some experience on this?
Thanks,
Perry
EMySQLException: "ReceiveHeader: Net packets out of order: received[6], expected[1]"
My question is... is MyDAC the only client library that requires the programmer to call Prepare() for speedier Stored Procedure executions or is this help file in error? I am an extreme performance junkie. To the extreme. If there is a faster way to execute something then by golly, I'm going to opt for that routine. At this point though, I am thinking that Prepare() is irrelevent to Stored Procedures, plus help file is in error, plus actually calling Prepare() exposes a bug. But not sure about this.
Anyone with some experience on this?
Thanks,
Perry