• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1049
  • Last Modified:

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
0
NORTEKAS
Asked:
NORTEKAS
  • 2
1 Solution
 
Mikal613Commented:
0
 
NORTEKASAuthor Commented:
Well this is exactly the types of articles that
0
 
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
0
 
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now