# Re: OLEDB is possible ?

João,

Thanks I will see it now !

Marcio Camurati

João Paulo Figueira [eMVP] escreveu:

> Here:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;825393
>
> --
> João Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
> news:1130780627.097880.208590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> João,
>
> Do you say that for eVC4 is necessary a special verion of the
> ssceoledb.h, I get this file at a fix of Microsoft website because they
> didn't came If it. You mention that this especial file is commented at
> the article but I didn't found, can you help me at this point or show
> me where is mentioned at the article it.
>
> Thanx again for your helps,
>
> Marcio Camurati
>
> João Paulo Figueira [eMVP] escreveu:
>
> > Note that for eVC4, you must use a special version of the ssceoledb.h
> > file.
> > This is mentioned on the first article.
> >
> > --
> > João Paulo Figueira
> > Embedded MVP
> > http://nativemobile.blogspot.com/
> >
> > "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
> > news:1130773499.894485.40390@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > João,
> >
> > I see all code that have there, but when I try to build the project
> > NothWind it give this error message:
> >
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(13695) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(13771) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(13837) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(13847) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(13989) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(14009) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(14083) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > C:\Arquivos de programas\Windows CE
> > Tools\wce420\STANDARDSDK_420\Include\emulator\oledb.h(14161) : error
> > C2061: syntax error : identifier 'IAuthenticate'
> > Error executing cl.exe.
> >
> > NorthWind.exe - 8 error(s), 0 warning(s)
> >
> > The line is:
> >
> > /* [in] */ IAuthenticate __RPC_FAR *pAuthenticate,
> >
> > Do you have any idea about it ?
> >
> > Thanx,
> >
> > Marcio Camurati
> >
> > João Paulo Figueira [eMVP] wrote:
> > > Hi Marcio,
> > >
> > > This article (duplicated from the directory I sent you) has all the
> > > code:
> > > http://www.codeproject.com/ce/atl_ole_db_ppc.asp
> > >
> > > The atldbcli_ce.h file can be found here:
> > > http://www.codeproject.com/ce/sqlcespy.asp
> > >
> > > --
> > > João Paulo Figueira
> > > Embedded MVP
> > > http://nativemobile.blogspot.com/
> > >
> > > "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
> > > news:1130683999.795394.291900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > João,
> > >
> > > I make a search yesterday about the OLEDB and the table direct insert
> > > that you comment at your first post, but I didn't find anithing about
> > >
> > > Thanks,
> > >
> > > Marcio Camurati
> > >
> > >
> > > marciocamurati escreveu:
> > >
> > > > João,
> > > >
> > > > Cool I will see how can I make it, and if have doubts at the project I
> > > > write here, thanx!
> > > >
> > > > Marcio Camurati
> > > >
> > > > João Paulo Figueira [eMVP] escreveu:
> > > >
> > > > > You can write a DLL to do this for you and call it from .NET CF.
> > > > > This
> > > > > is
> > > > > not
> > > > > a trivial task.
> > > > >
> > > > > --
> > > > > João Paulo Figueira
> > > > > Embedded MVP
> > > > > http://nativemobile.blogspot.com/
> > > > >
> > > > > "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
> > > > > news:1130593616.889638.30260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > > > João,
> > > > >
> > > > > For complete my question and it's possible make a DLL that make this
> > > > > direct insert and use with the .Net application, or no I will have
> > > > > to
> > > > > crete another program at eVC++ to make it ?
> > > > >
> > > > > Thanx,
> > > > >
> > > > > Marcio Camurati
> > > > >
> > > > > João Paulo Figueira [eMVP] escreveu:
> > > > >
> > > > > > If you use direct table inserts, you may see speed improvements of
> > > > > > 5X
> > > > > > on
> > > > > > SQL
> > > > > > CE 2.0 when compared to parameterized and prepared INSERT
> > > > > > statements.
> > > > > >
> > > > > > You can read more about OLE DB and SQL CE 2.0 here:
> > > > > > http://www.pocketpcdn.com/articles/articles.php?&atb.set(c_id)=74&atb.perform(list_folder)=&
> > > > > >
> > > > > > --
> > > > > > João Paulo Figueira
> > > > > > Embedded MVP
> > > > > > http://nativemobile.blogspot.com/
> > > > > >
> > > > > > "marciocamurati" <marcio.camurati@xxxxxxxxx> wrote in message
> > > > > > news:1130532142.202495.63100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > > > > > > Hi,
> > > > > > >
> > > > > > > I have a doubt about the use of the OLEDB, I know that I can't
> > > > > > > use
> > > > > > > it
> > > > > > > direct at the .NET and that the use of this is in VC++, but my
> > > > > > > question
> > > > > > > is if I need to make a big insert of data at my tables the use
> > > > > > > os
> > > > > > > this
> > > > > > > connection will help me to win speed to insert ? or I will get
> > > > > > > the
> > > > > > > same
> > > > > > > speed that I have now using the .Net.
> > > > > > >
> > > > > > > Thanx,
> > > > > > >
> > > > > > > Marcio Camurati
> > > > > > >

.

## Relevant Pages

• Re: OLEDB is possible ?
... Do you say that for eVC4 is necessary a special verion of the ... > João Paulo Figueira ... > Embedded MVP ... > Marcio Camurati ...
(microsoft.public.sqlserver.ce)
• Re: OLEDB is possible ?
... > Marcio Camurati ... >> You can write a DLL to do this for you and call it from .NET CF. ... >> João Paulo Figueira ... >> Embedded MVP ...
(microsoft.public.sqlserver.ce)
• Re: Doubt if is possible with OLEDB make "Syncronization" between two SDF
... > You cannot do this with SQL CE 2.0 because it can only open one database at ... > Marcio Camurati ... >> João Paulo Figueira ... >> Embedded MVP ...
(microsoft.public.sqlserver.ce)
• Re: OLEDB is possible ?
... > Marcio Camurati ... >> You can read more about OLE DB and SQL CE 2.0 here: ... >> João Paulo Figueira ... >> Embedded MVP ...
(microsoft.public.sqlserver.ce)
• Re: OLEDB is possible ?
... Do you say that for eVC4 is necessary a special verion of the ... > Note that for eVC4, you must use a special version of the ssceoledb.h file. ... > Marcio Camurati ... >> Embedded MVP ...
(microsoft.public.sqlserver.ce)