From my vb project I clicked on the following menu selections
Data>Add new Data source>Select Database>New Connection
I am now looking at the "Choose data Source" screen
in the Data source list box  I have no "Sql server Compact edition" option

I am using SQL 2005 sp1 to setup Merge replication for PDA access.
i created my Primary Key column a GUID using NEWID() as the default value.
When the snapshot was created it still went and added anothe GUID to all my
tables called rowguid.

I have followed the M/S instructions for installing SQL compact edition and
the query analyzer on a device
I have copied to the device the following cab files
to install SQL Compact Edition:

I created SDF database files for "SQL compact" with a size larger than 128
MB (which is default for creation). Now when I try to open these files with
VS2005 I get the error "The size of the databasfile exceeds the configured
maximum...Required Max Databse size (in MB; 0 if ...

I'm working on Compact SQL database with sdf files.  I have no problem
doing read/write, share read, read only access to the sdf database
with multiple application by changing my connection string File Mode
and I've tested it to work with multiple application accessing a

I've upgraded to the 3.1 and the more I read the more confused I become.
I've got three current versions of SQL Server CE installed.
I want to use the latest greatest but can't really decide where I should
reference it from.

I get an error (SQL Server 2005 MObile Edition ADO.NET Data
Provider,Native Error 27777) on compacting an sql 2005 mobile
database. The error occurs where I call the Compact method.
If I try to compact the database from Visual Studio 2005 no errors

I am trying to upgrade a very small SS CE DB to SS a Compact Edition DB
using the following command on my pocket PC:
upgrade.exe /s "test.sdf" /d "testbk.sdf"
I use the upgrade tool copied from "C:\Program Files\Microsoft SQL Server

We just migrated an app from .NETCF 1.0 to .NETCF 2.0 and SQL Server 2005
Compact Edition (3.1?) and I'm running into a problem where the nvarchar
parameters aren't truncated based on the size of the field. For example:
Dim cmd As SqlCeCommand = New SqlCeCommand(sSql)

The 3rd argument for this function requires that the program specifies the
number of records to fatch.... BUT this can be in conflict with the SQL
statement that was created eg: Select * from Customers where LastName='Evans'
may return 200 records, but if my call only asked for ...

I wonder what the best solution is to conver SQL CE database to Access
database. Any suggestion of existing tools is greatly appreciated.
Thanks.
GD

Error calling SQL CE from oledb from VB.NET
The following code gives an error:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button2.Click

I had to reset my mobile device (Windows Mobile 2003) with SSCE 3, installed
NETCFv2.ppc.armv4.cab followed by Sql.ppc.wce4.armv4.cab
The NorthWind sample works fine, but from my own program, I used to get the
TEXT of any error message - now I only get the Error Hex number... So I ...

Thank you for the direction on vfpoledb I am able to see the FoxPro data in
my .net app.
Now thatI can read each record from the FoxPro table, I want to insert it
into the Sql server compact edition database,

I am trying to use VB 2005 with a mobile database but as soon as I get
any database driven forms I get this:
System.MissingMethodException was unhandled
 Message="Can't find PInvoke DLL 'sqlceme30.dll'."