Thursday, March 22, 2012

deployment of sqlserverce.dll

I registered to redistribute the runtime for SQL Server Compact edition.

I have a desktop application which uses SDF files as the database.

In VS 2008 - when I set System.Data.SqlServerCe configured to Copy Local as TRUE - sqlserverce.dll does not get inserted to my bin directory. I am assuming if I manually put the DLL file into my bin directory (and deploy it) - the DLL file will automatically be used by my app?

If you install the 3.5 redistributable/runtime with your app, you do not need any SQL Compact DLLs in your bin folder.

http://www.microsoft.com/downloads/details.aspx?FamilyID=4dd09a86-03eb-40a1-bd32-0fd8bcdf7be0&displaylang=en

|||

This defeats the purpose of packaging up the database with your deployment package. I am not the original poster of this thread but I will need a solution that does not need/want to install the Compact Edition Runtime installation with my application deployment. The installation of the runtime package requires the user to have admin rights and most of my end users will not have admin rights.

Therefore, please provide us with the steps to include the Sql Server CE provider assemblies with our application deployment package.

Thank you.

|||Maybe tutorial 1 here will be able to assist you: http://msdn2.microsoft.com/en-us/sql/bb219480.aspxsql

No comments:

Post a Comment