.Net CF 2.0 compatible with SQL CE 2.0 ????

[BenRu]

Need help,,

I can use .NetCF1.1 applcaiton to access SQL CE2.0.

But now. I upgarde my Windows CE device to .Net CF 2.0.
Everything is fine except SQLCE 2.0 AP.

I did some tests.

Even the CreateDatabase is not workable.

--------------------------- my testing code ----------

System.Data.SqlServerCE.SqlEngine sse = new SqlEngine();
sse.LocalConectionString = "Data Source=test.sdf";
<------------------ Exception here??
sse.CreateDatabase();

 

[Darren Shaffer]

a couple of things to be aware of Ben:

first, neither CF2.0 nor SQL Mobile (the new version of SQL CE) will run
on Windows CE.NET 4.2 devices. So if your CE device is on 4.2 you will
have to wait for a service pack from Microsoft which is due out in the next
few months to move to CF2 on this device.

second, CF2 is designed to work with SQL Server 2005 Mobile Edition
(aka "SQL Mobile"). since it sounds like you are upgrading from CF1 to CF2,
you can also upgrade your SQL CE database to SQL Mobile using
a small utility that you run on your device (upgrade.exe) that converts
existing SQL CE databases to SQL Mobile.
http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx

For complete information on SQL Mobile, download the SQL Mobile SDK and
Books Online at:
http://www.microsoft.com/downloads/...aa-5813-4db3-b23a-24551de2ecc1&displaylang=en

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com