SQLServerCentral / SQL Server 7,2000 / SQL Server CE

0x80040e38 DB_E_CONCURRENCYVIOLATION Error

weirdlNet — Mon, 06 Jul 2009 03:01:59 GMT

Hi All,I got this error when I tried to open one of the table in mysdf. [quote]Error: 0x80040e38 DB_E_CONCURRENCYVIOLATIONNative Error: (0)Description: The rowset was using optimistic concurrency and the value of acolumn has been changed since it was last readInterface defining error: IID_IRowsetParam. 0: 0Param. 1: 0Param. 2: 0Param. 3: Param. 4: Param. 5: [/quote]This is the first time that I encountered this problem. I'm trying to find out what caused this error, and whether I can somehow copy the content of the table into another table.(I know that I can't delete or view the content)What I have found out online so far does not really help.Does anyone know what caused this?Thank you very much in advance :-)

Interesting MS CE bug in a .sqlce file

JKSQL — Wed, 08 Aug 2012 12:17:23 GMT

We have several insert statements to fill this DB that are generated using automated exports from our SQL server for CE to distribute. When this script is executed from code it works because it is executed using a .NET reader. When you run it manually from SSMS it does not work. It seems to be a bug in SSMS for compact. The bug is not in the insert statement. It is in the comment.This type of comment works--****************************************************************************************************************************************************--New StuffWhat does not work is: --****************************************************************************************************************************************************--New Stuff ' sThe tick makes it act goofy in SSMS. All the insert statement are passed up below that statement. Seems crazy but when you take that tick out it worked.Anyone know why?

Computed Column for SQL CE 3.5

shirishbhosle — Fri, 11 May 2012 05:34:01 GMT

Hello All,Is there option of computed column for the SQL CE 3.5 edition.I doing the project on Student Management for the Institute.Where I created table in sql ce 3.5 using vb.net2008 now I want to get trigger effect withoutusing triggers on my tables so we need the computed column option in SQL CE 3.5Is it possible and how please help me! thanks in advancePrime™

Split integer valuefrom decimal valye

indraprakash — Mon, 07 Jul 2008 05:45:10 GMT

Hi All,I want to split integer part from decimal value e.g. i have a no is 12456324.254 and i want to the output is 12456324Note: We can't use convert function

Alphanumerical sorting for SQL Server CE

jtpa — Thu, 04 Aug 2011 05:47:53 GMT

Hi Does anyone know how to make aplhanumerical sorting for SQL Server CE ? CE does not support Isnumeric-function, so it cannot be used. CE version has to be 3.5 because VB 2010 does not support CE 4.0. jtpa

Want to display dynamic number of tables in output?

dragonpms — Fri, 01 Apr 2011 07:42:43 GMT

Want to display dynamic number of tables in output?for exemple:input parameter @company_id = 2103@instance_id '1,2,3,4,5,6,7'i want output table for each instance ID.so is it possibile in SQL,if its k please help me out............

Does SQL CE support Computed Columns ?

akhandels — Thu, 30 Dec 2010 09:02:42 GMT

Hi All,I am trying to add a computed column in SQL CE table. SQL Query for the same change in SQL Server 2008 is like this:ALTER TABLE table_nameADD [hash_c2] AS (CONVERT([binary (20),hashbytes('sha1',TEST_CONDITION),0))Is there a way to add a computed column like this in SQL CE?Thank You.

Need help on query

miss.delinda — Tue, 20 Jul 2010 12:57:28 GMT

In SQL Server below statement work fine,select * from t1 where maintdte != (select MAX(maintdte) from t1)How select * from t1 where maintdte != (select MAX(maintdte) from t1) looks like in SQLCE?I'm stuck

When appropriate to use CASE statement

jaclyn.c.may — Wed, 14 Jul 2010 07:32:23 GMT

I am trying to create a statement that tells me if there is a payment pending record yesterday, but today there is not due to a cancelled payment. I figured out the codes - disregard positng

SQL SERVER CE COLUMN INVALID ERROR

mugahjoseph — Mon, 17 May 2010 12:07:45 GMT

Hi all,I am writing a code in Visual studio 2005.Database is SQL server CE.I created a table, saved it, and used it for some times before realising that I need more columns.I added new columns, but when i try to insert to these new columns, it returns an error indicating that the columns are invalid.So, I decided to create a new table altogether with all the columns, and when I run an insert query into the table, it returns an error indicating that the table does not exist.I have checked the spelling of the columns and the table, and the names are alright.What could be the problem and how do i fix it?Thanks

Please help with install ( screwed up )

ericvanderhousen — Tue, 20 Oct 2009 04:43:27 GMT

hi,Please help. I have Vista,Visual Studio 2008, SQL Server 2005. And various SPs. Installation screwed up. In Visual Studio 2008, if I go to:data -> add new data source -> database -> new connection I can't see the Microsoft SQL Server CE option?regards

Sql Compact 3.5

jankhana — Tue, 20 Oct 2009 23:20:48 GMT

Hi all, Is there any way by which we can find programmatically whether SQL Compact is installed or not... Actually I need to know whether the compact edition is installed or not in PC and so that I can include or exclude the SQL Compact dll... Because in my application there are different process that access the same .sdf file which will cause Access Violation error if those dll are included and compact is installed...Any idea!!!

sqlce in xenocode

jankhana — Mon, 05 Oct 2009 03:21:50 GMT

Hi all, I'm using Xenocode in my application so that it works without a .NET framework. I'm using Xenocode Virtual Application Studio(version 6.1). Everything works fine except the .sdf file which I have embedded inside the application directory. actually in the application the instead of SQL server i have used SQL Compact edition(3.5) and i have included the reqired dll . All the files are working except the ".sdf" file.Any idea y is that so?????? Is it because the ".sdf" file is being used when the xenocode after snapshot was taken???????? if so what is the solution for that?????? i cannot avoid using it because Xenocode's after snapshot will not recognise the application if it's not running and if I run the application ".sdf" file will be used. Anyway to solve this??????????

SQL Server Compact timed out waiting for a lock

jankhana — Thu, 17 Sep 2009 03:31:22 GMT

Hi all, I'm having an application in that i use Sql Compact 3.5 with VS2008. I'm running multiple threads in my application which contacts the compact database and accesses the row. It selects and deletes those rows in a fashion i.e selecting and giving to the application 5 rows and deleting those rows from the table. It works great with a single thread but if i use multiple threads i.e if 3 or more threads are running I get very often the TimeOut Error!!! I have increased the Time out property in the connection string but it didn't give me expected result. The error log is as follow:"[b]SQL Server Compact timed out waiting for a lock. The default lock time is 2000ms for devices and 5000ms for desktops. The default lock timeout can be increased in the connection string using the ssce: default lock timeout property. [ Session id = 5,Thread id = 4204,Process id = 4808,Table name = XXX,Conflict type = x lock (s blocks),Resource = TAB ][/b]"The Query that I use to retrieve is as follows:" select Top(5) * from TableName order by id; delete from TableName where id in(select top(5) id from TableName order by id); "Is there any way by which we can avoid this Time Out exception???????The above query I run as a transaction in VS2008 one using SQLCECommand and the other using SqlCEDataAdapter.Any Idea!!!!!! Reply

sql ce 2.0 hotfix

frank.rieger02 — Mon, 03 Dec 2007 01:07:47 GMT

I have read about a memory problem with the sql server ce 2.0 on http://support.microsoft.com/?scid=kb%3Ben-us%3B827837&x=16&y=12 and a fixed ssce20.dll file.Does anybody have this updated version of the file and could perhaps send it to me?

Size and Wrap Round database

amber.hassan-bhatti — Mon, 14 Sep 2009 06:14:24 GMT

Please can anyone define how to define the maximum size in MBytes for a SDF file from the client side?Also is there a way by example that whenthe maximum size is reached that the datbase wrps round to re-add from the oldest record. Something like a circular list?Example code in C# would be very useful :-)

New Commands in SQL CE 3.5 SP1 ?

jrlvid-657235 — Sun, 02 Nov 2008 16:41:07 GMT

Hi, I am trying to port over from SQL Server 2005 Express to > [b]SQL Server CE 3.5 SP1 [/b](sql 2008 Commands mabee?):w00t: Want to use a query internal to Visual Studio 2008's Query Builder... Here is How the code looks in the Query Window of VS 2008 VB... Do NOT wan't to use Linq...!:hehe:SELECT [Record Number], Date, Car, Miles_Start, Miles_Stop, Gallons_FillUp, Miles_Stop - Miles_Start AS Miles_Total, (Miles_Stop - Miles_Start) / Gallons_FillUp AS MPGFROM Sheet1_TableORDER BY Car, Date DESC It processes fine but does not work: Just Want to Preform Basic math on the Data Table. Add, Subtract, Devide and Multiply. In the "Advanced Options" of Query Builder the " Refresh The Data Table" Is greyed out... :w00t: Any Ideas where I can get a good command reference or PDF Book on SQL Server Compact Edition 3.5 sp1 ? ;) Any and all help would be appreciated!

How to register a DLL (SQl Server Mobile 2005) in Windows CE 5.0

xavendano — Tue, 21 Oct 2008 08:38:12 GMT

How to register a DLL in Windows CE 5.0 .... I understand that you must use the application regsvrce ... Q1: Where do I find this file as in the handheld device does not have it? Q2: What is the real name of the file?

Sql server Ce connection.

Neeta Patil — Mon, 09 Jul 2007 07:51:00 GMT

Can anyone please help me ... its urgent....

I am working with PDA application but not able to connect to .sdf file. I am using following connection string

SqlCeConnection con = new SqlCeConnection("Data Source =.\\TestDB.sdf; Password =testdb;");

but it is giving me error like: --

The database file cannot be found. Check the path to the database. [ File name = .\TestDB.sdf ]

Please tell me where I am going wrong.

Thanks in advance.

SQL CE Replication errors on handhelds

s.solanaki — Mon, 23 Feb 2009 02:53:06 GMT

Hello, I am working for a company that owns a mobile application that requires synchronization. We have about 100 clients that work flowless for a long time now and we use a standard installation for most of them. On a specific client we have issues with their databases getting corrupted. It is occuring on all of their pilots about once per 10-15 days. The only way we have found to solve this is to delete the local database on the device and synchronize it from the start. This is an easy procedure for us but for our client is something that is too hard to explain and takes a lot of their time. We need to find the reason this is happening. The messages are always empty with error code 80040E19 and minor err. 28574. I don't know what other feedback to give you to help but let me know if the information given are not enough. I would love to hear from you soon.Best regards S.

Access Denied of the SDF in mode ReadOnly

leonardosalvatore — Thu, 05 Feb 2009 09:34:28 GMT

Hi,i'm planning to use SqlServerCe that read SDF file from DVD rom.To do that, I started with that connection string:[code] String.Format("Data Source = Database1.sdf;Mode = Read Only;Temp Path={0} ;Persist Security Info=False;","c:\\ASpecialFolder");[/code]This application, open, read and close the database.If i run the application on the DEV machine (vista 32, vs2008 sp1,sqlserverce sdk) all run well, from CDROM,DVD,or a local disk folder.Instead from others machine (2003,xp or vista) nothing .. error with this excetpion (inner was null)...[b]Message: Permission denied.Source: SQL Server Compact ADO.NET Data ProviderStackTrace: at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent) at System.Data.SqlServerCe.SqlCeConnection.Open() at ConsoleApplication2.testservice.GetDBInfo() in C:\X\Test\ConsoleApplication2\ConsoleApplication2\testservice.cs:line 46 at ConsoleApplication2.Program.Main(String[] args) in C:\X\Test\ConsoleApplication2\ConsoleApplication2\Program.cs:line 19[/b]

How to use SQl statement in SQL CE

k.subodh1 — Sun, 15 Jun 2008 23:38:15 GMT

Hi I am using SQL sever CE 3.1. I have created database and some table in this.after making connection iI have to nsert data into table .and i want to display table data into my Listview as a userinterface I have to use INSERT INTO ITEM VALUES( )ANDSELECT * FROM ITEM. but i dont know where to use this statement I am using vc++ and OLE DBI am also taking help from northwind sample. thanx

Is there any option like IF EXISTS(SQL Query) in SQL CE

Sreejith P S — Wed, 17 Dec 2008 11:09:21 GMT

Hi All,Is there any way to find out data exists in a particular table.Regards,Sreejith P S ;)

Native Error 29006, The process could not deliver the snapshot to the Subscriber

Rod Early — Tue, 10 Jan 2006 13:58:00 GMT

I have a CF.NET application (C#) with a SqlCE database. We had originally planned to use SQL Authentication to replicate with the publication and indeed had SQL Authentication working flawlessly. Then our client asked us to use Windows Authentication instead.

For incremental changes, Windows authentication works fine. When trying to do the initial synchronization where the application receives the snapshot database from the publishing database, there is trouble. I have tested this in the PPC 2002 and 2003 emulators and on an actually PPC device as well. I get the following error:

A call to SQL Server Reconciler failed. [,,,,,], Source=Microsoft SQL Server 2000 Windows CE Edition, NativeError=29006,HResult=-2147467259

The process could not deliver the snapshot to the Subscriber., Source=Merge Replication Provider, NativeError=0,HResult=-2147201001

Here is difference in my code between Windows and SQL Authentication: #if SQLAUTHENTICATION repl.PublisherLogin = "MyLogin"; // publisher Login; repl.PublisherPassword = "MyPassword"; // publisher Password;

repl.PublisherSecurityMode = System.Data.SqlServerCe.SecurityType.DBAuthentication; #else repl.PublisherSecurityMode = System.Data.SqlServerCe.SecurityType.NTAuthentication; #endif

As far as I know, I have properly configured the snapshot IIS folder with the correct permissions for IIS_MachineName (for anonymous-Sql Authentication) and also with the domain users for Windows Authentication. The domain users are also in the Publication Access List.

The bottom line is that in for Windows Authentication I am not able to receive the snapshot from the publishing database on the first synchronization. However, I am able to do incremental synchronization through Windows Authentication. And I have no problems with SQL Authenication (via the anonymous user).

I am stumped by the "process could not deliver the snapshot to the Subscriber" error. Have any of you encountered this situation before, and if so, how did you resolve it?

Thanks, Rod Early

Error 28532 : A read operation from the transport returned no data.

Cheryl Hanlon — Mon, 10 Nov 2008 10:13:41 GMT

Hi, I am using sql server 2005 and ce framework 3.5 and attempting to use merge replication between my hand held and my sql server. I am getting the following error:Error 28532 : A read operation from the transport returned no data. The version of SQL Server Compact 3.5 Client Agent and SQL Server Compact 3.5 Server Agent should match.I am finding little to no information on the net. Can anyone tell me either how to check the versions of Server Compact 3.5 Client Agent and SQL Server Compact 3.5 Server Agent or any steps i can take to resolve the issue ?Thanks LoadsCheryl

RDA connection

Raghu.Rao — Sat, 11 Oct 2008 23:16:18 GMT

i have taken a SQLserver 2005 space in Databasemart.com and they have give me IPaddress. i tried accessing from vb program and it works fine.i want to display records from it on a mobile deveice.can any one help me

Windows mobile application error: A SQL Mobile DLL could not be loaded.

Deon Engelbrecht-301640 — Mon, 13 Feb 2006 08:02:00 GMT

HiI have a windows mobile application that uses SQL replication. I have upgraded the application from .net 2003 to .net 2005.I am using 2 types of devices i-mate K-JAM and i-mate JASJAR.My problem is when replicating to the server I get the following error (see below) on the JASJAR but NOT on the K-JAM.

When I debug the code the error occurs on:

à SqlCeReplication repl = new SqlCeReplication(); Error Message:Message "A SQL Mobile DLL could not be loaded. Reinstall SQL Mobile. [ DLL Name = sqlceca30.dll ]"Thanks for the help!Deon

about merge replication using visual studio 2005 and sql server

lavanyaamca — Wed, 24 Sep 2008 12:04:27 GMT

First up all replication is to copy the datas from one database to another database(replicating).To do Replication First create Publisher and Subscriber.Publisher : from which database we are going to copy the data.Subscriber: the database database to which the datas want to be updated.Needed Softwares: visual studio 2005 Active syn (to make connection between pocket pc and to our system) sql server 3.1Mobile Edition with server tools.(this want to be first installed in our system and then the CAB file will be automatically created . then through using active sync open the file explore of Pocket pc and paste the CAB file.then In pocket pc select the file explore and in that select the CAB file setup and install the sql server mobile Edition. Steps: by manually create Publisher and subscriper in the database and give appropriate name for that and in application on Click of synchronize button write the coding.

query for getting yesterday date entry

k.subodh1 — Fri, 11 Jul 2008 01:13:13 GMT

Hi I am developing application using windows mobile 6 with vc++ and SQL CE 3.1 I have used query for getting yesterday date entry ..I am doing minus 1 from system date and getting result. but the problem is that when the system date is 1st day of month or year.this query is not working. so is there any other logichope for reply. thanxsubodh

How do I test the existance of a open connection to a SQl CE 3.0 database

Harry Drenth — Fri, 20 Jun 2008 07:52:34 GMT

SQL CE 3.0 can handle only one open connection.I working on a device with 2 applications running on the same database (user app and separate synchronization process on the background).When the synchronization app has the database open the second app crashes when it tries to open the database.Does anyone know a proper way how to check whether an other application has already a connection open to the database.We are developing on VB.Net compact framework 2.0Regards,HD.

How to start with SQL CE

k.subodh1 — Wed, 11 Jun 2008 00:41:20 GMT

Hi,I am developing a windows mobile 6 using Vc++ ,WIN32 on my desktop.I have to use SQL CE database. I have insttaled sql ce 3.1 in my system ..can anybody guid me how to create ,populate and connect this database with my application .. I got one sample northwinde with this installation but it is not running.so hoping for reply thanxsubodh kumar

Sharing Violation ofsdf file in PocketPC

lakshmi.krishraj — Wed, 04 Jun 2008 01:08:49 GMT

Hi,I’m working on an application written in C# in Compact Framework 2.0 for a Pocket PC. It is required that the application connects to the SQL CE database frequently. The sdf file is present in the PocketPC. Now I’m facing a problem now and then when the code tries to connect with the sdf file. The code works fine for some time and then it suddenly starts throwing "There is a file sharing violation. A different process might be using the file."I am disposing and closing the connection after each operation.Please find the function code below which is being used for any database operation. SqlCeConnection sqlCon = null; try { sqlCon = ConnectionFactory.getInstance().getPrimDsConnection(); sqlCon.Open(); readCmd = sqlCon.CreateCommand(); this.prepareStmtManyRows(); dataReader = this.readCmd.ExecuteReader(); IList result = this.populateManyRows(); return result; } catch (SqlCeException sqlEx) { StringBuilder builder = new StringBuilder( @"SqlCe Error in BaseReader.executeList() - ").Append( sqlEx.Message).Append(':').Append(sqlEx.NativeError); Log.getInstance().log(builder.ToString()); throw new DataAccessException(sqlEx); } finally { try { if( null != dataReader && ( !dataReader.IsClosed )) { dataReader.Close(); dataReader.Dispose(); } if( null != readCmd) readCmd.Dispose(); if( null != sqlCon) sqlCon.Close(); } catch (System.Exception ex) { } }I have also made sure that Query Analyzer is not running on my PDA.Any help will be appreciated. Many Thanks,

how to handle controls

k.subodh1 — Fri, 30 May 2008 07:21:08 GMT

Hi I am developing windows mobile 6 application using vc++ 2005 on my desktop. I am using some control over there like EDIT control, LIST VIEW control, COMBO box, button etc I have to do it that whenever i will click on add button whatever written in edit control and combo box will go n list view control according to coloum provided in list view. I have searche on net for handling of controls but couldn't found. so plz send me some link for handlind concept Thanxsubodh kumar

selecting data from tables in sql ce

Lillian Bose — Tue, 10 Apr 2007 07:28:00 GMT

Dear All,

I'm working with sql ce 2.0

i was able to create DB and tables and was also able to insert rows into the table. Now im trying to retrieve data from the tables.i searched for some sample programs on retrieving the data with a select query and was not able to find

It would be useful for me if i get any guidance

Regards

Bose

Not getting the location of created database file

k.subodh1 — Wed, 28 May 2008 04:57:18 GMT

Hi I am developing a windows mobile 6.0 application using SQL server compact edition v3.1 using vc++ 2005. I am developing it on desktop using emulator. I have created database file "xyz.sdf". but i am not able to fine this database file on my disk. I have read on net that it will not store store on disk. so how i will retrive data dat from the file. if database file not exit then how i will deploy it on device.I am trying it from last week. so i need helpthanx subodh

Passing string to SetCommandText

Lillian Bose — Thu, 29 Mar 2007 08:34:00 GMT

Hi all,

Im using SQL CE 2.0, created the database and table succesasfully. I tried to insert the records using SetCommandText and Execute Commands

pICmdText->SetCommandText(DBGUID_SQL, (LPWSTR)(L"INSERT INTO Employees VALUES (10, 'Bose')")); pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);

This works fine then i tried some dynamic method

pICmdText->SetCommandText(DBGUID_SQL, (LPWSTR)(insertionquery)); pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL); where i framed the insertionquery dynamically like "INSERT INTO Employees VALUES (11, 'Hussain')" and inserted but the function fails

how could i achieve this kindly help me in this regard

Thanks in Advance,

Bose.

Remote Data Access

nandhakumar.p — Thu, 28 Feb 2008 00:17:57 GMT

Hi Friends, when our application switches between DB and RDA(Remote Data Access) connections. We close the DB connection and create the RDA object and then execute the pull statement.Once the PULL statement is executed we close the RDA connection and open the DB connection. This is working fine but sometimes, in the RDA connection when we execute the PULL statement sql quries, it is not returning any message or error number.It simply hangs. wwhat could be the reason?Kindly clarify our doubts.Thanks in Advance.Regards,Nandha

Memory Leaks SQL CE 3.0

projas — Wed, 09 Jan 2008 14:41:03 GMT

Hi,I am working with SQLCE3.0 and when I use a lot of times an SQLCEDataAdapter.Fill() my application has the exception "Not enough storage is available to complete this operation...". I am sure I dispose all the objects, the SqlCeCommand, SqlCeDataAdapter etc..Does anybody know what should I do to fix this?Please I am desperate!!!! I have six months with this problem.Thanks

SQLCE and WINCE device symbol mc3090

edgar morales — Tue, 04 Dec 2007 12:58:30 GMT

Where i cant to get some code this projectDo i need through SQLCE to get directly to a SQL SERVER 2000 DatabaseI need to go from a WINCE device (Symbol 3090 using WLAN)

SQLCEconnection Error

Nickiii — Mon, 16 Jul 2007 04:00:00 GMT

:-)