|
Home > Archive > MS SQLCE > October 2005 > OLEDB is possible ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
OLEDB is possible ?
|
|
| marciocamurati 2005-10-28, 8:23 pm |
| 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
| |
| Joćo Paulo Figueira [eMVP] 2005-10-29, 3:23 am |
| 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/...es.php?&atb.set(c_id)=74&atb. perform(list_folder)
=&
--
Joćo Paulo Figueira
Embedded MVP
http://nativemobile.blogspot.com/
"marciocamurati" <marcio.camurati@gmail.com> wrote in message
news:1130532142.202495.63100@g43g2000cwa.googlegroups.com...
> 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
>
| |
| marciocamurati 2005-10-29, 9:23 am |
| Jo=E3o,
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=E3o 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/...es.php?&atb.set(c_id)=3D74&atb.p=
erform(list_folder)=
3D&[color=darkred]
>
> --
> Jo=E3o Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@gmail.com> wrote in message
> news:1130532142.202495.63100@g43g2000cwa.googlegroups.com...
| |
| Joćo Paulo Figueira [eMVP] 2005-10-29, 11:23 am |
| 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@gmail.com> wrote in message
news:1130593616.889638.30260@g49g2000cwa.googlegroups.com...
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:
[color=darkred]
> 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/...es.php?&atb.set(c_id)=74&atb. perform(list_folder)
=&
>
> --
> Joćo Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@gmail.com> wrote in message
> news:1130532142.202495.63100@g43g2000cwa.googlegroups.com...
| |
| marciocamurati 2005-10-29, 11:23 am |
| Jo=E3o,
Cool I will see how can I make it, and if have doubts at the project I
write here, thanx!
Marcio Camurati
Jo=E3o Paulo Figueira [eMVP] escreveu:
> You can write a DLL to do this for you and call it from .NET CF. This is =
not[color=darkred]
> a trivial task.
>
> --
> Jo=E3o Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@gmail.com> wrote in message
> news:1130593616.889638.30260@g49g2000cwa.googlegroups.com...
> Jo=E3o,
>
> 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=E3o Paulo Figueira [eMVP] escreveu:
>
.. perform(list_folder)
=3D&[color=darkred]
on[color=darkred]
me[color=darkred]
| |
| marciocamurati 2005-10-30, 9:23 am |
| Jo=E3o,
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
it, do you have material about this table direct insert ?
Thanks,
Marcio Camurati
marciocamurati escreveu:
[color=darkred]
> Jo=E3o,
>
> Cool I will see how can I make it, and if have doubts at the project I
> write here, thanx!
>
> Marcio Camurati
>
> Jo=E3o Paulo Figueira [eMVP] escreveu:
>
s not[color=darkred]
on[color=darkred]
tb. perform(list_folder)
=3D&[color=darkred]
it[color=darkred]
tion[color=darkred]
his[color=darkred]
same[color=darkred]
| |
| Joćo Paulo Figueira [eMVP] 2005-10-31, 7:23 am |
| 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@gmail.com> wrote in message
news:1130683999.795394.291900@g49g2000cwa.googlegroups.com...
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
it, do you have material about this table direct insert ?
Thanks,
Marcio Camurati
marciocamurati escreveu:
[color=darkred]
> 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:
>
| |
| marciocamurati 2005-10-31, 11:23 am |
| Jo=E3o,
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\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13695) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13771) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13837) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13847) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13989) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14009) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14083) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\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=E3o Paulo Figueira [eMVP] wrote:[color=darkred
]
> 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=E3o Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@gmail.com> wrote in message
> news:1130683999.795394.291900@g49g2000cwa.googlegroups.com...
> Jo=E3o,
>
> 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
> it, do you have material about this table direct insert ?
>
> Thanks,
>
> Marcio Camurati
>
>
> marciocamurati escreveu:
>
is[color=darkred]
5X[color=darkred]
s=2E[color=darkred]
&atb. perform(list_folder)
=3D&[color=darkred]
| |
| Joćo Paulo Figueira [eMVP] 2005-10-31, 11:23 am |
| 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@gmail.com> wrote in message
news:1130773499.894485.40390@g14g2000cwa.googlegroups.com...
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\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13695) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13771) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13837) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13847) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13989) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14009) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14083) : error
C2061: syntax error : identifier 'IAuthenticate'
C:\Arquivos de programas\Windows CE
Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\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:[color=darkred
]
> 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@gmail.com> wrote in message
> news:1130683999.795394.291900@g49g2000cwa.googlegroups.com...
> 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
> it, do you have material about this table direct insert ?
>
> Thanks,
>
> Marcio Camurati
>
>
> marciocamurati escreveu:
>
| |
| marciocamurati 2005-10-31, 1:23 pm |
| Jo=E3o,
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=E3o Paulo Figueira [eMVP] escreveu:
> Note that for eVC4, you must use a special version of the ssceoledb.h fil=
e=2E[color=darkred]
> This is mentioned on the first article.
>
> --
> Jo=E3o Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@gmail.com> wrote in message
> news:1130773499.894485.40390@g14g2000cwa.googlegroups.com...
> Jo=E3o,
>
> 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\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13695) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13771) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13837) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13847) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13989) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14009) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14083) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\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=E3o Paulo Figueira [eMVP] wrote:
e:[color=darkred]
is[color=darkred]
to[color=darkred]
74&atb. perform(list_folder)
=3D&[color=darkred]
use[color=darkred]
os[color=darkred]
the[color=darkred]
| |
| Joćo Paulo Figueira [eMVP] 2005-10-31, 1:23 pm |
| Here:
http://support.microsoft.com/defaul...kb;en-us;825393
--
Joćo Paulo Figueira
Embedded MVP
http://nativemobile.blogspot.com/
"marciocamurati" <marcio.camurati@gmail.com> wrote in message
news:1130780627.097880.208590@g44g2000cwa.googlegroups.com...
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:
[color=darkred]
> 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@gmail.com> wrote in message
> news:1130773499.894485.40390@g14g2000cwa.googlegroups.com...
> 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\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13695) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13771) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13837) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13847) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(13989) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14009) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\oledb.h(14083) : error
> C2061: syntax error : identifier 'IAuthenticate'
> C:\Arquivos de programas\Windows CE
> Tools\wce420\STANDAR
DSDK_420\Include\emu
lator\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:
| |
| marciocamurati 2005-10-31, 1:23 pm |
| Jo=E3o,
Thanks I will see it now !
Marcio Camurati
Jo=E3o Paulo Figueira [eMVP] escreveu:
[color=darkred]
> Here:
> http://support.microsoft.com/defaul...kb;en-us;825393
>
> --
> Jo=E3o Paulo Figueira
> Embedded MVP
> http://nativemobile.blogspot.com/
>
> "marciocamurati" <marcio.camurati@gmail.com> wrote in message
> news:1130780627.097880.208590@g44g2000cwa.googlegroups.com...
> Jo=E3o,
>
> 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=E3o Paulo Figueira [eMVP] escreveu:
>
t I[color=darkred]
his[color=darkred]
of[color=darkred]
=3D74&atb. perform(list_folder)
=3D&[color=darkred]
|
|
|
|
|