Re: [sqlite] cannot set connection while a datareader is active

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

Re: [sqlite] cannot set connection while a datareader is active

Il 21/04/2014 21.54, Joe Mistachkin 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

Re: [sqlite] cannot set connection while a datareader is active

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,

Re: [sqlite] cannot set connection while a datareader is active

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

Re: [sqlite] cannot set connection while a datareader is active

Thanks for answer Joe, but as just sayed i have only one datareader, i'm sure of that, and this is demostrated because with others provider i have not error. Try please changing the first lines of code in frmprincipale.vb form as explained for match access database... you Will not have error...

Re: [sqlite] cannot set connection while a datareader is active

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

Re: [sqlite] cannot set connection while a datareader is active

Il 20/04/2014 6.00, Joe Mistachkin ha scritto: 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

Re: [sqlite] cannot set connection while a datareader is active

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 codeare you interested to

Re: [sqlite] cannot set connection while a datareader is active

Il 19/04/2014 20.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe have you somes help advice for my case ? I don't receive your answer from 3 days... I'm still unable to reproduce the behavior you describe here locally. Are you able to post all the code that interacts with

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Joe have you somes help advice for my case ? I don't receive your answer > from 3 days... > I'm still unable to reproduce the behavior you describe here locally. Are you able to post all the code that interacts with System.Data.SQLite? That might help me to narrow

Re: [sqlite] cannot set connection while a datareader is active

Il 16/04/2014 22.33, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i cannot find the way for follow the command object properties you saycould you tell me what and how to observe exactly please ? You might need to add the System.Data.SQLite project(s) to the solution in order to

Re: [sqlite] cannot set connection while a datareader is active

Il 16/04/2014 22.33, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Joe i cannot find the way for follow the command object properties you saycould you tell me what and how to observe exactly please ? You might need to add the System.Data.SQLite project(s) to the solution in order to

Re: [sqlite] cannot set connection while a datareader is active

Ops... i'm not able to do this, never used first and don't know c# so well to understand the project. Can i try somes others way from my project?? Have you idea about why with the same code the sqlite provider is the only wich give me this error? Could depend from a query ? But i don't obtain

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Joe i cannot find the way for follow the command object properties you > saycould you tell me what and how to observe exactly please ? > You might need to add the System.Data.SQLite project(s) to the solution in order to be able to see full debugging

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 21.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, tryed to change the code in the IF expression but nothing change I would ask if you seen the screenshot i attached somes days ago because it show what happen From debugger Datareader result CLOSED and

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 21.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, tryed to change the code in the IF expression but nothing change I would ask if you seen the screenshot i attached somes days ago because it show what happen From debugger Datareader result CLOSED and

Re: [sqlite] cannot set connection while a datareader is active

Hello Joe, i'm here for try but i cannot find how to test _activeReader method as you say...could you tell me how to test it? 2014-04-15 10:19 GMT+02:00 rava : > How could i do this? By debugging and adding a watch to the object? > > > > Joe Mistachkin

Re: [sqlite] cannot set connection while a datareader is active

How could i do this? By debugging and adding a watch to the object? Joe Mistachkin ha scritto: > >Stefano Ravagni wrote: >> >> So what have i do? Need to see others setting or state? >> > >It would be useful to try and examine the internal state of the >SQLiteCommand and

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > So what have i do? Need to see others setting or state? > It would be useful to try and examine the internal state of the SQLiteCommand and see if the _activeReader member is valid. If it is valid, see if it actually refers to the data reader you are using. -- Joe

Re: [sqlite] cannot set connection while a datareader is active

So what have i do? Need to see others setting or state? If yes how? Could be a problem solved with a New compilation of dll? The strange thing is it happen sometimes in one passage, sometimes in another of proposero function. Could be generated by execution of particular sql query with date

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Can i send you a screenshot where you could see with your eyes my debug > situation ? So you could observe it cannot say there is a datareader > active and in the same time show that datareader is closed... > I've seen the screenshot; however, it does not show the

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 0.22, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, here my code for CloseDati to help you to reproduce the error that i don't understand... ++ Public Sub CloseDati() 'chiude i dati del datareader associati all'oggetto DATI cui

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 21.12, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, tryed to change the code in the IF expression but nothing change I would ask if you seen the screenshot i attached somes days ago because it show what happen From debugger Datareader result CLOSED and

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Hello Joe, tryed to change the code in the IF expression but nothing > change > I would ask if you seen the screenshot i attached somes days ago because > it show what happen > > From debugger Datareader result CLOSED and HasRows properties result NO >

Re: [sqlite] cannot set connection while a datareader is active

On 14 Apr 2014 at 15:14, Stefano Ravagni wrote: > I would ask if you seen the screenshot i attached somes days ago because > it show what happen Attachments are not allowed here. tim. ___ sqlite-users mailing list

Re: [sqlite] cannot set connection while a datareader is active

Il 14/04/2014 0.22, Joe Mistachkin ha scritto: Stefano Ravagni wrote: Hello Joe, here my code for CloseDati to help you to reproduce the error that i don't understand... ++ Public Sub CloseDati() 'chiude i dati del datareader associati all'oggetto DATI cui

Re: [sqlite] cannot set connection while a datareader is active

Thanks for answer. Today i'll try to update my code as you say and i'll feedback the result. However i don't think is a solution because just tried to use a line of code simplest as possibile,like only "datareader.close()" but still not work. The error is catched not during datareader close

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Hello Joe, here my code for CloseDati to help you to reproduce the error > that i don't understand... > > ++ > Public Sub CloseDati() > > 'chiude i dati del datareader associati all'oggetto DATI cui > ' spesso sono attaccati anche

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > The code run from 4 years over Access, MySql, PostgreSQL and no trace > about a similar error or datareader still open message. > So i'm confused using SQlite and receive this error. > > I confirm that i use only one datareader in the project, and while > receive

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > Hello, i use this code for a function wich run in all database except > Sqlite.. > I've written a test case and added some comments to the ticket, here: http://system.data.sqlite.org/index.html/info/d0116ee2c3 Meanwhile, could you please post the code for

Re: [sqlite] cannot set connection while a datareader is active

Stefano Ravagni wrote: > > "cannot set connection while a datareader is active" but nothing apparent > cause this bahavior Is a knowed error message tha i could fix ? > The only way to obtain this error message is to attempt to set the Connection property of a SQLiteCommand object while

[sqlite] cannot set connection while a datareader is active

Hello, i have a problem with SQlite and i would ask if someone had solved it. I obtain this error: "cannot set connection while a datareader is active" but nothing apparent cause this bahavior Is a knowed error message tha i could fix ? If i drive slow execution of code debugging it