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
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 you
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, bu
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
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... w
Stefano Ravagni wrote:
>
> i've built a very little application wich could reprocude the "CANNOT SET
> CONNECTION WHILE DATAREADER IS ACTIVE" error.
>
I've run the project with Visual Studio 2013 and determined that the
exception
being raised is almost certainly not an issue with System.Data.SQL
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
"EstraiDatiAlVo
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 al
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
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 System.Dat
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
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 be
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 be
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 vis
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 information
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 Ha
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 Ha
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 ha scritto:
>
>
>
> Stefano Ravagni wrote:
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 see if the _activeReade
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 Mi
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 fiel
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 in
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
'
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 Ha
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
> ROWS,
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
sqlite-users@sqlite.org
http://
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
'
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 metho
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 alt
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 err
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 th
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 a
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 a
33 matches
Mail list logo
