RE: About ADOCE3.1 installing on PPC 2003

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Rita (Rita_at_discussions.microsoft.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 03:45:02 -0700

Hi,
install the adoce31.sa.cab that you can find in adoce31.zip (the link
http://www.pocketpcdn.com/articles/adoce_setup.html is valid)
then you need to build the adoce31.tlb file that is not included in ADOCE
3.1 SDK. You will have to extract this file from adoce31.idl file which
is included in SDK. You need to find and run midl.exe utility from DOS
command prompt window (CMD). The midl.exe utility
is located by default in:

C:\Program Files\Microsoft eMbedded C++ 4.0\EVC\wce420\bin

First you will need to copy several files into above directory so they are
in the same folder as midl.exe:

1. adoce31.idl
(from C:\Windows CE Tools\wce300\Pocket PC 2002\dataaccess31\include)
2. oaidl.idl
3. objidl.idl
4. unknwn.idl
5. wtypes.idl
(all 5 come from C:\Windows CE Tools\wce300\Pocket PC 2002\include)

then from dos command prompt window, run midl.exe:
C:\Program Files\Microsoft eMbedded C++ 4.0\EVC\wce420\bin> midl adoce31.idl

it will generate these files:
adoce31.h
adoce31.tlb
adoce31_i.c
adoce31_p.c

copy these back to yuor wince420 include directory:
C:\Program Files\Windows CE Tools\wce420\POCKET PC 2003\Include\Armv4

In Ado.h change #import to reflect location of your adoce31.tlb file.
Please note that you should have ADOCE 31 SDK, Pocket PC SDK 2002 and Pocket
PC SDK 2003 installed.

then you can use the classes that find at
http://www.codeproject.com/ce/ado_ce_ca.asp
to access database.

I think that with adoce you can access to Sql Server or MS Access database,
so you have to convert your Oracle database into Sql Server or MS Access
database and transfer it to pda with Activesync or DESKTOPTODEVICE
(programmatically from descktop).

Good luck!

"CoolStar" wrote:

> I'm a beginner , too.
> now i have to access Oracle Lite by ADOCE(EVC 4)， but i have a problem when
> install ADOCE3.1 on PPC2003 SDK. maybe adoce needs an old version SDK...
>
> Who can tell me how to install it and access Oracle Lite by ADOCE?
> the Link is not valid again.
> http://www.pocketpcdn.com/articles/adoce_setup.html
>
> thanks a lot!!!
>
> CoolStar
>
>

Relevant Pages

  • ADOCE 3.1 SDK
    ... The only possible solution Microsoft seems to offer is ADOCE 3.1 SDK which appears to be dated, will not install, and does not offer a SQLOLEDB Provider (Microsoft forces RDA here). ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: ADOCE in ASP?
    ... Not sure if the SDK not being recognized will prevent this, ... create a sample project with all the dependencies and create an install. ... > The web page and database are both located on the device. ... I need to get ADOCE running on the device so I can access the ...
    (microsoft.public.sqlserver.ce)
  • Re: ADOCE 3.1 installation error
    ... The only way I know of using ADOCE from CF application is In The Hand ADOCE ... The last SDK to include ADOCE was PPC 2002 SDK. ... Microsoft SDK for Windows CE, Handheld PC Professional Edition 3.0, ... install the WinCE SDK's to get adoce 3.1 to work in .Net CF? ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Database Problems with eVC 4
    ... PPC2002 SDK and install the ADOCE runtimes manually. ... > sure whether i can use any adoce in eVC 4. ...
    (microsoft.public.pocketpc.developer)
  • Re: How to make application work on Symbol MC3000?
    ... That's really all I had to install from Symbol. ... I can send you the SDK ... The Smart Device Application Wizard is displayed and I select Pocket ... Windows Application as the project type. ...
    (microsoft.public.dotnet.framework.compactframework)