From: Date: August 19 2008 9:35pm
Subject: Re: ...Already a data reader associated...
List-Archive: http://lists.mysql.com/dotnet/1302
Message-Id: <000301c90232$b25c17d0$6901a8c0@ANCHORMAN>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 8bit

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

----- 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=mysql.jorge@stripped



-- 
MySQL on .NET Mailing List
For list archives: http://lists.mysql.com/dotnet
To unsubscribe:    http://lists.mysql.com/dotnet?unsub=jc@stripped