C# – SQL CE unspecified error

cnetsql-server-cevisual studiovisual-studio-2005

I did a project with MS SQL Server CE that when installed in the 'costumer' machine just raises an unspecified excpetion.

Did some research and looks like I did everything mentioned. The dev env has sql compact 3.5 installed and sql tools for vs 2005. Using dotNet 3.5. But to make it run in de dev machine I need to add the sqlcese30, sqlceqp30, sqlceme and sqlcecompact30 dlls and its works fine.

The setup project put dotNet 2.0 as dependecy and I also added the dlls but it raises the exception and I cannot see where or what it is. Its just a single 'unspecified error' message.

please help 🙂

Best Answer

Have you tried using the SQL CE re-distributable installer on the customer machine?

You can add SQL CE 3.5 as a pre-requisite to the setup project. If it is not already in the list, copy the SQL Server Compact Edition directory from C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages to C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages and restart Visual Studio 2005.

Related Solutions

C# – The breakpoint will not currently be hit. No symbols have been loaded for this document in a Silverlight application

Right click on solution --> Properties

Look under Common Properties --> Startup Project

Select multiple startup projects

select Start action on the projects you need to debug.

Entity-framework – Using Entity Framework with an SQL Compact Private Installation

I figured out how to do it, thanks to a blog post by Steve Lasker. Basically, here is what you have to do:

(1) Set a reference to System.Data.SqlServerCe.dll in your project. Set the CopyLocal property to True.

(2) In the App.config for your project, add the following XML markup. It tells EntityFramework to look to your private installation of SQL Compact for its data provider:

<system.data>
    <DbProviderFactories>
        <remove invariant="System.Data.SqlServerCe.3.5"/>
        <add name="Microsoft SQL Server Compact Data Provider" invariant="System.Data.SqlServerCe.3.5" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=3.5.1.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
    </DbProviderFactories>
</system.data>

(3) In the Setup project, add the following files to the Application Folder in the File System Editor:

sqlcecompact35.dll
sqlceme35.dll
sqlcese35.dll
System.Data.SqlServerCe.Entity.dll

Best Answer

Related Solutions

C# – The breakpoint will not currently be hit. No symbols have been loaded for this document in a Silverlight application

Entity-framework – Using Entity Framework with an SQL Compact Private Installation

Related Topic