Windows Phone Thoughts - Daily News, Views, Rants and Raves

Check out the hottest Windows Mobile devices at our Expansys store!


Digital Home Thoughts

Loading feed...

Laptop Thoughts

Loading feed...

Android Thoughts

Loading feed...




Go Back   Thoughts Media Forums > WINDOWS PHONE THOUGHTS > Windows Phone Developer

Reply
 
Thread Tools Display Modes
  #1  
Old 01-02-2003, 10:29 AM
Andy Sjostrom
Pontificator
Join Date: Aug 2006
Posts: 1,177
Default ADOCE ActiveX Wrapper for .NET Compact Framework

http://www.devbuzz.com/content/zinc_dotnet_pocket_access_pg1.asp

Contests are over. Back to (Visual) basic! Check out Peter Foot's article regarding his ADOCE ActiveX wrapper!

"The omission of a Pocket Access database provider has sparked much discussion from the very first release of the .NET Compact Framework. While Microsoft had provided developers with SQL Server CE, there is still a strong need for Pocket Access databases, both for updating applications previously written in eVB, and for any other application where installation of SQL Server CE could be considered overkill. With this in mind I wrote a wrapper library around the familiar ADOCE ActiveX control."
 
Reply With Quote
  #2  
Old 01-02-2003, 01:56 PM
Mike Temporale
Editor Emeritus
Mike Temporale's Avatar
Join Date: Aug 2006
Posts: 10,981

well, the .NET compact framework is still only in beta. So there is hope that MS will include this in the final release due out this coming April.

However, if it doesn't show up... This would be really handy.
 
Reply With Quote
  #3  
Old 01-02-2003, 03:22 PM
BigCanoe
Ponderer
Join Date: Dec 2004
Posts: 101

I wish it was included in the .NET framework, I would prefer .cdb over text or xml or SQL Server CE personally.
 
Reply With Quote
  #4  
Old 01-02-2003, 03:29 PM
Jimmy Dodd
Sage
Join Date: Jul 2003
Posts: 713

Both Pocket Access and the native data store got left out of .NETcf. Haven't heard any explaination for that either.
 
Reply With Quote
  #5  
Old 01-02-2003, 05:01 PM
possmann
Oracle
possmann's Avatar
Join Date: Jul 2003
Posts: 974
Send a message via MSN to possmann Send a message via Skype™ to possmann
Default oversight?

How many people (are there like me) who would just love to use PocketAccess on their PPC?

I am talking about being able to sync things with a MS Access database (2000 or 2002) rather than having to 'upgrade' to SQL Server CE or having to purchase an add-on. I keep thinking that MS is really missing the boat on this here...

Any good 3rd party FREE apps out there that allow me to present a form on my PPC so I can add/edit/delete records in my Access database via my PPC?
 
Reply With Quote
  #6  
Old 01-02-2003, 05:35 PM
Charles Pickrell
Intellectual
Join Date: Oct 2003
Posts: 157

I think Microsoft wants to migarate all their database software towards SQL Server. The Pocket PC folks are just the most nimble of all of the groups and that is why they get all the cutting edge directives completed first. I mean loog at it, Reader, Bluetooth, etc. Pocket PC is fast in getting tech to market. I know the next version of Windows (Longhorn) is supposed to have SQL Server running as the file system! Why on earth would Microsoft want tot continue to use the MDB format when they have something as powerful as SQL server.

That being said I think the migration to SQL server on Pocket PC should be timed to coincide with desktop products. If I had to code a new .NET database app today, I certainly would consider this plug-in for client side data storage.

My 2 cents
__________________
Charles Pickrell
Sacramento Mobiole Computing SIG
A chapter of the NorCal Mobile Computing SIG
www.mobilecomputingsig.com
 
Reply With Quote
  #7  
Old 01-02-2003, 06:34 PM
Peter Foot
Thinker
Join Date: Apr 2007
Posts: 354

Quote:
I think Microsoft wants to migrate all their database software towards SQL Server.
I'm not sure that I agree its Microsofts game-plan to migrate everyone to SQL Server CE. For example Windows CE .NET 4.x continues to use a development of the same database engine internally, and I'm sure that future versions of Pocket PC will be built using the CEDB database engine.

Pocket Access was a key technology to both eVC and eVB programmers and its ommision from .NET Compact Framework was never fully justified. I decided to create the wrapper because I wanted to use my existing Pocket Access databases in my projects and made it available so everybody else could too. The solution is more resource friendly than SQL Server CE which is for most applications overkill. I'd like to see further development of the database engine in future versions of the OS sure but I'm convinced that it's a more appropriate database engine for mobile client development - but hey I'm biased I guess :wink: .
 
Reply With Quote
  #8  
Old 01-02-2003, 07:24 PM
BigCanoe
Ponderer
Join Date: Dec 2004
Posts: 101

I would agree if SQL Server CE was built in, in the ROM of the PocketPC. I don't expect non-corporate consumers will want to install it. I guess for small databases its best to use XML files or the nice wrapper that Peter has written.
 
Reply With Quote
  #9  
Old 01-02-2003, 08:35 PM
possmann
Oracle
possmann's Avatar
Join Date: Jul 2003
Posts: 974
Send a message via MSN to possmann Send a message via Skype™ to possmann
Default resources

I assume that SQL Ce is much more resource intensive than Pokect Access - is that correct? Memory and processor... I would further assume that you would be able to store the databases themselves on an expansion card in the PPC - are there any differences here?

Longhorn on SQL? Whoa... I gotta get caught up on the news a bit. I am certainly for merging the two together, but I would think that would comprimise MS licensing strategy for SQL. Access is much less and sold to a completly differnt user/purpose. How would you market SQL to that same user without loosing the value/price to the high-end industrial user/prupose?

my 1 cent
 
Reply With Quote
  #10  
Old 01-02-2003, 09:35 PM
Tim Allen
Ponderer
Join Date: Aug 2006
Posts: 108

I agree that Access and SQL Server are different beasts which satisfy different business problems. However it would seem to make sense for Microsoft to merge these at some point in the future, at least from an internal engine perspective even if outwardly they still look and feel different - and are priced accordingly.

In the short term though I think they just had to make a difficult decision based on they key constraint of keeping the size of the CF as small as possible - and that means support for only one database. SQL is the strategic choice - at least for business which MS may view as the big untapped PPC market - and so Access got left out.

BTW - good job Peter!
 
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:53 PM.