Hi Marta,
There's no ODBC driver for SQL Server CE. You must use OLEDB, meaning the
ADODB and ADOX classes .
The CursorAdapter class in VFP is made for this.
Here's how you can create a connection in code.

LOCAL lcLocalConnectionstring AS String PRETEXT 8
TEXT TO lcLocalConnectionstring NOSHOW
Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;
Data Source=C:\projekt\SSCE\database\Test.sdf;
Mode=ReadWrite|Share Deny None;
SSCE:Max Buffer Size=640;
SSCE:Database Password='';
SSCE:Encrypt Database=False;
SSCE:Default Lock Escalation=100;
SSCE:Temp File Directory="";
SSCE:Default Lock Timeout=5000;
SSCE:AutoShrink Threshold=60;
SSCE:Flush Interval=10;
SSCE:Test Callback Pointer=0;
SSCE:Max Database Size=512;
SSCE:Temp File Max Size=128
ENDTEXT

LOCAL osqlce as adodb.connection
osqlce=CREATEOBJECT('ADODB.Connection')
osqlce.ConnectionString=lcLocalconnectionstring
lnConn=osqlce.Open()

Marta,

There is no ODBC driver for SqlCE. There is  a OLEDB provider. Not sure if
you can use that with VF however.

This is how a connectinostring could look like:

Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data
Source=D:\_uitwisseling\handhaving.sdf;Mode=ReadWrite|Share Deny
None;SSCE:Max Buffer Size=640;SSCE:Database Password=xyzzyx;SSCE:Encrypt
Database=False;SSCE:Default Lock Escalation=100;SSCE:Temp File
Directory="";SSCE:Default Lock Timeout=2000;SSCE:AutoShrink
Threshold=60;SSCE:Flush Interval=10;SSCE:Test Callback Pointer=0;SSCE:Max
Database Size=128;SSCE:Temp File Max Size=128

hth

Erik Visser

From other replies it seems like there is no ODBC driver which is a pity
since I have an Access App which has linked tables to a SQL server back end
and I would like to be able link those tables to a SQL CE database as well
but with the apparent lack of an ODBC driver this is not possible
- Does anyone know any different?