Hi everyone,

I am pretty new to C# developing form mobile devices. I have an Access
database that I have syncronised through ActiveSync to my PocketPc. Now,
using VS.NET 2003 I want to develop a simple app that retreives data from
the database.

Is this possible at all, or do I need SQL CE server? Where can I find this
server?

Are there any samples on how to acess an Access database?

Thanks, from Spain

Sorry, I should have looked more carefully... I already know where to get
ahold of SLQ CE.

But I still don´t know how to use my Access imported Databases.
Juan wrote:
:: Hi everyone,
::
:: I am pretty new to C# developing form mobile devices. I have an
:: Access database that I have syncronised through ActiveSync to my
:: PocketPc. Now, using VS.NET 2003 I want to develop a simple app that
:: retreives data from the database.
::
:: Is this possible at all, or do I need SQL CE server? Where can I
:: find this server?
::
:: Are there any samples on how to acess an Access database?
::
:: Thanks, from Spain

There is no inherent Pocket Access class library. InTheHand has one.

-Chris


"Juan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sorry, I should have looked more carefully... I already know where to get
> ahold of SLQ CE.
>
> But I still don´t know how to use my Access imported Databases.
> Juan wrote:
> :: Hi everyone,
> ::
> :: I am pretty new to C# developing form mobile devices. I have an
> :: Access database that I have syncronised through ActiveSync to my
> :: PocketPc. Now, using VS.NET 2003 I want to develop a simple app that
> :: retreives data from the database.
> ::
> :: Is this possible at all, or do I need SQL CE server? Where can I
> :: find this server?
> ::
> :: Are there any samples on how to acess an Access database?
> ::
> :: Thanks, from Spain
>
>

Pocket Access is not supported directly by the .NET Compact Framework,
however you can use the ADOCE control by creating a wrapper to handle
interop with the COM control (.NETCF has no built in COM/ActiveX interop).
We produce such a wrapper, there is an example of it's use in this article:-
http://msdn.microsoft.com/library/de...ad10222003.asp

Peter

--
Peter Foot
Windows Embedded MVP
OpenNETCF.org Senior Advisor
www.inthehand.com | www.opennetcf.org

"Juan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Sorry, I should have looked more carefully... I already know where to get
> ahold of SLQ CE.
>
> But I still don´t know how to use my Access imported Databases.
> Juan wrote:
> :: Hi everyone,
> ::
> :: I am pretty new to C# developing form mobile devices. I have an
> :: Access database that I have syncronised through ActiveSync to my
> :: PocketPc. Now, using VS.NET 2003 I want to develop a simple app that
> :: retreives data from the database.
> ::
> :: Is this possible at all, or do I need SQL CE server? Where can I
> :: find this server?
> ::
> :: Are there any samples on how to acess an Access database?
> ::
> :: Thanks, from Spain
>
>

If it´s not supported by .Net framework, what's the point on having Access
databases in the Pocket PC? You can´t open them, not even programatically???
I don´t understand.....

Peter Foot [MVP] wrote:
:: Pocket Access is not supported directly by the .NET Compact
:: Framework, however you can use the ADOCE control by creating a
:: wrapper to handle interop with the COM control (.NETCF has no built
:: in COM/ActiveX interop). We produce such a wrapper, there is an
:: example of it's use in this article:-
::
http://msdn.microsoft.com/library/de...ad10222003.asp
::
:: Peter
::
:: --
:: Peter Foot
:: Windows Embedded MVP
:: OpenNETCF.org Senior Advisor
:: www.inthehand.com | www.opennetcf.org
::
:: "Juan" <(E-Mail Removed)> wrote in message
:: news:(E-Mail Removed)...
::: Sorry, I should have looked more carefully... I already know where
::: to get ahold of SLQ CE.
:::
::: But I still don´t know how to use my Access imported Databases.
::: Juan wrote:
::::: Hi everyone,
:::::
::::: I am pretty new to C# developing form mobile devices. I have an
::::: Access database that I have syncronised through ActiveSync to my
::::: PocketPc. Now, using VS.NET 2003 I want to develop a simple app
::::: that retreives data from the database.
:::::
::::: Is this possible at all, or do I need SQL CE server? Where can I
::::: find this server?
:::::
::::: Are there any samples on how to acess an Access database?
:::::
::::: Thanks, from Spain

You can use eVC just fine, there's just no managed provider. The "point" of
having it is for backward compatibility. Pocket Access as a data engine
will become obsolete in a future version of Pocket PC.

--
Chris Tacke, eMVP
Co-Founder and Advisory Board Member
www.OpenNETCF.org
---
Windows CE Product Manager
Applied Data Systems
www.applieddata.net


"Juan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If it´s not supported by .Net framework, what's the point on having Access
> databases in the Pocket PC? You can´t open them, not even
programatically???
> I don´t understand.....
>
> Peter Foot [MVP] wrote:
> :: Pocket Access is not supported directly by the .NET Compact
> :: Framework, however you can use the ADOCE control by creating a
> :: wrapper to handle interop with the COM control (.NETCF has no built
> :: in COM/ActiveX interop). We produce such a wrapper, there is an
> :: example of it's use in this article:-
> ::
>
http://msdn.microsoft.com/library/de...ad10222003.asp
> ::
> :: Peter
> ::
> :: --
> :: Peter Foot
> :: Windows Embedded MVP
> :: OpenNETCF.org Senior Advisor
> :: www.inthehand.com | www.opennetcf.org
> ::
> :: "Juan" <(E-Mail Removed)> wrote in message
> :: news:(E-Mail Removed)...
> ::: Sorry, I should have looked more carefully... I already know where
> ::: to get ahold of SLQ CE.
> :::
> ::: But I still don´t know how to use my Access imported Databases.
> ::: Juan wrote:
> ::::: Hi everyone,
> :::::
> ::::: I am pretty new to C# developing form mobile devices. I have an
> ::::: Access database that I have syncronised through ActiveSync to my
> ::::: PocketPc. Now, using VS.NET 2003 I want to develop a simple app
> ::::: that retreives data from the database.
> :::::
> ::::: Is this possible at all, or do I need SQL CE server? Where can I
> ::::: find this server?
> :::::
> ::::: Are there any samples on how to acess an Access database?
> :::::
> ::::: Thanks, from Spain
>
>

So... what will the data engine be?

"Chris Tacke, eMVP" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> You can use eVC just fine, there's just no managed provider. The "point"
of
> having it is for backward compatibility. Pocket Access as a data engine
> will become obsolete in a future version of Pocket PC.
>
> --
> Chris Tacke, eMVP
> Co-Founder and Advisory Board Member
> www.OpenNETCF.org
> ---
> Windows CE Product Manager
> Applied Data Systems
> www.applieddata.net
>
>
> "Juan" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > If it´s not supported by .Net framework, what's the point on having
Access
> > databases in the Pocket PC? You can´t open them, not even
> programatically???
> > I don´t understand.....
> >
> > Peter Foot [MVP] wrote:
> > :: Pocket Access is not supported directly by the .NET Compact
> > :: Framework, however you can use the ADOCE control by creating a
> > :: wrapper to handle interop with the COM control (.NETCF has no built
> > :: in COM/ActiveX interop). We produce such a wrapper, there is an
> > :: example of it's use in this article:-
> > ::
> >
>
http://msdn.microsoft.com/library/de...ad10222003.asp
> > ::
> > :: Peter
> > ::
> > :: --
> > :: Peter Foot
> > :: Windows Embedded MVP
> > :: OpenNETCF.org Senior Advisor
> > :: www.inthehand.com | www.opennetcf.org
> > ::
> > :: "Juan" <(E-Mail Removed)> wrote in message
> > :: news:(E-Mail Removed)...
> > ::: Sorry, I should have looked more carefully... I already know where
> > ::: to get ahold of SLQ CE.
> > :::
> > ::: But I still don´t know how to use my Access imported Databases.
> > ::: Juan wrote:
> > ::::: Hi everyone,
> > :::::
> > ::::: I am pretty new to C# developing form mobile devices. I have an
> > ::::: Access database that I have syncronised through ActiveSync to my
> > ::::: PocketPc. Now, using VS.NET 2003 I want to develop a simple app
> > ::::: that retreives data from the database.
> > :::::
> > ::::: Is this possible at all, or do I need SQL CE server? Where can I
> > ::::: find this server?
> > :::::
> > ::::: Are there any samples on how to acess an Access database?
> > :::::
> > ::::: Thanks, from Spain
> >
> >
>
>

So I'd be better off using XML or SQL as a data provider...

Thanks for the explanations, some stuff is pretty obscure for me...

Chris Tacke, eMVP wrote:
:: You can use eVC just fine, there's just no managed provider. The
:: "point" of having it is for backward compatibility. Pocket Access
:: as a data engine will become obsolete in a future version of Pocket
:: PC.
::
:: --
:: Chris Tacke, eMVP
:: Co-Founder and Advisory Board Member
:: www.OpenNETCF.org
:: ---
:: Windows CE Product Manager
:: Applied Data Systems
:: www.applieddata.net
::
::
:: "Juan" <(E-Mail Removed)> wrote in message
:: news:(E-Mail Removed)...
::: If it´s not supported by .Net framework, what's the point on having
::: Access databases in the Pocket PC? You can´t open them, not even
::: programatically??? I don´t understand.....
:::
::: Peter Foot [MVP] wrote:
::::: Pocket Access is not supported directly by the .NET Compact
::::: Framework, however you can use the ADOCE control by creating a
::::: wrapper to handle interop with the COM control (.NETCF has no
::::: built in COM/ActiveX interop). We produce such a wrapper, there
::::: is an example of it's use in this article:-
:::::
:::
::
http://msdn.microsoft.com/library/de...ad10222003.asp
:::::
::::: Peter
:::::
::::: --
::::: Peter Foot
::::: Windows Embedded MVP
::::: OpenNETCF.org Senior Advisor
::::: www.inthehand.com | www.opennetcf.org
:::::
::::: "Juan" <(E-Mail Removed)> wrote in message
::::: news:(E-Mail Removed)...
:::::: Sorry, I should have looked more carefully... I already know
:::::: where to get ahold of SLQ CE.
::::::
:::::: But I still don´t know how to use my Access imported Databases.
:::::: Juan wrote:
:::::::: Hi everyone,
::::::::
:::::::: I am pretty new to C# developing form mobile devices. I have an
:::::::: Access database that I have syncronised through ActiveSync to
:::::::: my PocketPc. Now, using VS.NET 2003 I want to develop a simple
:::::::: app that retreives data from the database.
::::::::
:::::::: Is this possible at all, or do I need SQL CE server? Where can
:::::::: I find this server?
::::::::
:::::::: Are there any samples on how to acess an Access database?
::::::::
:::::::: Thanks, from Spain

Hi Jamie,

A future version of SqlCe.
--
Ginny Caughey
..Net Compact Framework MVP

"Jamie Macleod" <(E-Mail Removed)> wrote in message
news:eU%23%(E-Mail Removed)...
> So... what will the data engine be?
>
> "Chris Tacke, eMVP" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > You can use eVC just fine, there's just no managed provider. The
"point"
> of
> > having it is for backward compatibility. Pocket Access as a data engine
> > will become obsolete in a future version of Pocket PC.
> >
> > --
> > Chris Tacke, eMVP
> > Co-Founder and Advisory Board Member
> > www.OpenNETCF.org
> > ---
> > Windows CE Product Manager
> > Applied Data Systems
> > www.applieddata.net
> >
> >
> > "Juan" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > If it´s not supported by .Net framework, what's the point on having
> Access
> > > databases in the Pocket PC? You can´t open them, not even
> > programatically???
> > > I don´t understand.....
> > >
> > > Peter Foot [MVP] wrote:
> > > :: Pocket Access is not supported directly by the .NET Compact
> > > :: Framework, however you can use the ADOCE control by creating a
> > > :: wrapper to handle interop with the COM control (.NETCF has no built
> > > :: in COM/ActiveX interop). We produce such a wrapper, there is an
> > > :: example of it's use in this article:-
> > > ::
> > >
> >
>
http://msdn.microsoft.com/library/de...ad10222003.asp
> > > ::
> > > :: Peter
> > > ::
> > > :: --
> > > :: Peter Foot
> > > :: Windows Embedded MVP
> > > :: OpenNETCF.org Senior Advisor
> > > :: www.inthehand.com | www.opennetcf.org
> > > ::
> > > :: "Juan" <(E-Mail Removed)> wrote in message
> > > :: news:(E-Mail Removed)...
> > > ::: Sorry, I should have looked more carefully... I already know where
> > > ::: to get ahold of SLQ CE.
> > > :::
> > > ::: But I still don´t know how to use my Access imported Databases.
> > > ::: Juan wrote:
> > > ::::: Hi everyone,
> > > :::::
> > > ::::: I am pretty new to C# developing form mobile devices. I have an
> > > ::::: Access database that I have syncronised through ActiveSync to my
> > > ::::: PocketPc. Now, using VS.NET 2003 I want to develop a simple app
> > > ::::: that retreives data from the database.
> > > :::::
> > > ::::: Is this possible at all, or do I need SQL CE server? Where can I
> > > ::::: find this server?
> > > :::::
> > > ::::: Are there any samples on how to acess an Access database?
> > > :::::
> > > ::::: Thanks, from Spain
> > >
> > >
> >
> >
>
>

As announced at PDC, eDB is replacing CEDB in Macallan.

--
Chris Tacke, eMVP
Co-Founder and Advisory Board Member
www.OpenNETCF.org
---
Windows CE Product Manager
Applied Data Systems
www.applieddata.net


"Jamie Macleod" <(E-Mail Removed)> wrote in message
news:eU%23%(E-Mail Removed)...
> So... what will the data engine be?
>
> "Chris Tacke, eMVP" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
> > You can use eVC just fine, there's just no managed provider. The
"point"
> of
> > having it is for backward compatibility. Pocket Access as a data engine
> > will become obsolete in a future version of Pocket PC.
> >
> > --
> > Chris Tacke, eMVP
> > Co-Founder and Advisory Board Member
> > www.OpenNETCF.org
> > ---
> > Windows CE Product Manager
> > Applied Data Systems
> > www.applieddata.net
> >
> >
> > "Juan" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > If it´s not supported by .Net framework, what's the point on having
> Access
> > > databases in the Pocket PC? You can´t open them, not even
> > programatically???
> > > I don´t understand.....
> > >
> > > Peter Foot [MVP] wrote:
> > > :: Pocket Access is not supported directly by the .NET Compact
> > > :: Framework, however you can use the ADOCE control by creating a
> > > :: wrapper to handle interop with the COM control (.NETCF has no built
> > > :: in COM/ActiveX interop). We produce such a wrapper, there is an
> > > :: example of it's use in this article:-
> > > ::
> > >
> >
>
http://msdn.microsoft.com/library/de...ad10222003.asp
> > > ::
> > > :: Peter
> > > ::
> > > :: --
> > > :: Peter Foot
> > > :: Windows Embedded MVP
> > > :: OpenNETCF.org Senior Advisor
> > > :: www.inthehand.com | www.opennetcf.org
> > > ::
> > > :: "Juan" <(E-Mail Removed)> wrote in message
> > > :: news:(E-Mail Removed)...
> > > ::: Sorry, I should have looked more carefully... I already know where
> > > ::: to get ahold of SLQ CE.
> > > :::
> > > ::: But I still don´t know how to use my Access imported Databases.
> > > ::: Juan wrote:
> > > ::::: Hi everyone,
> > > :::::
> > > ::::: I am pretty new to C# developing form mobile devices. I have an
> > > ::::: Access database that I have syncronised through ActiveSync to my
> > > ::::: PocketPc. Now, using VS.NET 2003 I want to develop a simple app
> > > ::::: that retreives data from the database.
> > > :::::
> > > ::::: Is this possible at all, or do I need SQL CE server? Where can I
> > > ::::: find this server?
> > > :::::
> > > ::::: Are there any samples on how to acess an Access database?
> > > :::::
> > > ::::: Thanks, from Spain
> > >
> > >
> >
> >
>
>