I'm trying to use SQL Server 2005 Compact Edition (3.1) with the Enterprise
Library data access block (3.1) . I want to be able to use the
DatabaseFactory.CreateDatabase method so it's all handled by the
configuration in app.config.

When I do I get an exception. "Failed to find or load the registered .Net
Framework Data Provider.".

Do you have any suggestions?

Thanks!

My machine config file already have:
<DbProviderFactories>
<add name="SQL Server Compact Edition Data Provider"
invariant="System.Data.SqlServerCe" description=".NET Framework Data Provider
for Microsoft SQL Server Compact Edition"
type="System.Data.SqlServerCe.SqlCeProviderFactory , System.Data.SqlServerCe,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</DbProviderFactories>
</system.data>