Hi All

This may sound a bit odd, but I would like to go back from Sql Server to Ce. The problem is I need to take a project from one pc to another to complete it. It was set up on a machine with Sql Server, probably Express. The guy who did it has left and nobody is sure where his database is! The site is unpublished. Is there a way to do this? So far I have tried to change the <connectionStrings> in WebMatrix. I just copied from another project to:

 </appSettings>
  <connectionStrings>
    <remove name="umbracoDbDSN" />
      <add name="umbracoDbDSN" connectionString="Data Source=|DataDirectory|\Umbraco.sdf;Flush Interval=1;" providerName="System.Data.SqlServerCe.4.0"/>
    <!-- Important: If you're upgrading Umbraco, do not clear the connection string / provider name during your web.config merge. -->
  </connectionStrings>
  

But that didn't work. I got this...

Server Error in '/' Application.

---

Error running Reader:
SQL Statement:
SELECT id, domainName FROM umbracoDomains ORDER BY id

Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): The database file cannot be found. Check the path to the database. [ Data Source = E:\Chausser\App_Data\Umbraco.sdf ]
  at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
  at System.Data.SqlServerCe.SqlCeConnection.Open()
  at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
  at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
  at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

Any ideas?

Thanks

Tony