| Author |
Message |
|
Keld Laurse
#1 / 14
|
 ADOCE and .NET CF I have been fooling a little around with VS2003(beta), and found it to produce code that runs quite a lot faster than eVB. I do however have a single gripe with it: It doesn't seem to support ADOCE.
Googling the various dotnet groups revealed that soem guy, Peter Foot, has
written a wrapper for ADOCE.
Does it work? (User/developer experiences wanted)
Are there any other avenues I should be aware of?
Most of my info stems from the m.p.d.f.c group (included in the distribution
of this post), but the amount of posts were quite overwhelming, so I might
very well have missed some gold nuggets already posted on this topic.
As others have pointed out (in m.p.d.f.c), SSCE isn't always an attractive
way to go.
In my case, I have a project, already written in eVB, which I'm looking into
porting to the .net CF. This project is always connected to a single PC
(often Win98, so no IIS), and the "back end" data comes from some Access
tables. Therefore the most direct approach for me will be (continue) using
.cdb's for my data.
I also noted that I could use XML data, but a few tests showed me that I
would lose some performance that way, and my "database" sizes would explode.
Keld Laursen
|
| Sun, 21 Aug 2005 19:56:57 GMT |
|
 |
|
Chris Tacke, eMV
#2 / 14
|
ADOCE and .NET CF Peter's wrapper is of the quality that MS shouldn't even bother trying to write one but should just license his. -Chris
Quote: > I have been fooling a little around with VS2003(beta), and found it to > produce code that runs quite a lot faster than eVB. > I do however have a single gripe with it: It doesn't seem to support
ADOCE.
> Googling the various dotnet groups revealed that soem guy, Peter Foot, has
> written a wrapper for ADOCE.
> Does it work? (User/developer experiences wanted)
> Are there any other avenues I should be aware of?
> Most of my info stems from the m.p.d.f.c group (included in the
distribution
> of this post), but the amount of posts were quite overwhelming, so I might
> very well have missed some gold nuggets already posted on this topic.
> As others have pointed out (in m.p.d.f.c), SSCE isn't always an attractive
> way to go.
> In my case, I have a project, already written in eVB, which I'm looking
into
> porting to the .net CF. This project is always connected to a single PC
> (often Win98, so no IIS), and the "back end" data comes from some Access
> tables. Therefore the most direct approach for me will be (continue) using
> .cdb's for my data.
> I also noted that I could use XML data, but a few tests showed me that I
> would lose some performance that way, and my "database" sizes would
explode.
> Keld Laursen
|
| Sun, 21 Aug 2005 20:47:52 GMT |
|
|
|
Keld Laurse
#3 / 14
|
ADOCE and .NET CF
Quote: > Peter's wrapper is of the quality that MS shouldn't even bother trying to
> write one but should just license his.
So at the steep price of (were it around $50?), I shouldn't think twice, but just get it? Maybe the lack of alternatives is because other people said to themselves:
"Why bother..."?
:-)
Thanks for the info.
/Keld
|
| Sun, 21 Aug 2005 21:15:32 GMT |
|
|
|
Peter Foo
#4 / 14
|
ADOCE and .NET CF Theres an article on using the wrapper at devbuzz:- http://www.devbuzz.com/content/zinc_dotnet_pocket_access_pg1.asp You may also want to checkout the documentation at
http://www.inthehand.com/documentation
There will also be an update shortly to add support for long varbinary
(BLOB) fields, so that you can embed images, ink audio etc within your CDB
file.
Regards,
Peter
--
Peter Foot
http://www.inthehand.com
Handheld Interactive Reference Guides
Quote:
> > Peter's wrapper is of the quality that MS shouldn't even bother trying to > > write one but should just license his. > So at the steep price of (were it around $50?), I shouldn't think twice,
but
> just get it?
> Maybe the lack of alternatives is because other people said to themselves:
> "Why bother..."?
> :-)
> Thanks for the info.
> /Keld
|
| Sun, 21 Aug 2005 21:24:26 GMT |
|
|
|
Keld Laurse
#5 / 14
|
ADOCE and .NET CF
Quote: > Theres an article on using the wrapper at devbuzz:- > http://www.devbuzz.com/content/zinc_dotnet_pocket_access_pg1.asp > You may also want to checkout the documentation at
> http://www.inthehand.com/documentation
> There will also be an update shortly to add support for long varbinary
> (BLOB) fields, so that you can embed images, ink audio etc within your CDB
> file.
Thanks, Peter. I had a look at your homepage, and did check the deVBuzz link from there.
I have also downloaded the demo. I would have liked it to run on the actual
device instead of only the emulator.
(You know - it is a pain in the behind to get cdb tables into the emulator
:-) )
Keld Laursen
|
| Sun, 21 Aug 2005 22:23:53 GMT |
|
|
|
Chris Tacke, eMV
#6 / 14
|
ADOCE and .NET CF Wow, you consider $50 steep? $50 to save a few days coding minimum seems like a bargain to me. --
Chris Tacke, eMVP
Windows CE Product Manager
Applied Data Systems
www.applieddata.net
Quote:
> > Peter's wrapper is of the quality that MS shouldn't even bother trying to > > write one but should just license his. > So at the steep price of (were it around $50?), I shouldn't think twice,
but
> just get it?
> Maybe the lack of alternatives is because other people said to themselves:
> "Why bother..."?
> :-)
> Thanks for the info.
> /Keld
|
| Sun, 21 Aug 2005 22:41:46 GMT |
|
|
|
Flynn Arrowstar
#7 / 14
|
ADOCE and .NET CF Hey, Keld =) You can always do what I did for my program. I wrote a small routine that
created the .cdb file instead of messing around with translating, converting
and all that mess. Of course, my database was only 2 tables, so that helped.
Flynn
Quote:
> > Theres an article on using the wrapper at devbuzz:- > > http://www.devbuzz.com/content/zinc_dotnet_pocket_access_pg1.asp > > You may also want to checkout the documentation at
> > http://www.inthehand.com/documentation
> > There will also be an update shortly to add support for long varbinary
> > (BLOB) fields, so that you can embed images, ink audio etc within your
CDB
> > file.
> Thanks, Peter.
> I had a look at your homepage, and did check the deVBuzz link from there.
> I have also downloaded the demo. I would have liked it to run on the
actual
> device instead of only the emulator.
> (You know - it is a pain in the behind to get cdb tables into the emulator
> :-) )
> Keld Laursen
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003
|
| Mon, 22 Aug 2005 01:19:55 GMT |
|
|
|
Keld Laurse
#8 / 14
|
ADOCE and .NET CF
Quote: > Wow, you consider $50 steep? $50 to save a few days coding minimum seems
> like a bargain to me.
> > So at the steep price of (were it around $50?), I shouldn't think twice,
> but
> > just get it?
I thoght that with the context I used steep in, I didn't have to add any emoticons, but it seems that I were mistaken. I don't find the price bad at all.
Keld Laursen
|
| Mon, 22 Aug 2005 04:41:23 GMT |
|
|
|
Keld Laurse
#9 / 14
|
ADOCE and .NET CF
Quote: > You can always do what I did for my program. I wrote a small routine that
> created the .cdb file instead of messing around with translating,
converting
> and all that mess. Of course, my database was only 2 tables, so that
helped. I have something like 7000 static records to put into 3 tables (reference
data) and something like 500 to put into 4 other tables (for editing).
I can't create all those data on the fly, so I have to convert them somehow.
Oh well, I can always use the trick mentioned on Microsofts site.
As long as I don't forget to save the emulator state, the data should be OK.
Can I use some of the normal tools to get the .cdb's off the device for
safekeeping? (Remote File Viewer or such?)
/Keld
|
| Mon, 22 Aug 2005 04:44:12 GMT |
|
|
|
Flynn Arrowstar
#10 / 14
|
ADOCE and .NET CF Hey, Keld =) Yeah, I can see where that would be a problem, heh. The database I built was
only two tables, no static data and only two indicies, so it was pretty easy
to handle with code.
As for using the remote file viewer, I don't see why you couldn't use it,
although it would only be usable on the emulator (as you likely know). But
you shouldn't have any problems using that to copy over the .cdb files for
safekeeping in case you forget to save the emulator state.
I just started with VS.NET 2003 myself, so it will be a learning experience.
I am working on a small db-enabled puzzle game. So, I will also have to look
at getting Peter Foot's control.
Flynn
Quote:
> > You can always do what I did for my program. I wrote a small routine
that
> > created the .cdb file instead of messing around with translating,
> converting
> > and all that mess. Of course, my database was only 2 tables, so that
> helped.
> I have something like 7000 static records to put into 3 tables (reference
> data) and something like 500 to put into 4 other tables (for editing).
> I can't create all those data on the fly, so I have to convert them
somehow.
> Oh well, I can always use the trick mentioned on Microsofts site.
> As long as I don't forget to save the emulator state, the data should be
OK.
> Can I use some of the normal tools to get the .cdb's off the device for
> safekeeping? (Remote File Viewer or such?)
> /Keld
|
| Mon, 22 Aug 2005 05:15:32 GMT |
|
|
|
Peter Foo
#11 / 14
|
ADOCE and .NET CF If you have a Pocket PC device handy you can grab a cdb from that and then deploy it to the emulator within your project in VS 2003. All you have to do is turn off the conversion rules for Pocket Access .cdb so that it is not converted to a desktop access file when dragged to the desktop. There are instructions for this in this forum post:- http://www.inthehand.com/forums/ShowPost.aspx?PostID=91 Theres also a tool discussed here:-
http://www.devbuzz.com/content/zinc_convert_database_mdb_to_cdb_pg1.asp
I realise that getting the database onto the emulator is a bit of a pain but
there has to be some limitation to the demo and it was simplest to just
supply a fully functional emulator-only version.
HTH
Peter
Quote:
> > You can always do what I did for my program. I wrote a small routine
that
> > created the .cdb file instead of messing around with translating,
> converting
> > and all that mess. Of course, my database was only 2 tables, so that
> helped.
> I have something like 7000 static records to put into 3 tables (reference
> data) and something like 500 to put into 4 other tables (for editing).
> I can't create all those data on the fly, so I have to convert them
somehow.
> Oh well, I can always use the trick mentioned on Microsofts site.
> As long as I don't forget to save the emulator state, the data should be
OK.
> Can I use some of the normal tools to get the .cdb's off the device for
> safekeeping? (Remote File Viewer or such?)
> /Keld
|
| Mon, 22 Aug 2005 07:16:14 GMT |
|
|
|
Flynn Arrowstar
#12 / 14
|
ADOCE and .NET CF Hi, Peter =) I completely understand. I had a similar issue with the application I'm
about finished with. How to limit the use of the system while still
providing a taste of what the full version can do. I ended up disabling some
of the reports and customization options to make a functional "lite" version
of my application. Very little code had to be changed, and makes it easy to
update both versions at the same time.
I'm eyeballing both the ADOCE.NET wrapper and the POOM Wrapper. Hopefully
I'll be able to afford those soon =)
Flynn
Quote: > If you have a Pocket PC device handy you can grab a cdb from that and then > deploy it to the emulator within your project in VS 2003. All you have to do > is turn off the conversion rules for Pocket Access .cdb so that it is not > converted to a desktop access file when dragged to the desktop. There are > instructions for this in this forum post:- > http://www.inthehand.com/forums/ShowPost.aspx?PostID=91 > Theres also a tool discussed here:-
> http://www.devbuzz.com/content/zinc_convert_database_mdb_to_cdb_pg1.asp
> I realise that getting the database onto the emulator is a bit of a pain
but
> there has to be some limitation to the demo and it was simplest to just
> supply a fully functional emulator-only version.
> HTH
> Peter
> > > You can always do what I did for my program. I wrote a small routine
> that
> > > created the .cdb file instead of messing around with translating,
> > converting
> > > and all that mess. Of course, my database was only 2 tables, so that
> > helped.
> > I have something like 7000 static records to put into 3 tables
(reference
> > data) and something like 500 to put into 4 other tables (for editing).
> > I can't create all those data on the fly, so I have to convert them
> somehow.
> > Oh well, I can always use the trick mentioned on Microsofts site.
> > As long as I don't forget to save the emulator state, the data should be
> OK.
> > Can I use some of the normal tools to get the .cdb's off the device for
> > safekeeping? (Remote File Viewer or such?)
> > /Keld
|
| Mon, 22 Aug 2005 07:54:52 GMT |
|
|
|
Keld Laurse
#13 / 14
|
ADOCE and .NET CF
Quote: > If you have a Pocket PC device handy you can grab a cdb from that and then
> deploy it to the emulator within your project in VS 2003.
With all the fuss about getting tables onto the emulator, I had the distinct impression that the two weren't compatible. I even think that I once saw that you couldn't copy the database from device to emulator. As I already have the databases handy on the device (from my eVB project),
it should be no problem to get a copy of the file.
One other method of moving the files would be to rename them so they had an
unrecognizable extension. Then the converters shouldn't be able to recognize
them, and therefore leave them intact. Maybe it is easier than fiddling with
conversion settings (and remember to reset them afterwards).
Keld Laursen
|
| Mon, 22 Aug 2005 15:27:50 GMT |
|
|
|
boomeran
#14 / 14
|
ADOCE and .NET CF Hi, There will be another alternative in a week or two, You can sync SSCE
database over activesync with access,sql server,mysql,oracle etc. with my
utility. I'll post demo version soon.
Quote: > I have been fooling a little around with VS2003(beta), and found it to > produce code that runs quite a lot faster than eVB. > I do however have a single gripe with it: It doesn't seem to support
ADOCE.
> Googling the various dotnet groups revealed that soem guy, Peter Foot, has
> written a wrapper for ADOCE.
> Does it work? (User/developer experiences wanted)
> Are there any other avenues I should be aware of?
> Most of my info stems from the m.p.d.f.c group (included in the
distribution
> of this post), but the amount of posts were quite overwhelming, so I might
> very well have missed some gold nuggets already posted on this topic.
> As others have pointed out (in m.p.d.f.c), SSCE isn't always an attractive
> way to go.
> In my case, I have a project, already written in eVB, which I'm looking
into
> porting to the .net CF. This project is always connected to a single PC
> (often Win98, so no IIS), and the "back end" data comes from some Access
> tables. Therefore the most direct approach for me will be (continue) using
> .cdb's for my data.
> I also noted that I could use XML data, but a few tests showed me that I
> would lose some performance that way, and my "database" sizes would
explode.
> Keld Laursen
|
| Mon, 22 Aug 2005 20:46:28 GMT |
|
| |
|
