Re: WM 5.0 and ADOCE/Net Framework

Actually, the SQLite ADO.NET 2.0 provider is only 1 mixed DLL containing
both the managed provider and the native sqlite3 core. Total file size is
366kb on the Compact Framework.

Databases can be moved freely from desktop to mobile and even onto Mac's and
*nix platforms.

http://sqlite.phxsoftware.com

Robert

"Richard Mueller" <rlmueller-NOSPAM@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23kHNXkhPGHA.2624@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I've been struggling with this issue for some time. There is no support
for mdb/cdb or ADOCE on WM5. The options I know of:

1. SQLite, which I believe can be accessed both on the desktop and the
mobile device. I don't know if it can be accessed by a .NET app, but it
can be used by apps written in NS Basic/CE, which is an alternative to
eMBedded VB.
2. SQLCE on the mobile device. To synch with an SQL Server database on the
desktop you need to setup an IIS web site and configure merge replication.
This can be done with wizards, but makes no sense for a product you are
selling to customers.
3. Read and write to text files on the mobile device.

Since I need to move data between a desktop and the mobile device, I'm
going with the last option. I plan to copy the text files to the desktop
and then read the data into my SQL Server database (and also the reverse).
SQLite involves installing another product (several dll's). Saving my data
in SQLCE on the mobile device is no problem, but there is no simple way to
send the data to the destkop, or get data from the desktop to the SQLCE
database.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net

"brianbulla@xxxxxxxxxxx" <brianbullahotmailcom@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:265585D2-0E80-4AA1-A377-0C5F39565269@xxxxxxxxxxxxxxxx
Vern,

I am also having the exact same problem. Hae you found a solution?? I
have
looked everywhere and nobody seems to have an idea how to resolve this
issue.

I can't imagine that with WM5 there is no way to take your mdb and use it
on
the device. That doesn't make any sense.

Any advice you, or anyone else on this thread, can give is appreciated.

Thanks,

Brian

"JeffK" wrote:

Vern,
Have you found a direction that you are heading yet ? SQL Server
Mobile
(SQLCE) or EDB ? What are you using on the PC side instead of Access to
manage the database before it gets copied to the PocketPC ?

Jeff

"Vern" wrote:

That's bad news. I really need to run this app off WM 5.0. Do you
know of
any third party solutions or other workarounds that would enable me to
still
install an app that needs ADOCE and pocket access on WM 5.0? Do you
know
what other developers are others doing to solve this problem?

Thanks
Vern

"Peter Foot [MVP]" wrote:

Pocket Access synchronisation is only available with ActiveSync 4.0
against
pre v5.0 devices. Windows Mobile 5.0 doesn't have access
synchronisation nor
is ADOCE supported on the platform.

Peter

--
Peter Foot
Windows Embedded MVP
http://www.inthehand.com | http://www.peterfoot.net

"Vern" <Vern@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7CE102F6-D813-4A63-BA4C-0042F468A3C7@xxxxxxxxxxxxxxxx
I have an application built using Visual Studio Net 2003 which uses
an
Access
database. To install it on my WM 2003 SE device I have to install
ADOCE
3.1
and Netframework 1.1 first then install the app then convert the
Access
database to the device using Activesync in the .cdb format. Can I
still
install ADOCE and Netframework on WM 2005? How about the .cdb
database?
Are
there any known problems installing these apps on WM 5.0? I am
not ready
to
rewrite the app yet! I installed Activesync 4.0 and noticed that
pocket
access is still listed as an option for sychronization so that in
itself
was
encouraging.

Thanks in advance

Vern







.

Relevant Pages

  • Re: WM 5.0 and ADOCE/Net Framework
    ... SQLCE on the mobile device. ... read the data into my SQL Server database. ... install an app that needs ADOCE and pocket access on WM 5.0? ...
    (microsoft.public.pocketpc.developer)
  • How to build a VAX/VMS emulator on Fedora Core 3 Linux
    ... make install the libpcap for ethernet support on VAX emulator ... Is the OpenVMS media ready to be mounted? ... * Do you want to install the MSGHLP database? ... Message from user AUDIT$SERVER on NEWBB ...
    (alt.os.linux.redhat)
  • Re: Need technique to programatically update back end structure / relationships
    ... Yes, that should work, Bob. ... Install the new one. ... > have the user rename the current production database (after taking a ... > final step of the installation process, I would ask the user to execute ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Error: Cannot find a valid Windows XP Embedded database installed
    ... Both the database and tools are Eval or Retail? ... Microsoft Windows XP Embedded Test Team ... Well, in fact it has a network connection, and it's working without any ... if I install everything in the same computer (tools and ...
    (microsoft.public.windowsxp.embedded)
  • Re: MDE-File
    ... A main database ... >> When I install the runtime-version, ... And they should be the same for mdb as mde, ... >> refresh the link and use dbHiddenObject to hidden IT. ...
    (microsoft.public.access.developers.toolkitode)