HEllo Joe, i've built a very little application wich could reprocude the "CANNOT SET CONNECTION WHILE DATAREADER IS ACTIVE" error.
While extracting data and populate a checklist, you could see the error...just launch the project. I've putted block debug point in a function called "EstraiDatiAlVoloAutomation" where you could found the point were the code go in error after somes passages... sometimes at the first, somes others in second or after... If you observe the code you could see it say datareader is active when dati.isclosed say TRUE... In the "frmPrincipale.vb" form you can set the code to run under ACCESS version simply changing 2 string, and you can see it not generate this error, as not generate in many other database system... Becaus of "slimming" a big source code, consider maybe you could encounter somes others error which have not to say with the problem i ask solution....i'm sorry for that, i tryed to make a slim project for reproduce error only... A put a RAR archive with the slim project at this link: https://www.dropbox.com/s/bugysawir52ivna/TestSQLite.rar 2014-04-20 6:00 GMT+02:00 Joe Mistachkin <sql...@mistachkin.com>: > > Stefano Ravagni wrote: > > > > Is a big project wich re-call many function and interacts many times > > with sqlite provider... i could try to isolate a piece of code but > > isolating the code i don't know if the error will be reproduced...but i > > will try.... is all VB code....are you interested to receive a ZIP file > > containing a little piece of code with also database ? Or exist another > > way to find the error in your mind ? > > Thanks for answer!!! > > > > It would be great if you could come up with an isolated body of code that > demonstrates the issue. Since this mailing list strips attachments, you > could post a link to a ZIP file that can be downloaded. > > -- > Joe Mistachkin > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users