rbfigueira.net

All about .net stuff, Compact framework, framework.net and personal projects.

Pocket PC + Access + Compact Framework

The point here is to use Compact Framework with Windows CE Property Databases (.cdb - often known as Pocket Access).

The Compact Framework contains data providers for SQL Server CE and a remote SQL Server, it also allows access to data in XML text files. There is no support for Windows CE Property Databases (.cdb - often known as Pocket Access).

For example: We have Database Access 2000 and we want to use in our Pocket PC. First we  “Transfer data into Pocket Access on your Pocket PC”
http://www.devbuzz.com/content/zinc_transferring_database_pg1.asp

Then, how we connect with that database?
Hummm, I have found this component: ADOCE.NET from www.inthehand.com

This will cost $40 ! Is not free :(

“The ADOCE .NET Wrapper plugs this gap by providing read/write access to Windows CE Databases from the .NET Compact Framework.”

How to use it:
Pocket Access Data provider for the .NET Compact Framework
http://www.devbuzz.com/content/zinc_dotnet_pocket_access_pg1.asp

Perhaps, someone here, have write some .net class to works with this kind of database (Pocket Access). I will love to know that someone has “discovery” how to connect with this database using the .NET Compact Framework.

Posted: Jun 06 2003, 11:10 AM by rbfigueira | with 15 comment(s)
Filed under:

Comments

Joseph Chang said:

I'm not sure if this is what you are looking for, but I believe so. Open NETCF has a CEDB managed wrapper available in their forums.

http://www.opennetcf.org/Forums/topic.asp?TOPIC_ID=281

credit goes to Elia Karagiannis
# June 6, 2003 6:46 AM

Nino Benvenuti said:

Joseph beat me to it.. yep, use the code from Elia. Have you thought about using SQL CE? I'm curious as to what drove you to a decision of Pocket Access over SQL CE..

-Nino
# June 6, 2003 9:44 AM

Nino said:

..and then I re-read the post.... *sigh*
# June 6, 2003 9:45 AM

rbfigueira said:

Hi, thanks for that link ;P

I will use the SQLCE 2.0 to do my Pocket PC applications. I will never put Pocket Access over SQL CE. I like to know others databases alternatives. I am thinking to do a DAL (Data Access Layer) that support (SQLCE, ACCESS and XML) databases. I will use different databases depending of app and the situation. :)
# June 6, 2003 12:39 PM

Nino Benvenuti said:

Ricardo,

Alternatives to SQL CE 2.0 are: Sybase's iAnywhere and IBM's <A HREF="http://www-3.ibm.com/software/data/db2/everyplace/everyplacedb.html">DB2 Everyplace. Note: IBM does not yet have a managed provider for DB2; Sybase has one for iAnywhere.

-Nino
# June 7, 2003 8:08 AM

Joseph Chang said:

There's also a codebase DB out there. It exists for Windows CE, but only in C++/C and VB. It's also available for C#/.NET but not sure if that ports over to .NET CF.

http://www.sequiter.com

If you do mess with that DB, I humbly request a post describing it;-)
# June 7, 2003 5:39 PM

Juan said:

I tried out the managed database provider (CEDB) on VB .NET and it didn´t worked form me. The project compiles fine but at runtime (emulation) the app drops me an error telling me MissingMethodException. Any Ideas?
# August 26, 2003 6:27 AM

Juan said:

Well its me again. The MissingMethodExceptio was due to the inexistence of the cedbwrapper.dll :) The cedbManged provider is working fine now except for this curious thing. I can do inserts but there is no integrity checking and i cant do delete. Does anyone know how to delete records using the elia cedbManagedProvider? I would apreciate some help. Thanks in advance
# August 27, 2003 10:05 AM

Sheba said:

I'm still getting MissingMethodException inspite of having the required dlls in in Windows folder, when im trying my application in Windows CE .net Emulator. Any ideas to overcome this is appretiable.

Thank you
# October 1, 2003 12:19 AM

rfigueira said:

I don’t know how to help you but is more easy to find some solution on : opennetcf (http://www.opennetcf.org/Forums/) or on Microsoft/Newsgroups
(dotnet.framework.compactframework) ;) Cheers :)

# October 1, 2003 10:38 AM

papaye@fayabundem@blingbling.org said:

Hi!
Something strange :
It's possible to create a CDB file programmatically from an application (evb evc) on windows mobile 2003...
so, logically, there are the good components for handling cdb pocket access files on windows mobile 2003 c# dot net compact framework...

But a question is still here :
***WHY*** do these *EXISTING* components are not available from NET CF C# and co. ... ????

;)
see ya !
ppcdev@hotmail.com
# January 29, 2004 8:32 AM

Giuseppe said:

Hi, I would like to know if is possible to run SQL Server CE in an environment without SQLServer (for PC) and without IIS. I have W XP at home (no include IIS) and I dont wanna buy SQLServer.
Thanks a lot.


Giuseppe
galbatrino@hotmail.com
# March 29, 2004 10:47 AM

rbfigueira said:

I think you can install SQL Server CE on your own PDA. :)

Like you said, if you don’t have in your PC (ISS and SQLServer2000) you cant install SQL Server CE on that machine (PC Desktop) and you cant synchronize SQLServer with SQL Server CE.



# March 30, 2004 3:34 AM

elena said:

i need to handle mdb database in CF. I am having a really hard time finding a solution. Can anyone please give me some hints?! Thanks a lot.
# June 11, 2004 1:23 AM

Allgemeine Frage: VB.Net f?r Intelligente Ger?te und XML | hilpers said:

Pingback from  Allgemeine Frage: VB.Net f?r Intelligente Ger?te und XML | hilpers

# January 20, 2009 9:27 AM
Leave a Comment

(required) 

(required) 

(optional)

(required)