There is already an open DataReader associated with this Connection which must be closed first, AGAIN !!!!!!

From: ItsMe (kkk_at_yahoo.com)
Date: 02/10/04 

Date: Tue, 10 Feb 2004 14:30:39 +0800

Hi,

I know, i'm repeating this question again. Please accept my apologize,
unable to understand clearly. Need to have some inputs in my routine. I'VE A
DEADLINE AND I'M STUCK !!!!! :(

I'm retrieving Data from Paradox database using (odbc), manipulating and
saving in access for report generation.

I'm trying to put what i'm doing simple pseudocode:
==================================

- Write SQL Statement and Retrieve Data from Paradox Tables using
DataAdapterParadox (OdbcConnection)
- Loop through the records till end-of-file
- Manipulate Data
            - Writing SQL Statement to get some values from another table of
same paradox database
- Insert retrieved values from two sql statement into Access Table
- Close connection

My vb.net code:
===========
    sSQL = "SELECT C.BRANDCODE, SUM(B.QTY) AS QTY" & _
                    " FROM SALESINFO A, DOMODELINFO B, PRODUCTINFO C" & _
                    " WHERE A.INVNO = B.INVNO AND A.YEAR = " &
CInt(cmbTotalSalesYear.Text) & _
                    " AND B.MODEL = C.MODEL" & _
                    " GROUP BY C.BRANDCODE ORDER BY C.BRANDCODE"
            oDataReaderPdx = mDBReaderPdx(sSQL)
            With oDataReaderPdx
                If .HasRows Then
                    While .Read

                        ' Here i want to write another sql statement, match
brandcode with another tables and get the total amount for that.
                        ' If I use another datareader, it says "There is
already an open DataReader associated with this Connection which must be
closed first"
                        ' How do i solve this issue ?

                        Dim iTotalJan As Int32
                        sSQL = "INSERT INTO tblYearlyReport (ReportType,
ComputerName, " & _
                                " FirstField, Qty)" & _
                                " VALUES (" & mQuotedStr("TOTALSALES") & ","
& _
                                mQuotedStr(mGetComputerName()) & "," & _
                                mQuotedStr(.GetValue(0)) & "," & _
                                .GetValue(1) & ")"
                        mExecCmdAccess(sSQL)
                    End While
                End If
                .Close()
            End With

I hope you guyz understood my problem. Please Help !!!!

Thanks in Advance.

Relevant Pages

  • Re: There is already an open DataReader associated with this Connection which must be closed first,
    ... Dim objComm As New SqlCommand ... > I'm retrieving Data from Paradox database using, ... > same paradox database ... > already an open DataReader associated with this Connection which must be ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cache Issues
    ... I ended up putting trace stuff everywhere and found the offending statement: ... I was opening a connection to the database independent of getting the data ... loaded from the DB and not from the cache. ... > finished retrieving data from the cache.... ...
    (microsoft.public.dotnet.framework.aspnet)
  • Paradox Database Connection
    ... I'm an amateur programmer and I have been using Delphi but want to start ... I need to connect to some existing Paradox database tables but I'm not ... If I try and create a data server using OLEDB, I get a error message saying ... "Could not find installable ISAM" when I try and test the connection. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Cant connect to Oracle 9i when connected to DB2
    ... > (without retrieving data from either, ... I get a core dump when I try to open the Oracle ... > connection. ...
    (perl.dbi.users)
  • Re: General ODBC error AS400
    ... here is a great website for connection issues ... I am retrieving data from AS/400 database to a worksheet ... General ODBC error " ... Must be a problem with my connection string, ...
    (microsoft.public.excel.programming)