Re: Micosoft Contradiction regarding ADOCE and C++

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Troy (tarnestad_at_hotmail.com)
Date: 08/07/04


Date: Sat, 07 Aug 2004 15:08:23 GMT

Well, it just really means that adoce support for C++ really blows. I
mean they initially want you to use a set of wrapper classes from
virtual office systems which I used in my first couple of programs. It
got the job done, but since I was going up against pocket access and all
its limitations, (i.e. no sum, count, unique statements). I really
hated it. I would however whole heartedly recommend the classes from
Joao Figueira. His classes made the switch for me over to SQL Server CE
easy, and the wrapper just feels very well made. The classes can be
found at:

http://www.codeproject.com/ce/ado_ce_ca.asp

The line you will be looking in the class to set it to whatever database
your are using is:

provider=MyDataProvider;data source=\\name_of_data_base.???

for example
provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;data source=\\db.sdf

Hope this helps!

Troy

PKNET wrote:
> Microsoft is clearly contradicting itself with regards to using ADOCE in C++.
>
> On the one hand, Microsoft claims ADOCE is only supported when called from
> Visual Basic for Windows CE.
>
> On the other hand, Microsoft is providing MSDN support on how to implement
> ADOCE from a pure C++ application with example code.
>
> Which is the truth?
>
> We desire to use ADOCE from a Windows CE 4.x device in conjuction with a
> third party OLE DB provider (as suggested by Microsoft) to communicate to a
> REMOTE (non-local) SQL Server from a native C/C++ WinCE 4.x application.
> There are several hurdles to overcome. For instance, how to install ADOCE to
> the CE device and how to call ADOCE from C++. In additon, why does Microsoft
> force us to license a third party OLE DB provider -- why doen't Microsoft
> provide its own version or purchase the technology from Oddessy (ViaDB).
> Bill Gates is well aware of this company and has recommended it as a source
> for COM based software. Oddessy wants big bucks per unit to license the OLE
> DB provider and has a lock on the market.
>
> Below is is the evidence of Microsoft's contradictory stance on using ADOCE
> with C++.
>
> "The Microsoft ActiveX Data Objects (ADO) for Windows CE 3.1 (ADOCE)
> database technology is currently only supported when called from Visual Basic
> for Windows CE."
> http://support.microsoft.com/default.aspx?scid=kb;en-us;296395
>
> Using ADOCE with Pure C++…
> "Pocket PC devices come preloaded with ADOCE (Active Data Objects for the
> Windows® CE operating system). This enables applications developers targeting
> the Pocket PC to take advantage of a powerful database language that is well
> established, well documented, and very robust. This article will show you how
> to access ADOCE from a C++ application."
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppc2k/html/ppc_eplus.asp
>
> Now, I don't care if the ADOCE is an undocumented or not supported C++
> feature. I just want to know that it is possible and how to implement it to
> achieve the result I outlined above.
>
> Any addition help or information in clearing up this issue is greatly
> appreciated.
>
> Thanks in advance....
>



Relevant Pages

  • Re: SQLCE + ADOCE using EVC++
    ... Microsoft means you are on your own. ... If you are doing native code development, try OLE DB. ... This is a safer path than ADOCE. ... > not "support" ADOCE from EVC++, or because it really does not work right? ...
    (microsoft.public.sqlserver.ce)
  • Re: AS4 and Pocket Access
    ... Microsoft has dropped ADOCE. ... that ActiveSync converted Access tables into Pocket Acess format. ... >I know that synchronization between PPC and Desktop is no longer supported ... >MS drop support of Pocket Access altogether? ...
    (microsoft.public.pocketpc.activesync)
  • Re: Micosoft Contradiction regarding ADOCE and C++
    ... but them MS makes a breaking change through a QFE or some such then ... Microsoft claims ADOCE is only supported when called from ... Microsoft is providing MSDN support on how to implement ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: ADOCE on PPC 2003 in EVC++ 4.0
    ... If ADOCE is not supported in EVC++ then what is an alternative? ... > I understand that Microsoft doesnt support ADOCE 3.1 for EVC++ 4.0. ... > Microsoft not encourage EVC++ environment for database application under ...
    (microsoft.public.sqlserver.ce)
  • Re: Micosoft Contradiction regarding ADOCE and C++
    ... > having difficulty in finding answers with regards to WinCE 4.x with ADOCE ... > Microsoft to call stored procedures. ... > Windows CE devices to connect to the huge number of existing SQL Server ... > installations via ADO and an OLE DB provider. ...
    (microsoft.public.windowsce.embedded.vc)