Is there any way to take a backup of SQL Server 2005 Mobile Database
(.sdf) in a folder of Handheld device.
I tried using BACKUP Database 'database.sdf' TO '\Storage Card\DB',
but it doest work.

I am trying to enter a datetime value from a string value. The string value
that
I convert into a datetime value is "1/1/1912". The year value in
this particular case is "1912". When the app is executed,  I notice that in

I've been converting my mobile application to use TableDirect due to
speed gains.  However, I ran into an issue where I sometimes need to
display the data (using a DataGrid) in reverse order of a given
index.  While I think I already know that it's not possible without

This question relates to another one I posted. However it derives from the
original post and found better to start a new one.
I'm writting a library application that will be used internally within our
company (dB is used in RO mode). I already expect it to be used by

Working with SQLCE Compact Edition.  I can't seem to find anything in the
SQL grammar to limit the result set size from a SELECT statement, like
'SELECT TOP 25 * etc)
What is the best way to do this? (I'm guessing it has to do with using a

A have a C# application who uses a SQL Server Mobile database (on the
storage card) on a ppc 2003 device. A have no problem
I deploy this application on a Windows mobile 2005.
After a few tests, I have the following error code : 80004005.

Hello I have a mobile application on Visual Studio .Net 2005. I need to make
a select count(*) for counting how many records scanned for a specific login
field. The strange thing is the program crashes right when I get the value
of the select and assigng it to a variable. Do you ...

I am using VS 2005 SP1, and by default (when VS is installed) there should
be a directory:
"C:\Program\Microsoft Visual Studio 8\SmartDevices\SDK\SQL
Server\Mobile\v3.0"

anyone knows how to pass a datetime parameter with vb.net 2003 to a sqlCE
2.0 database ?
I've tried in some way but when I tried to create a parameter collection to
speed up a bulk operation with thousands record the pass process fail with a

I'm developing a device application in Visual Studio 2005 and i've installed
SQL Server CE onto my computer.  However when i go to add a connection via
the VS2005 Server explorer, it does not give me an option for SQL Server 2005
CE.  

I have a very strange Problem with my Mobile 2005 database. I need to
change some table layout and for that I copied the *.sdf file to my
desktop pc.
It's size is 284KB, like on the mobile device. When copying back this

I'm currently using the SQL Server Compact Edition 3.1 on my Computer and
I'm facing a speed problem when getting a connection instance back from the
connection Pool. Getting such a connection actually takes ~2 ms.
I'm using the exact same connection string to get the instances ...

I'm developing a multithreading application in C# with Compact
Framework 2.0 and Sql Server 2005 Compact Edition. Sometimes and
randomly, the following exception is thrown :
AccessViolationException in System.Data.SqlServerCe.NativeMethod()...