SQL on windows ce device

I have device running windows ce (using platformbuilider 5.0). It is responsible for collecting data from an instrument. What we would like to do now is to have some sort of database on this. In the platformbuilder I can select SQL Server CE 2.0 but when I browse around the not for how to use this I get a bit confused. Thus I have a few questions ( I am for now looking for an overview and not necessarily a lot of tech:
* how do I configure the server?
* how do I configure access to the server?
* what is the difference between SQL Server CE 2.0 and SQL Server 2000 CE?
* will it be possible to access the database with ODBC?
* are there other alternatives that er better (XML database, other SQL server)?

Best regards

Jardar
NORTEKASAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mikal613Commented:
NORTEKASAuthor Commented:
Well this is exactly the types of articles that
NORTEKASAuthor Commented:
Well this is exactly the types of articles that I have seen, but does not give me a very good understanding of the questions that I asked.

Jardar
Didier VallySystems Engineer and Finance AnalystCommented:
* how do I configure the server?
You have nothing to configure. Just install the CAB for Sql Server CE and the database on the Windows CE device will be ready to be used. Be sure of the CAB installation file that you install on the device (if this is a bad one, then your application will quickly freeze).

* how do I configure access to the server?
You use a connection string that contains the .SDF file that is on your Windows CE device. Again, nothing to configure, but some lines of code to write (in C# for you, I think).

* what is the difference between SQL Server CE 2.0 and SQL Server 2000 CE?
Hehe.. Sql Server CE 2000 = Sql Server CE 2.0 !!! It is the same embedded rdbms! The upgraded version is SQL Server 2005 Mobile Edition. The same C# code used to target a 2.0 db will also be usable to target a 2005 Mobile Edition version...

* will it be possible to access the database with ODBC?
No. You use a connection string. No ODBC on Windows CE. You can use ADOCE or ADO.NET.

* are there other alternatives that er better (XML database, other SQL server)?
XML database : Yes, you can use XML as en embedded db, but keep an eye on the amount of data that is needed for XML (in GPRS it can cost much).
Also an alternative : Oracle Lite in a standalone installation on the Windows CE device.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Smartphone Programming

From novice to tech pro — start learning today.