Re: Database file already opened when synchronizing

From: Earl (brikshoe_at_newsgroups.nospam)
Date: 11/02/04 

Date: Tue, 2 Nov 2004 13:26:48 -0500

Thanks Darren, and I understand the limitation, but I was looking for an
elegant way to ensure that situation did not inadvertently arise (say the
user had the Query Analyzer open in a background window) because the user
usually would not be aware of that limitation.

"Darren Shaffer" <darrenshaffer@discussions.microsoft.com> wrote in message
news:e7TinnJwEHA.3296@TK2MSFTNGP10.phx.gbl...
> Earl,
>
> SQL CE databases are limited to a single open connection at any
> time. If Query Analyzer is running on your device, it is using that
> connection,
> therefore your application cannot. When exiting Query Analyzer, be sure
> to use the Tools-->Exit option or the connection will not be closed.
>
> In SQL Mobile, multiple connections to the database are supported, so
> this will be a non-issue.
>
> -Darren
>
> "Earl" <brikshoe@newsgroups.nospam> wrote in message
> news:O3ARtFIwEHA.2540@TK2MSFTNGP09.phx.gbl...
>>I have noticed that if a PocketPC Query Analyzer has the database opened
>>at the time I try to synchronize with the backend database, the program
>>generates several exceptions. While that scenario may not occur very
>>often, I'd like to protect against it happening -- can anyone recommend
>>the best method?
>>
>
>

Relevant Pages

  • Strange SQL Server CE 2.0 Problem
    ... Server CE database that is stored on a flash card inside the device. ... I can't use the SQL CE Query Analyzer -- the device ... selectCommand = new SqlCeCommand(sql, _connection, transaction); ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Database file already opened when synchronizing
    ... SQL CE databases are limited to a single open connection at any ... When exiting Query Analyzer, be sure ... In SQL Mobile, multiple connections to the database are supported, so ...
    (microsoft.public.sqlserver.ce)
  • Re: db in Single User mode yet can be accessed via odbc
    ... Can you login to Query Analyzer and execute SP_WHO and see whether there are ... any connection made to that database. ...
    (microsoft.public.sqlserver.server)
  • Re: ARITHABORT error when update from asp page
    ... This can happen if ADO acquires another connection behind the scenes because ... Note that you can include the SET ARITHABORT ON in the same batch as the ... You can also set ARITHABORT ON at the database level with ALTER DATABASE so ... Is there a way I can make it work in Query Analyzer ...
    (microsoft.public.sqlserver.programming)
  • Re: Stupid Question - I think!
    ... I know that the table was not updated because I go to the Query Analyzer on ... update statement shown below does run in the Query Analyzer on the PDA ... (against the CE database) ... "Earl" wrote: ...
    (microsoft.public.sqlserver.ce)