Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Mobile database development
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Gentoo on PPC
View previous topic :: View next topic  
Author Message
skinned_knuckles
n00b
n00b


Joined: 14 Mar 2005
Posts: 2
Location: Minneapolis

PostPosted: Mon Mar 14, 2005 5:25 pm    Post subject: Mobile database development Reply with quote

I need my Windows Mobile 2003 application to read and write a single column or row of data to a Microsoft Access database on the company network. I know of two possible solutions.

Solution 1 InTheHand

ActiveSync has a nice built-in capability to create, transfer and synchronize an abridged copy of an Access database. The file it creates has a .cdb extension. Sometimes it is called “Pocket Access” format even though Pocket Access is no longer offered.

There are plenty of programs available that use this format but I need open source code to expand an existing application. InTheHand sells a ADOCE.NET wrapper which includes all the classes and objects to connect and interact with the .cdb database. But I’ve yet to find clear instructions of how to use it. Specifically I need to know what references I need to add to my project if I’m using a ipaq rx3115 with a Samsung processor (S3C2440) and what files if any I need to copy or install on my PPC. Anybody know?

Solution 2 Sqlserverce

Sqlserverce objects are available as part of Visual Studio but as I understand these will only work with sqlserver files ending in .sdb. I’m sure that this file type can be generated with Microsoft SQL server but it seems I can’t install that without adding IIS to my computer which the IT department won’t let me do. Is there another way to translate .mdb files into .sql files? And how can I synchronize the PPC database with the network database.

Is there another solution I’ve overlooked?

Thanks for any feedback.


Jonathan
Back to top
View user's profile Send private message
thesnowman
Guru
Guru


Joined: 08 May 2003
Posts: 365
Location: Sydney, Australia

PostPosted: Mon Mar 14, 2005 11:10 pm    Post subject: Reply with quote

Write a web service for access to Access, then write a client for it. Lots of examples of this out there. Just need to ensure .NET compact framework is installed on mobile device. Windows Mobile 2003 and greater have it in ROM.

Here's a small example:
http://samples.gotdotnet.com/quickstart/CompactFramework/
Back to top
View user's profile Send private message
skinned_knuckles
n00b
n00b


Joined: 14 Mar 2005
Posts: 2
Location: Minneapolis

PostPosted: Mon Mar 14, 2005 11:13 pm    Post subject: Great idea, but Reply with quote

I'd love to do that but the Information Services Department of our company views it as a security risk and will not let me setup a web server, especially if it's wireless.

Jonathan
Back to top
View user's profile Send private message
thesnowman
Guru
Guru


Joined: 08 May 2003
Posts: 365
Location: Sydney, Australia

PostPosted: Tue Mar 15, 2005 12:22 pm    Post subject: Reply with quote

That's a shame, guess you're stuck with your first two options then.

By the way, this forum is for Gentoo on PPC (PowerPC), not Gentoo on PocketPC, and certainly not WinCE development...
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Gentoo on PPC All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum