Il 21/04/2014 22.03, rava ha scritto:
I know, you have all code wich is involved in the error... for the parte
involved, no other function was called... i call executereader only for one
datareader and two Times directly to the command... do you found the other
datareader in the sent code? If exist it have to be in the sent code, but i
don't see nothing.. you could?
Joe Mistachkin <sql...@mistachkin.com> ha scritto:
Stefano Ravagni wrote:
Thanks for answer Joe, but as just sayed i have only one datareader,
That is not possible. There must be at least two different data reader
instances because the references in the watch window did not match.
Every time you call ExecuteReader, a brand new data reader is returned.
Keeping track of these returned data readers is very important because
they must all be properly disposed at some point.
i'm sure of that, and this is demostrated because with others provider
i have not error.
Perhaps the other providers do not have a restriction on resetting the
underlying connection for a command when data readers are active.
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Joe, i finally solve the error following your advices...
We search for a Datareader object, but we could not find.... There are
(as i sayed) only one datareader object as declared object.... but
thinking about your words when you saw ("Every time you call
ExecuteReader, a brand new data reader is returned.") i check for a call
to ExecuteReader WITHOUT association for DATI object (Datareader).
I found this line in a function wich load a Checklist ...
frmAutomazione.SorgenteAutomazioni.DataSource = objCmd.ExecuteReader
This line goes out of what i've searched for....but one time i change
this code, all goes good!!!
So, i'm sorry for my insistence, but finally with your help i became
able to find the problem and adjust it !!!
Thank you Thank you Thank you Thank you very much !!!
I would to make a little donation to your work....exist a way ??
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
