Hello everybody! I have a problem with a length of ntext field - when I create field of that type, it's length property is constant and is equal to 16. When I run my application, and insert a string composed of 499 characters, I get following message: "The data was truncated while converting from one data type to another. [ Name of func...
Hy, I'm new with SQL Compact Edition and I am having problems renaming a column. I know that you can rename a table using sp_rename and this doesn't work with columns. I've searched for an alternative, but didn't find one. Can I delete a column and then add a new one after a specific column? If I delete the column and add it after t...
I have a SQL Server CE database I am developing with and would like to downgrade the version so that 2005 Management Studio will open it. Currently, I have to use VS 2010 to open it, but it is a real pain to use that way. I know I could install the 2008 version of SSMS, but the machine I use has serious problems with all installs. There...
Hi I have two DB1.sdf and DB2.sdf file (sql ce). I want to compare the two. I want to check the no of rows and the space used in each of the database. Is there any way to do that? Also is there any way to to a corresponding table to table comparision in the two databases? ...
So I'm trying to build an installer in Wix 3.5. My app need SQL CE 3.5 to run. It looks like MS's installer has an easy way to include this, but I'm not sure what I need to do in WiX. ...
Hi friends , I have done a web project ( using C# + SQL CE + ASP.NET )where it does few manupulation with .sdf file and results are displaye via ASP.net page . While i started working I hardcoded the path of the connection string and worked in my system . Now I want this database to be residing inside my server page. How do i get t...
Hi there, I have the insert working fine with my sqlce database however I am struggling to update. Can anyone see whats wrong with what I am trying using (SqlCeConnection con = new SqlCeConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString)) { con.Open(); ...
I have VS 2008 SP1 and SQL Compact Compact 3.5 SP 1 installed. I can see "ADO.NET Entity Data Model" when I go to Add -> New Item in Web Application project but same is not shown in Smart Device 2.0 application. How to use Entity Framework (which version) with .NET CF 2.0 application and SQL Compact 3.5 SP 1? ...
hi is there any light tool for open *.sdf files (sqlCE files) thank's in advance ...
hi how to get all tables name's in sqlCE Database ? i have database in sqlCE (sdf file) and i neet to get all name's of the table's how to do it ? thank's in advance ...
Hi there, I have just finished developing a wpf application that uses a sql ce db. I am using installshield2010 express to package up the application. I have created a folder (ProgramData) within installshield and created a directoy for my db e.g. c:\ProgramData\Test\Data\MyDb.sdf however when I run the application I get an error Intern...
Sorry for maybe not so clear title of this question but I'll try to explain it better, so bear with me a little longer :) We have some C# app on a device with Windows Mobile and it uses MSSQL CE database to store its data (no surprise here, I presume). The problem is that any change in db schema (new columns, different type of data in c...
I am using Sync Framework in SL App to sync Sql Server and local SqlCe DB. Having problem in connecting to Sqlce. Getting an Exception here new SqlCeConnection("http://localhost/Sample.sdf"); Error: ArgumentException was unhandled by user code. The connection object is not valid. Cannot create a new instance of the connection object."...