RE: ...Already a data reader associated...

[Jorge Bastos]

No, MySQL Driver version.

---
Well, I'm not sure.  When I go to the MySQL start menu item, it says, "MySQL
Connector Net 5.0.8.1".  So, I would appear to be running version 5.0.8 of
the connector.

Jesse
---

Well, it shouldn't happen then, can you try the new fresh 5.2.3 version and
see if it happens, and if it still happens, post something so that Reggie
can take a look on to it.



> -----Original Message-----
> From: Jesse [mailto:jc@stripped]
> Sent: terça-feira, 19 de Agosto de 2008 20:37
> To: Jorge Bastos; 'MySQL . Net List'
> Subject: Re: ...Already a data reader associated...
> 
> Sorry, I just realized that you were referring to the version of
> ASP.Net,
> correct?  Actually, I'm running version 2.0.50737 of ASP.Net.
> 
> Jesse
> ----- Original Message -----
> From: "Jorge Bastos" <mysql.jorge@stripped>
> To: "'Jesse'" <jc@stripped>; "'MySQL . Net List'"
> <dotnet@stripped>
> Sent: Tuesday, August 19, 2008 2:25 PM
> Subject: RE: ...Already a data reader associated...
> 
> 
> Hi Jesse,
> 
> This has been fixed in 1.0.8 version in the 1x series:
> 
> Bug #7248  There is already an open DataReader associated with this
> Connection which must
> (you can see this on the changes file)
> 
> You're using version 1x right?
> 
> 
> 
> > -----Original Message-----
> > From: Jesse [mailto:jc@stripped]
> > Sent: terça-feira, 19 de Agosto de 2008 18:53
> > To: MySQL . Net List
> > Subject: ...Already a data reader associated...
> >
> > I'm getting the error, "There is already an open DataReader
> associated
> > with
> > this Connection which must be closed first." when I close a
> DataReader.
> > Here's the code:
> >
> > Cmd = New MySQLCommand("SELECT AddPayment(" & _
> >    "'" & MySQLDateTime(Now) & "'," & _
> >    "'" & MySQLDateTime(Now) & "'," & _
> >    "'" & Replace(CardType.SelectedValue,"'","''") & "'," & _
> >    "'" & InvNo.Text & "'," & _
> >    "''," & _
> >    cTotal & "," & _
> >    "'') As PayID",Conn)
> > RS=Cmd.ExecuteReader()
> > if RS.Read then
> >    cPID = RS("PayID").ToString
> > end if
> > RS.Close // ERROR OCCURS HERE
> > RS=Nothing
> >
> > AddPayment() us a function:
> >
> > CREATE DEFINER = 'root'@'localhost' FUNCTION `AddPayment`(dPayDate
> > DATETIME,
> > dDepositDate DATETIME, cPayType varchar(20), cInvNo varchar(7),
> > cCheckNo
> > varchar(20), nAmount double(10,2), cNotes TEXT)
> >     RETURNS int(11)
> >     DETERMINISTIC
> >     CONTAINS SQL
> >     SQL SECURITY DEFINER
> >     COMMENT ''
> > BEGIN
> >    INSERT INTO Payments
> > (PayDate,DepositDate,PayType,InvNo,CheckNo,Amount,Notes) VALUES
> >       (dPayDate, dDepositDate, cPayType, cInvNo, cCheckNo, nAmount,
> > cNotes);
> >    RETURN LAST_INSERT_ID();
> > END;
> >
> > If this were truely a "..already has a datareader associated.."
> error,
> > then
> > it would occur on the "Cmd.ExecuteReader()" line, not the RS.Close
> > line, so
> > I believe that this error doesn't really mean what it says.
> >
> > Does anyone have any clues on this?
> >
> > Thanks,
> > Jesse
> >
> >
> > --
> > MySQL on .NET Mailing List
> > For list archives: http://lists.mysql.com/dotnet
> > To unsubscribe:
> > http://lists.mysql.com/dotnet?unsub=1
> 
>