RE: Blocking sql statement?
- From: Thorsten Kleinhenz <ThorstenKleinhenz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 5 Jul 2005 06:03:02 -0700
Some more information:
Some sql statements I send to the database contain some invisible
characters, e.g. carriage return, as they come from a xml file. Could this
cause any trouble with the SQLServerCE-parser?
Regards,
Thorsten
"Thorsten Kleinhenz" wrote:
> Hello NG,
> we use SQLServerCE 2.0 in our VB.NET-application and have sometimes problems
> with how it seems blocking sql statements (statements that normally works a
> 100times a day...).
>
> We have about 1000 rows in our database in ~10 tables. There are made a lot
> of reads, some inserts, some updates. The data changes about every 3 hours -
> it's deleted and new data is inserted - with this "update" we compact the
> database (before new data is inserted).
> Now the problem that occurs is that some clients (total count is ~30)
> sometimes hang, meaning that in my application's logfile I can see the last
> executed sql statement, but this method does not return or throws any
> exception. It seems that the application waits for the resultset and doesn't
> get it. Curiously, after exiting and restarting the application, which means
> compacting the database, too, the error doesn't occur any longer - until next
> time...
>
> So my question is, does anybody knows/recognises this behaviour or can give
> me some information about debugging a SQLServerCE? Is there a trace/logfile?
>
> Kind regards,
> Thorsten
.
- References:
- Blocking sql statement?
- From: Thorsten Kleinhenz
- Blocking sql statement?
- Prev by Date: Blocking sql statement?
- Next by Date: Re: mixing merge replication with RDA
- Previous by thread: Blocking sql statement?
- Next by thread: RE: Blocking sql statement?
- Index(es):
Relevant Pages
|
