netpackets out of order

Marius · Post by **Marius** » Sat 29 Sep 2007 05:14

Hi

When using a stored procedure with parameters the second time that the stored procedure is run, it returns the error above. I tested the stored procedure with a straight select procedure and it runs without errors. I put together a test case and can send it to you with a database.

I also checked that my libmysql.dll file is the latest version. I am using mysql server ver 5.0.41 and client ver 5.1.1. I also include the bds 2006 error which may mean something to you below.

+ $88[0A0B20C0]{mydac100.bpl} Myclasses.TMySQLConnection.MySQLError + $88
+ $2A[0A0B4762]{mydac100.bpl} Myclasses.TMySQLCommand.Check + $2A
+ $B1[0A0B5891]{mydac100.bpl} Myclasses.TMySQLCommand.Execute + $B1
+ $10[09F08058]{dac100.bpl } Craccess.TCRRecordSet.ExecCommand + $10
+ $F[09F08073]{dac100.bpl } Craccess.TCRRecordSet.ExecFetch + $F
+ $1B[0A0B7087]{mydac100.bpl} Myclasses.TMySQLRecordset.InternalOpen + $1B
+ $31[09EF814D]{dac100.bpl } Memdata.TData.Open + $31
+ $0[09F0008C]{dac100.bpl } Memdata.TMemData.Open + $0
+ $76[0A0B4342]{mydac100.bpl} Myclasses.TMySQLConnection.CreateProcCall + $76
+ $8D[0A0C8485]{mydac100.bpl} Myaccess.CreateProcCall + $8D
+ $C2[0A0D0132]{mydac100.bpl} Myaccess.TCustomMyStoredProc.PrepareSQL + $C2
+ $8[0A0D050C]{mydac100.bpl} Myaccess.TCustomMyStoredProc.OpenCursor + $8
+ $47[09F1D24B]{dac100.bpl } Dbaccess.TCustomDADataSet.SetActive + $47
+ $0[51F4AC2E]{rtl100.bpl } TypInfo.TypInfo.SetOrdProp (Line 1318, "TypInfo.pas" + 27) + $0
+ $6[20EFD30A]{designide100.bpl} DesignEditors.DesignEditors.TEnumProperty.SetValue (Line 1402, "DesignEditors.pas" + 5) + $6
+ $24[20FDDD84]{vclide100.bpl} IDEInspListBox.IDEInspListBox.TInspListBox.SetPropValue (Line 1145, "ideinsplistbox.pas" + 40) + $24
+ $7[20FDF414]{vclide100.bpl} IDEInspListBox.IDEInspListBox.TInspListBox.ListAccept (Line 1636, "ideinsplistbox.pas" + 6) + $7
+ $12[20FDACF6]{vclide100.bpl} IDEListBtns.IDEListBtns.TListButton.CloseUp (Line 752, "IDEListBtns.pas" + 14) + $12
+ $6[5205CA19]{vcl100.bpl } Controls.Controls.TWinControl.WndProc (Line 7246, "Controls.pas" + 105) + $6
+ $4[00500EAB]{idectrls100.bpl} IDEWideStdCtrls.IDEWideStdCtrls.TWideCustomListBox.WndProc (Line 4425, "IDEWideStdCtrls.pas" + 14) + $4
+ $0[51F60BC0]{rtl100.bpl } Classes.Classes.StdWndProc (Line 11572, "classes.pas" +

+ $0
+ $6A[7E418731]{USER32.dll } GetDC + $6A
+ $14A[7E418811]{USER32.dll } GetDC + $14A
+ $122[7E4189C8]{USER32.dll } GetWindowLongW + $122
+ $A[7E418A0B]{USER32.dll } DispatchMessageW + $A

Please send me an email address and I will upload the test case with the database

Thanks
Marius

Antaeus · Post by **Antaeus** » Mon 01 Oct 2007 07:56

There are several known problems with stored procedures of MySQL returning result sets. A couple of them is described in the FAQ. If the problem you have encountered differs from the description, please send your test sample to mydac*crlab*com.

pcpgmr · Post by **pcpgmr** » Tue 18 Aug 2009 22:33

Can you repost the link to the FAQ mentioned. I am curious what known issues there are for MySQL and stored procedures.

Thank you,

Daniel

Challenger · Post by **Challenger** » Fri 21 Aug 2009 08:26

We have updated the link. Sorry for the inconvenience.

pcpgmr · Post by **pcpgmr** » Fri 21 Aug 2009 14:49

Sorry, Adventurer, but the FAQ link above my original post is still broke and shows a 404 error, file not found.

Can you repost the link to the FAQ mentioned. I am curious what known issues there are for MySQL and stored procedures.

Maybe, you could just post a new, fresh link to the FAQ he spoke about.

Thank you,

Daniel

Challenger · Post by **Challenger** » Tue 25 Aug 2009 05:37