First, I apologize if this is a duplicate question. I'm new to the forums. I've also posted this question on Stack Overflow (http://stackoverflow.com/questions/11567504/umbraco-sql-server-ce-there-is-a-file-sharing-violation-a-different-process) and am duplicating it here:

Basically, I've setup Umbraco 4.7.2 to use SQL Server CE. Everything works as expected in my development environment. However, after publishing (via WebMatrix 2) to a GoDaddy 4GH shared hosting account, it's been a completely different story.

Initially, everything worked as expected. But as soon as others tried to connect to the site, everyone started receiving the following error:

System.Data.SqlServerCe.SqlCeException: There is a file sharing violation. A different process might be using the file. [ ..\App_Data\Umbraco.sdf ]

I've done some research and I understand that SQL Server CE doesn't allow multiple connections, but I find it hard to believe that Umbraco would offer SQL Server CE as an option if it wasn't capable of allowing multiple visitors to navigate a site.

I've tried modifying the connection string per other resources and am not having any luck. Here's my current connection string:

datalayer=SQLCE4Umbraco.SqlCEHelper,SQLCE4Umbraco;data source=|DataDirectory|\Umbraco.sdf;file mode=read write;persist security info=false;

I've tried different file modes such as Read Only and Shared Read with no luck. How do you overcome this issue? Is this somehow a problem with the hosting environment or a problem with the connection string? Thanks.