How to use an Access db in CF?

I use System.Data.OleDb.OleDbConnection and System.Data.OleDb.OleDbCommand
in my desktop C# app and I'm investigating porting to the Pocket PC
platform. It doesn't appear that these classes are supported. Am I missing
something or am I out of luck?

I have an existing Access database provided by a 3rd party so using a
different database isn't really an option. What kind of solutions are there
for using an Access database (preferrably for both Pocket PC and desktop).

I appreciate any advice.

Chris
Mon May 31 06:43:34 CDT 2004

There is no OLEDB provider in the CF. There is an ADOCE wrapper at
www.ithehand.com

-Chris


"Jeff Shanholtz" <not.given@to.prevent.spamming> wrote in message
news:tk27oza6he7i.198oeebvpa2hg.dlg@40tude.net...
> I use System.Data.OleDb.OleDbConnection and System.Data.OleDb.OleDbCommand
> in my desktop C# app and I'm investigating porting to the Pocket PC
> platform. It doesn't appear that these classes are supported. Am I missing
> something or am I out of luck?
>
> I have an existing Access database provided by a 3rd party so using a
> different database isn't really an option. What kind of solutions are
there
> for using an Access database (preferrably for both Pocket PC and desktop).
>
> I appreciate any advice.

Jeff
Mon May 31 12:30:37 CDT 2004

On Mon, 31 May 2004 07:43:34 -0400, Chris Tacke, eMVP wrote:

> There is no OLEDB provider in the CF. There is an ADOCE wrapper at
> www.ithehand.com

Thanks for the tip, but are you sure you typed that URL in right? I can't
get there and I don't get any results if I try a google search on that
site.

Chris
Mon May 31 12:39:50 CDT 2004

whoops. thats In The Hand, so www.inthehand.com

"Jeff Shanholtz" <not.given@to.prevent.spamming> wrote in message
news:1ck5e46w13m7j.1hyhgbvrrswqp.dlg@40tude.net...
> On Mon, 31 May 2004 07:43:34 -0400, Chris Tacke, eMVP wrote:
>
> > There is no OLEDB provider in the CF. There is an ADOCE wrapper at
> > www.ithehand.com
>
> Thanks for the tip, but are you sure you typed that URL in right? I can't
> get there and I don't get any results if I try a google search on that
> site.

Jeff
Mon May 31 19:32:27 CDT 2004

On Mon, 31 May 2004 13:39:50 -0400, Chris Tacke, eMVP wrote:

> whoops. thats In The Hand, so www.inthehand.com

That looks potentially promising, but from reading the description of their
product, it appears I would have to convert the database to another format
anyway (mdb -> cdb).

Sorry for the ignorance here (I'm relatively new to database programming),
but is there a way to convert an mdb database to a SQL database? If I have
to convert to another format anyway, I might as well convert to a format
that's natively supported in CF *and* on the desktop (if I'm correct, cdb
wouldn't be supported on the desktop?). I would definitely prefer to have
the exact same database for both platforms.

I sure appreciate the suggestions!

kiln
Thu Jun 03 08:33:46 CDT 2004

In article <jmnipdmf7ixb$.1wj1s41gsf349$.dlg@40tude.net>,
not.given@to.prevent.spamming says...
> On Mon, 31 May 2004 13:39:50 -0400, Chris Tacke, eMVP wrote:
>
> > whoops. thats In The Hand, so www.inthehand.com
>
> That looks potentially promising, but from reading the description of their
> product, it appears I would have to convert the database to another format
> anyway (mdb -> cdb).
>
> Sorry for the ignorance here (I'm relatively new to database programming),
> but is there a way to convert an mdb database to a SQL database? If I have
> to convert to another format anyway, I might as well convert to a format
> that's natively supported in CF *and* on the desktop (if I'm correct, cdb
> wouldn't be supported on the desktop?). I would definitely prefer to have
> the exact same database for both platforms.
>
> I sure appreciate the suggestions!
>
Yes, as long as it's a recent edition of Access, you can convert an mdb
(termed an Access database) into MSDE (termed an Access Project)
database, a sql server variant.