We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

SQL on windows ce device

NORTEKAS
NORTEKAS asked
on
Medium Priority
1,075 Views
Last Modified: 2013-12-27
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
Comment
Watch Question

CERTIFIED EXPERT

Commented:

Author

Commented:
Well this is exactly the types of articles that

Author

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
Systems Engineer and Finance Analyst
CERTIFIED EXPERT
Commented:
* 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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.