System.Data.SQLite

Hello, i try to submit this problem because have not evident solution.

I obtain this error:

"cannot set connection while a datareader is active"

in a code that have just closed datareader...

It happen only in SQlite so i would ask your help please.

Here a cose used.


+++++++++++++++++++++++++++++
Public Dati As System.Data.Common.DbDataReader 
Public objCmd As System.Data.Common.DbCommand 

Try

Call CloseDati()

objCmd.Connection = Connetti 'Here start the error
objCmd.CommandText = strSQLvar 
Dati = objCmd.ExecuteReader() 
            
Catch ex As Exception
       MsgBox("error message " & vbCrLf & vbCrLf & ex.Message, MsgBoxStyle.Exclamation)

End Try

I use provider factory with SQlite dll v 1.0.92.0 with option "Flags=StickyHasRows"

I've added a test case for this issue, here:

[/artifact?ci=trunk&filename=Tests/tkt-d0116ee2c3.eagle]

However, I'm unable to reproduce the issue being described.  Is it possible
that the data reader associated with the command is *NOT* being closed prior
to attempting to reset the connection?

This ended up being an issue with the code using System.Data.SQLite.  In this
case, it was a data reader leaked from the ExecuteReader method.