HPC 2000 ( Siemens SIMpad SL4 ) and ADOCE problems

Joao,

I don't know the exact solution for your problem, but I believe that you
need to use 'ADOCE.Connection.3.1' instead of  'ADOCE.Connection.3.0' to get
a correct class ID (I'm not sure about ADOCE 3 connected to SSCE provider,
but with ADOCE 3.1 I'm sure). And more: you need to install/register ADOCE
3.1 runtimes (dlls) first.

Baccarin.

"Joao Patrao" <joao_pat @yahoo.com> escreveu na mensagem



    //debug ------------------------------­------------------------------­----
//----------------------------­------------------------------­-------------
< >...

Code samples can be found in the Books On Line for SQLCE or in the eVC
samples in your installation Samples directory. Load up the eVC sample.

Brad
bra @microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

< >...

Hi Joao,

ADOCE is not supported with eVC. Only OLEDB is supported with eVC. You can
use ADOCE with eVB.

Brad
bra @microsoft.com
This posting is provided "AS IS" with no warranties, and confers no rights.

Brad,
this is the piece of code that fails, in the CoCreateInstance...

(...)
  //debug
   HRESULT hr;
   CLSID  g_ClsID;  
   hr = CLSIDFromProgID(TEXT("ADOCE.Co­nnection.3.0"), &g_ClsID);    

   op_res = CoCreateInstance( g_ClsID /*CLSID_ADOCEConnection*/, NULL,
  CLSCTX_INPROC_SERVER, IID_IADOCEConnection, (void **)&m_conn);
   if (FAILED(op_res)) {
        //debug ------------------------------­-------------------------
                MessageBox(NULL,_T("OTGConnect­ion_Open failed to create
instance!"),_T("OTGDLL"),NULL)­;
        //----------------------------­------------------------------­---
    return FALSE;
  }

  _stprintf(conn_str,
_T("Provider=Microsoft.SQLServ­er.OLEDB.CE.1.0;Data Source=%s"),
pDBFile);
  op_res = m_conn->Open(conn_str, _T(""), _T(""),0);
  if (FAILED(op_res)) {
     //debug ------------------------------­------------------------------­----
        MessageBox(NULL,_T("OTGConnect­ion_Open failed to create data
source!"),_T("DLL"),NULL);
    //----------------------------­------------------------------­-------------

(...)

Can anyone provide me with one example code that i can try?
Thanks in advance
Joao

"Brad Syputa - MS" <bra @Foo.Microsoft.com> wrote in message < >...

Hi Brad

How can i use OLEDB with eVC and HPC2000 ?

Where can i find some code example that shows me how to connect to a
database ( sdf file) and populate a recordset with the result of the
query?

Thanks for your help
Joao

"Brad Syputa - MS" <bra @Foo.Microsoft.com> wrote in message < >...