Solved

Will MSDE work on WinCE?

Posted on 2004-09-05
7
354 Views
Last Modified: 2008-03-06
i need a proof. a site possibly from microsoft.

I ask the same question from WinCe Topic area already.

Anyways, here are my questions

1.) Will msAccess work on WinCE?

2.) priority - Will MSDE work on WinCE?
i need proof. I am making a recommendation letter to use MSDE instead on MsAccess.

I just need to prove the it support winCE.

We do not plan to use SQLCE.

thanx,
jerry
0
Comment
Question by:Jerry_Pang
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 15

Accepted Solution

by:
jdlambert1 earned 90 total points
ID: 11986853
WinCE is not listed as a supported platform for MSDE or Access:
http://support.microsoft.com/default.aspx?scid=kb;en-us;324998
http://www.microsoft.com/office/previous/access/2002sysreq.asp

Nor is there a "Pocket" version of Access: (the downloadable executable is a word doc)
http://msdn.microsoft.com/embedded/prevver/ce.net/winceppc/default.aspx
0
 
LVL 9

Author Comment

by:Jerry_Pang
ID: 11986905
any recommendation as a Database for WinCE?
0
 
LVL 9

Author Comment

by:Jerry_Pang
ID: 11987147
i guess SQL CE is the best database for winCe. It was built for winCE.

Anyways, last question, is it possible to access Access database in WinCE?
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Assisted Solution

by:sls80
sls80 earned 35 total points
ID: 11987909
SQL CE works well on WinCE. I have just used it for a .NET pocketpc application without any major dramas. Note that it only supports a single open connection.

How do you plan to connect to the Access database? Do you mean that you want to access a remote Access database from a WinCE platform? Do you plan to have other components created that will handle this connection?
0
 
LVL 9

Author Comment

by:Jerry_Pang
ID: 11988425
both..
0
 

Expert Comment

by:sls80
ID: 11988444
Probably the easiest way to connect to a remote Access database would be to create something such as a web service operating on the machine with the database on it, and create the connection locally between your web service and the database. Then you simply need to connect your pocketpc to the web service programatically.

Otherwise, I'm not sure how you are planning on creating a connection from your WinCE to Access, unless you want to create a socket to the machine hosting the DB and then create a connection from there? That would be a lot of programming...

Would a web service solution be possible in what you are trying to do?
0
 
LVL 9

Author Comment

by:Jerry_Pang
ID: 11993131
yes. i guess so. its one of my project in the future. now, at least, i know where i am going. thanx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read about achieving the basic levels of HRIS security in the workplace.
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question