Installing Suteki DB brought down all my orchard CMS websites

[Andi]

"Unable to load the native components of SQL Server Compact
corresponding to the ADO.NET provider of version 8482. Install the
correct version of SQL Server Compact. Refer to KB article 974247 for
more details.
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.

Exception Details: System.Data.SqlServerCe.SqlCeException: Unable to
load the native components of SQL Server Compact corresponding to the
ADO.NET provider of version 8482. Install the correct version of SQL
Server Compact. Refer to KB article 974247 for more details."

I've look at the knowledge base article but not quite sure on the way
forward. Wondered if you had had this problem too?

[Mike Hadlow]

Hi Andi,

When you run the sutekishop database creator
(Suteki.Shop.CreateDb.exe) it does the following (all via standard T-
SQL commands):

1. Drops the database configured in the
Suteki.Shop.CreateDb.exe.config connection string.
2. Creates a new database with the configured name.
3. Inserts all the lookup (static) data that Suteki Shop needs, so
that you can start with a working system.

I've never tried to use it with SQL Server Compact edition, so it's
untested against that database technology. The connection is
configured to use NHibernate's SQL Server adaptor, so I'm not
surprised that you are seeing messages like 'Unable to load the native

components of SQL Server Compact corresponding to the ADO.NET provider

of version 8482'.

If you are determined to use SQL CE, you could try changing the
NHibernate provider configuration in
Suteki.Common.Repositories.FluentNHibernateConfigurationBuilder from
this:

public Configuration GetConfiguration()
{
return
BuildConfiguration(MsSqlConfiguration.MsSql2005.ConnectionString(c =>
c.FromConnectionStringWithKey(conectionStringKey)));
}

To this:

public Configuration GetConfiguration()
{
MsSqlCeConfiguration.Standard
return
BuildConfiguration(MsSqlCeConfiguration.Standard.ConnectionString(c
=>
c.FromConnectionStringWithKey(conectionStringKey)));
}

However, Suteki Shop works fine with SQL Server Express, I ran it for
a long time against this database. It's a free download from
Microsoft, so that might be worth a try.

I don't know why it's affecting your orchard CMS websites?

Sorry not to be much help.

Mike

[Andi]

Appologies this must not be the Create script from Suteki then as I'm
connecting using Sql 2008. Will have to see what else has changed
recently!

Feel free to delete this whole thread as it implies there is a problem
and I don't want it putting people off when it is not a Suteki
problem!

[Mike Hadlow]

No worries, I won't delete the thread because it's forced to explain
the way the database creation works, which is always a good thing :)

Mike