I can't easily check my code's CRUD in the database since I don't have a table viewing utility for ce3.5. Other than vs2008 is there anything out there to inspect a ce3.5 database?

I'm having some serious issues reading data from a SQL Server 2005 Mobile
database. My environment is the following: VS 2005 w/ SP 1, Windows CE 5.0,
and SQL Server 2005 Mobile.
I have a form with 3 buttons. The OnClick event of each button retrieves

Hi....
    I’ve tried to find Microsoft’s specifications on the storage capacity of
a SQL 2005 CE database. I am interested in storing only tex. (6 GB)  If
anyone knows CE's storage capacity number or you know of some Microsoft’s

I am constantly getting this error unless I copy the dll into my bin directory. What is the best way to avoid this error?
Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

All I want to do is to send a database query to SQL Server CE 2.0 using the
OLE DB interface.  I have already initialized the datasource.  Can someone
post a pointer to some sample code that clearly shows how to setup a session
object and then how to send a simple database query ...

My main application is written in a language called Gupta team developer.
I need to be able to communicate with a sql ce 3.5 database.
However there is some strage things with the OleDB driver.
It is no problem establishing the connection to the database, but when ever

I have merge replication configured between SQL Server 2000 and SQL CE
2.0 which has been working fine for the past few years.  I need to
migrate my Server 2000 database to SQL Server 2005 and set up merge
replication there.  Can I simply point my device to the new database

Every time I try and download the 1.7MB SQL Server Compact 3.5 For Windows
Desktop from the MS download site it gets to about 1.2MB and just hangs.
Could somebody at MS please check the file?
http://www.microsoft.com/downloads/details ...

Newbie Question
I have a scenario where SQL Server CE installations on smart clients
need to synchronize with two separate SQL Server DBs (residing in two
physically separate server machines). One server contains active

I am working with sqlce2.0 and i have this  database in my target
device having wince5.0
i need to take a back up from my device and store in PC.
further i want to transfer the data from one database to another

When trying to use the latest SSCE 3.5 for WinCE 6.0, my databases
created with SS 2005 will not open -- says they were "created by an
earlier version of SQL Server Compact."
So I tried to use the Upgrade.exe however that apparently wants the

Does anyone know if and how I can access a SQL Server CE 3.0 database using
ODBC? (Is there an ODBC driver available for SQL Server CE?)
If not, what are the methods for accessing a SQL Server CE 3.0 database?
Thanks.

Inside a single transaction I'm inserting/updating multiple records into
multiple tables, like this:
table 1 record 1
table 2 record 1

in a Sql Server Compact Edition 3.5 database I just need to delete all the
records in a table, is there any way faster than execute a DELETE FROM
statement, or more practical than deleting the table and recreate it?
UnfortunatelyTRUNCATE TABLE is not supported...is there another ...