.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Which Version of Compact Edition doesn't need any additional installation on user machines

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
I have a winforms as well as wpf application (not asp.net).. I want to use a local database to store some extra information locally on user Which Version of Compact Edition doesn't need any additional installation on user machines ? i.e. user will only install .net framework and it can work.. Just like Access..  IMP : There might be a delay in posting replies due to time difference (GMT +2:00) and Friday's Holiday instead of Sunday.

View Complete Post

More Related Resource Links

Query sql server compact Edition version



I want to know what is the query for sql server compact Edition version..Any help will be apreciated


Query sql server compact Edition version



I want to know what is the query for sql server compact Edition version..Any help will be apreciated


How to add a user DSN for SQL Server Compact Edition Database File (filename.sdf)

I'm very new to database operations, so bear with me.
I have a SQL Server Compact Edition Database File (filename.sdf).
I can connect to this database file (filename.sdf) using MS SQL Server 2008 with server type set to SQL Server Compact Edition. I can select data and do queries.
But in order to connect to the database file from National Instruments LabWindows CVI, I have to create a User DSN under my ODBC Data Source Administrator.
None of the samples represents a *.sdf file.
I clicked on Add and get a window called Create New Data Source.
I am asked to Select a driver for which you want to set up a data source.
I tried the SQL Server option, but that did not seem to work.
The database connectivity test always fails.
Is there a better driver with which to communicate with a sdf file?

ODBC Driver for SQL Server Compact Edition

I know that there is no ODBC driver available for SQL Server Compact Edition version 3.5.  Do you plan to add an ODBC driver in future release? If yes, is it high in your priority list?   The scenario why I am looking for an ODBC driver is to connect an MS Access application to a SDF file instead of MDB file.  This will enable me to easily sync the SDF file with SQL server repository using the new Data Sync Services.   Mario Cardinal MVP Solutions Architect

SQL Server to SQL Server Compact Edition Database Copy

I recently switched from XP to Win 7 and am getting an error when using the SQL Server to SQL Server Compact Edition Database Copy wizard from johnnycantcode.com (link). I suspect that the problem is with the configuration of the path for the DQL CE dll. 1) Does anyone know where the configuration is set? It isn't in the GLT.SqlCopy.exe.config file in the local directory. 2) Has anyone got the program to run under Win 7? Thanks marc  

Why does MVC2 reset my Context.User but MVC1 doesn't?

The question comes from a previous thread, but I would like to ask a more specific question from anyone in the know.Why does MVC2 reset my Context.User, discarding changes made in Application_AuthenticateRequest but MVC1 does not?Repro is pretty simple:Start an MVC1 and MVC2 new project. In both of them add the following code in global.asax: protected void Application_AuthenticateRequest(Object sender, EventArgs e) { if (Context.Request.IsAuthenticated) { FormsIdentity ident = (FormsIdentity)Context.User.Identity; Context.User = new System.Security.Principal.GenericPrincipal(ident, new[] { "FooAdmin" }); bool result = User.IsInRole("FooAdmin"); } } // break hereNow in both HomeController.cs files change the Index Action to: public ActionResult Index() { bool result = User.IsInRole("FooAdmin"); ViewData["Message"] = ""; // break here return View(); }Deploy to IIS, attach debugger on the "// break here" lines and then login to each site in turn.You should find that under MVC1 the result variable at both breakpoints is true, but in MVC2 it is false in the Index action.Anybody have any idea why? Is this a bug or by design? Any way around it?

user permission in granula level in SharePoint version 2

Hi, everyone:   I am administrator of a SharePoint v2 site. I found that I can either give "view item" or "view item, insert item, remove item and update item" permission to users, no middle. However, I do wish to give some users "view, edit" permission, but no "insert and remove item" permission.   So, does SharePoint v2 support this in out of box feature? if yes, how to make it, if no how can we achieve in easiest way?   Thank u MySTfrom Finland :D

New SP 2010 Installation - Can't Get User Profiles / Outlook / My Site stuff working.

Hello,   I have a new SP 2010 Installation. I did NOT set it up in Standalone mode. My users can log in and create their own My Sites. They can edit them, add content, etc. When using Outlook 2010, they add one another in the People Pane. It shows up under My Site > My colleagues that they are connected. However, in Outlook, the MySite icon in the People Pane has a red X on it. I thought that User Profile Sync Service might be the culprit after reading through various blogs. However, if I go to Central Administration > Manage Profile Service : User Profile Service Application... if I click Configure Synchronization Connections, the page comes up - "The query returns nothing." I try to click "Create New Connection"... I get an error message - Cannot navigate to the requested page while User Profile Synchronization is running. Please wait for the current Synchronization to finish.   OK - I thought that the query returned no results. I don't see the service running... can someone point me in the right direction?

sql server doesn't support version

The database DATABASE.MDF cannot be opened because it is version 655. This server supports version 611 and earlier.  A downgrade path is not supported.Could not open new database 'DATABASE.MDF'. CREATE DATABASE is aborted. 

Cannot select 'SQL Server Compact Edition' from Server Type drop down

I have seen this issue addressed for SQL Server 2005 but not 2008. I have installed these components:SQL Server 2008 (Browser, Management Objects, Native Client, Policies and Setup Support Files)SQL Server Compact 3.5 (for Devies, Server Tools and SP1)In the SQL Server Management Studio, on the Connect to Server dialog, the "Server Type" drop down list is disabled and "Database engine" is the default. Does anyone know what I need to do to make "SQL Server Compact Edition" a choice in the "Server Type" drop down list?

Microsoft.NET version 3.0 Install Error: Installation failed for Windows Communication Foundation. M

Please help! I've been trying for the last day and a half to properly install Microsoft.NET version 3.5 so that I can install TurboTax and do my taxes. I was only on version 1.1. Multiple tries to upgrade to 3.5 was giving me a code 1603 error on install on "Microsoft.NET version 2.0a". I followed advice from forums here and elsewhere to uninstall and reinstall my prior versions. I also used Windows Install Cleanup before reinstalling. I keep getting to the same result when I try to go from version 2.0 to version 3.5. In my last attempt, I went all the way back to version 1.0 and installed each step up to 2.0 SP1 with (allegedly) no problems. This last time I decided to upgrade to 3.0 instead of going right to 3.5. Now I get the following error message: [04/03/10,04:07:14] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603[04/03/10,04:07:22] WapUI: [2] DepCheck indicates Windows Communication Foundation is not installed.[04/03/10,04:07:22] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0 was not attempted to be installed.[04/03/10,04:17:49] Windows Communication Foundation: [2] Error: Installation failed for component Windows Communication Foundation. MSI returned error code 1603[04/03/10,04:17:57] WapUI: [2] DepCheck indicates Windows Communication Foundati

SQL Server Compact Edition ORM

Hi!I need an ORM library for SQL CE 3.5 SP1. Are there any solutions available?Regards,Dawid Ireno

Introducing SQL Server Compact Edition 4

Hi, I just downloaded the above but when I look in visual web developer 2010 express I see no data provider reference . I was wondering how to attach/create db? in the above, is it a clickable option in tools .net framework options or is VS 2010 not ready to use SQL CE 4 yet, Any help/suggestions/your time in anwering this question greatly appreciated    

Sharepoint 2010 Installation for 2 different developing machines and Server Please Help!

Hi All I am new to Sharepoint 2010. I need to do the following but I am not sure how to proceed. I have a server in the office and I have my laptop which I use to develop at home(offline) and at the office with. I am not sure how to configure my office server and my laptop.  I must be able to work on projects and then sync the project to the server at the office. There is also another developer which will require the same setup. I also need to know should I use Sharepoint Server or Foundation. I understands the differences between the two. I have read up as much as I can but it is all a bit confusing. Can anybody please point me in the right direction?  

Can a row on a "SQL Server Compact Edition 3.5" have more than 8000B in size ?

Hello, I am trying to use SQL Server Compact Edition 3.5 for a desktop PC application. I need to have a table with 5 columns. One of this columns will contain a data that can grow up to 1MB in size. I have read in wikipedia specifications that the maximum row size, this engine is capable to handle, is of 8000B. However, when designing the table, I can choose "image" type. So, can a row on that table have more than 8000B in size? Is there a maximmum limit ? Cheers Valentin

SQL server 2008 compact editioin + Entity Framework: Can we backup the SQL server compact edition da

our application uses the SQL server 2008 compact edition and entity framework. The application will control the instrument. It may run for several days before it stops. In order to protect the database crash (database failure), we plan to backup SQL compact database during running. Can we backup or duplicate the ~.sdf when application is running? Is there any SQL server command we can call inside the application to achive the backup? Or we only can backup the database when application is not running. thx!  

User Control that had been taken from external web control library (dll) doesn't see it's javascri

 Hello, I've created the .dll assembly with custom web controls and use it successfuly, but my last control needs a javascript. It is also in the same .dll with the control. The problem: My project doesn't see the javascrip in the externlal assembly. The question: How to tune the visibility of javascripts in the external assembly? Thank you. Serge.    
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend