Z
zapov
Hi!
I'm having some wierd problems with this exception (error).
If I use sql commands to insert data into sql server i get
strange behaviour from my application.
First I used a single threaded application and used
Application.DoEvents() when i needed to wait some time.
(I need to process some external information on events
so I can't just use Thread.Sleep).
I need to store some information on regular basis interval
(about 1 minute) so firstly i used xml to store information.
But after application executed for some time DataSet used to
store information would get destroyed (?!) and I would receive
Object not set to reference error. So I switched to SQL server.
First choice MSDE. I used stored procedures and executed them
from application, but application showed strange behaviour and
would sometimes stop when executing stored procedures for a few
seconds. Often it would stop and would not continue.
So I switched to MySQL and text queries. But I started to receive
StackOverflowException. I got confused and changed application
so it's not anymore a single threaded application and instead
of Application.DoEvents() I use Thread.Sleep
But strangely the Stackoverflowexception remained.
In application if instead of executing nonqueries I just return
from that function program works fine. There is nothing wrong
with sql part of the code, but I can't get a lock on the problem.
I'm getting desperate with this problem. Using .NET 1.1 with SP1
on WinXP SP2.
I'm having some wierd problems with this exception (error).
If I use sql commands to insert data into sql server i get
strange behaviour from my application.
First I used a single threaded application and used
Application.DoEvents() when i needed to wait some time.
(I need to process some external information on events
so I can't just use Thread.Sleep).
I need to store some information on regular basis interval
(about 1 minute) so firstly i used xml to store information.
But after application executed for some time DataSet used to
store information would get destroyed (?!) and I would receive
Object not set to reference error. So I switched to SQL server.
First choice MSDE. I used stored procedures and executed them
from application, but application showed strange behaviour and
would sometimes stop when executing stored procedures for a few
seconds. Often it would stop and would not continue.
So I switched to MySQL and text queries. But I started to receive
StackOverflowException. I got confused and changed application
so it's not anymore a single threaded application and instead
of Application.DoEvents() I use Thread.Sleep
But strangely the Stackoverflowexception remained.
In application if instead of executing nonqueries I just return
from that function program works fine. There is nothing wrong
with sql part of the code, but I can't get a lock on the problem.
I'm getting desperate with this problem. Using .NET 1.1 with SP1
on WinXP SP2.