Re: Replication file sharing violation

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 10:07:38 -0700

It appears from the error messages that you have not shut down an object
that is accessing the database. SQL Server CE is a single user database and
this type of error can occur when an object is not shut down or another
instance of the application is running. You should also check the
system|memory section on your device to see if an application that is
accessing SQL Server CE is still running.

"Benjamin" <Benjamin@discussions.microsoft.com> wrote in message
news:87E5690F-0190-455F-9CF5-5F8E3F585713@microsoft.com...
>I have a pocket pc which is updating itself from an SQL Server. I have had
> it working flawlessly up until now. For some reason it is giving me an
> error
> that it couldn't open the database file because there may be a sharing
> violation. Here is what I've found out by trying to debug the program.
>
> If I start the pocket pc emulater from scratch and run it, it will fail
> with
> this error, and every proceeding time will fail also. However if I start
> it
> from scratch and go through the code in step mode it will succeed and
> every
> proceeding time will succeed also even if not in step mode.
>
> At first I thought it might have been a timing issue, something needed
> more
> time and so it would only work when I went slowly in step mode, but then I
> discovered that it would work fine while not in step mode as long as it
> was
> put in step mode the very first time.
>
> The error messages that I am recieving are:
> Error Code: 80004005
> Message: SQL Server CE encountered problems in opening the SQL Server CE
> Database.
> Minor Err.: 28559
>
> and
>
> Error Code: 80004005
> Message: There is a file sharing violation. A different process might be
> using the file.
> Minor Err.: 25035
>
> Anyone have any ideas?

Relevant Pages

  • Re: Setting up Linked server to MsAccess
    ... What are the specific error messages and what application ... database as a linked server. ... group with full permissions to to folder, so the problem does not appear to ... I need a simple step by step on how to walk through the SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Syntax
    ... My understanding is that you have a SQL Server database with a table ... The error messages in your last post look like they're related to the ... Access database connection string, and not the Expression issue you're ...
    (microsoft.public.sqlserver.dts)
  • Cant create ADP database on MSDE using MS Access
    ... I can't seem to create an ADP Project database on MSDE using MS ... I get no error messages, but no database is created and I ... I've tried the SQL Server group but they can't solve it. ...
    (microsoft.public.access.setupconfig)
  • SQL Server Link from Excel
    ... I have a spreadsheet and am trying to link several cells to a SQL Server ... database and am getting error messages. ... The error messages are SQL Server ...
    (microsoft.public.excel.misc)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)