Can I connect this device with an existing asp.net application? I need this device to scan barcodes and put them into a corresponding field in web application.
Sorry if I posted this into wrong thread,
Thanks
arnodieter wrote:
Ok that's an argument.Thanks."Laxmi Narsimha Rao Oruganti [MSFT]" <laxmi.
13-Aug-08
Ok that is an argument.
Thanks.
Previous Posts In This Thread:
On Friday, August 08, 2008 4:45 AM
arnodieter wrote:
Problem in opening connection with SQLCE3.5
I've written an application for inventory and price enquiry. The application
is written in c# using VS2008, .NetCF2.0 and SQLCE3.5. The device where the
application must run is a Symbol/Motorola MC1000 which has very poor
performance and very little memory.
Sometimes the connection doesn't open. It seems to me, that the device is
"swapping memory" and therefor needs longer than the sqlce-server aspects.
- Who can I workaround these problems?
- Why is the timeout-property of the connection read-only and defaults to
"0"?
Thanks in advance
On Monday, August 11, 2008 2:02 PM
Paul G. Tobey [eMVP] wrote:
When the connection fails to open, actually examine the exception that is
When the connection fails to open, actually examine the exception that is
thrown by the Open operation and see what that's telling you. There's no
good reason to believe, based on what you've told us, that a timeout is
happening.
If there's no memory, nothing other than using less memory is going to help.
You could dump the .NET CF and write C/C++ code using OLE DB, I think,
although I've never done that. You could try adjusting the Memory settings
on the Memory Control Panel applet for the device to give more memory to the
programs and less for storage. You could stop running some of the programs
that you have running.
There's little or not swapping going on. Windows CE does not support a
'paging' file, so no data is *ever* swapped out.
Paul T.
"arnodieter" <***@gmx.de> wrote in message news:g7h13j$isr$03$***@news.t-online.com...
On Monday, August 11, 2008 2:47 PM
Ginny Caughey MVP wrote:
Have you tried setting Connect Timeout=500 or some such in the connection
Have you tried setting Connect Timeout=500 or some such in the connection
string? Does that make any difference?
--
Ginny Caughey
Device Application Development MVP
On Tuesday, August 12, 2008 10:29 AM
Laxmi Narsimha Rao Oruganti [MSFT] wrote:
This is a multi-part message in MIME format.------=_NextPart_000_002C_01C8FCB5.
This is a multi-part message in MIME format.
------=_NextPart_000_002C_01C8FCB5.FBEAD350
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
There is no concept of ConnectTimeout and QueryTimeout with SQL CE. If =
at all they are parsed, they are parsed and ignored as these timeout =
business is when client has to wait for server's response. In case of =
SQLCE, connecting and querying is just another function call and so =
timeouts do not matter.
So we have to rule out timeout possibility. Now coming to on what and =
all could be the reason why a connectino could fail are:
1) Connection String information is wrong - SqlCeException should =
contain the exact details of what is wrong
2) Not enough memory to load all the engine in memory. Please refer to =
blog articles: (Link1, Link2)
Thanks,
Laxmi [Disclaimer: All postings are as-is and confer no rights]
"Ginny Caughey MVP" <***@wasteworks.com> wrote in =
message news:OHpsOK%23%***@TK2MSFTNGP06.phx.gbl...
connection=20
The=20
which=20
device is=20
aspects.
defaults to=20
------=_NextPart_000_002C_01C8FCB5.FBEAD350
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.5730.13" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>There is no concept of ConnectTimeout =
and=20
QueryTimeout with SQL CE. If at all they are parsed, they are =
parsed and=20
ignored as these timeout business is when client has to wait for =
server's=20
response. In case of SQLCE, connecting and querying is just =
another=20
function call and so timeouts do not matter.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>So we have to rule out timeout =
possibility. =20
Now coming to on what and all could be the reason why a connectino could =
fail=20
are:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1) Connection String information is =
wrong -=20
SqlCeException should contain the exact details of what is =
wrong</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2) Not enough memory to load all the =
engine in=20
memory. Please refer to blog articles: (<A=20
href=3D"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/trouble=
shooting-can-t-load-sqlce-dll.aspx">Link1</A>,=20
<A=20
href=3D"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-f=
ind-p-invoke-dll-sqlcemenn-dll.aspx">Link2</A>)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,<BR>Laxmi [Disclaimer: All =
postings=20
are as-is and confer no rights]<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Ginny Caughey MVP" <</FONT><A=20
href=3D"mailto:***@wasteworks.com"><FONT face=3DArial=20
size=3D2>***@wasteworks.com</FONT></A><FONT =
face=3DArial=20
size=3D2>> wrote in message </FONT><A=20
href=3D"news:OHpsOK%23%***@TK2MSFTNGP06.phx.gbl"><FONT =
face=3DArial=20
size=3D2>news:OHpsOK%23%***@TK2MSFTNGP06.phx.gbl</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> Have you tried =
setting=20
Connect Timeout=3D500 or some such in the connection <BR>> string? =
Does that=20
make any difference?<BR>> <BR>> -- <BR>> <BR>> Ginny =
Caughey<BR>>=20
Device Application Development MVP<BR>> <BR>> <BR>> =
"arnodieter"=20
<</FONT><A href=3D"mailto:***@gmx.de"><FONT face=3DArial=20
size=3D2>***@gmx.de</FONT></A><FONT face=3DArial size=3D2>> =
wrote in message=20 <BR>> </FONT><A href=3D"news:g7h13j$isr$03$***@news.t-online.com"><FONT =
face=3DArial =
size=3D2>news:g7h13j$isr$03$***@news.t-online.com</FONT></A><FONT=20
face=3DArial size=3D2>...<BR>>> I've written an application for =
inventory and=20
price enquiry. The <BR>>> application is written in c# using =
VS2008,=20
.NetCF2.0 and SQLCE3.5. The <BR>>> device where the application =
must run=20
is a Symbol/Motorola MC1000 which <BR>>> has very poor performance =
and=20
very little memory.<BR>>> Sometimes the connection doesn't open. =
It seems=20
to me, that the device is <BR>>> "swapping memory" and therefor =
needs=20
longer than the sqlce-server aspects.<BR>>> - Who can I workaround =
these=20
problems?<BR>>> - Why is the timeout-property of the connection =
read-only=20
and defaults to <BR>>> "0"?<BR>>><BR>>> Thanks in=20
advance<BR>>><BR>>> <BR>></FONT></BODY></HTML>
------=_NextPart_000_002C_01C8FCB5.FBEAD350--
On Tuesday, August 12, 2008 11:00 AM
Ginny Caughey MVP wrote:
This is a multi-part message in MIME format.------=_NextPart_000_0098_01C8FC6A.
This is a multi-part message in MIME format.
------=_NextPart_000_0098_01C8FC6A.9449B310
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks for the details, Laxmi!
--=20
Ginny Caughey
Device Application Development MVP
"Laxmi Narsimha Rao Oruganti [MSFT]" <***@msnews.com> wrote =
in message news:eAD6nfI$***@TK2MSFTNGP03.phx.gbl...
There is no concept of ConnectTimeout and QueryTimeout with SQL CE. =
If at all they are parsed, they are parsed and ignored as these timeout =
business is when client has to wait for server's response. In case of =
SQLCE, connecting and querying is just another function call and so =
timeouts do not matter.
So we have to rule out timeout possibility. Now coming to on what and =
all could be the reason why a connectino could fail are:
1) Connection String information is wrong - SqlCeException should =
contain the exact details of what is wrong
2) Not enough memory to load all the engine in memory. Please refer =
to blog articles: (Link1, Link2)
Thanks,
Laxmi [Disclaimer: All postings are as-is and confer no rights]
------=_NextPart_000_0098_01C8FC6A.9449B310
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6001.18063" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Thanks for the details, =
Laxmi!</FONT></DIV>
<DIV><BR>-- <BR><BR>Ginny Caughey<BR>Device Application Development =
MVP</DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Laxmi Narsimha Rao Oruganti [MSFT]" <<A=20
=
href=3D"mailto:***@msnews.com">***@msnews.com</A>> =
wrote in=20
message <A=20
=
href=3D"news:eAD6nfI$***@TK2MSFTNGP03.phx.gbl">news:eAD6nfI$IHA.3756=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>There is no concept of ConnectTimeout =
and=20
QueryTimeout with SQL CE. If at all they are parsed, they are =
parsed and=20
ignored as these timeout business is when client has to wait for =
server's=20
response. In case of SQLCE, connecting and querying is just =
another=20
function call and so timeouts do not matter.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>So we have to rule out timeout =
possibility. =20
Now coming to on what and all could be the reason why a connectino =
could fail=20
are:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1) Connection String information is =
wrong -=20
SqlCeException should contain the exact details of what is =
wrong</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2) Not enough memory to load all the =
engine in=20
memory. Please refer to blog articles: (<A=20
=
href=3D"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/trouble=
shooting-can-t-load-sqlce-dll.aspx">Link1</A>,=20
<A=20
=
href=3D"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-f=
ind-p-invoke-dll-sqlcemenn-dll.aspx">Link2</A>)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,<BR>Laxmi [Disclaimer: =
All postings=20
are as-is and confer no =
rights]<BR></FONT></DIV></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_0098_01C8FC6A.9449B310--
On Wednesday, August 13, 2008 2:48 AM
arnodieter wrote:
Re: Problem in opening connection with SQLCE3.5
Hello Ginny.
As you should remember: timeout property is readonly...
On Wednesday, August 13, 2008 2:52 AM
arnodieter wrote:
This is a multi-part message in MIME format.------=_NextPart_000_003A_01C8FD21.
This is a multi-part message in MIME format.
------=_NextPart_000_003A_01C8FD21.FC2E73F0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks for the tips.
The solution was 2) Not enough memory. I've installed an additional =
memory card and the application is also installed on the memory card. =
Now the problem is solved.
But I'm still wondering why there isn't a useful error message from the =
.NETCF or the SQLCE and why the error occured only sometimes.
Regards
"Laxmi Narsimha Rao Oruganti [MSFT]" <***@msnews.com> schrieb =
im Newsbeitrag news:eAD6nfI$***@TK2MSFTNGP03.phx.gbl...
There is no concept of ConnectTimeout and QueryTimeout with SQL CE. =
If at all they are parsed, they are parsed and ignored as these timeout =
business is when client has to wait for server's response. In case of =
SQLCE, connecting and querying is just another function call and so =
timeouts do not matter.
So we have to rule out timeout possibility. Now coming to on what and =
all could be the reason why a connectino could fail are:
1) Connection String information is wrong - SqlCeException should =
contain the exact details of what is wrong
2) Not enough memory to load all the engine in memory. Please refer =
to blog articles: (Link1, Link2)
Thanks,
Laxmi [Disclaimer: All postings are as-is and confer no rights]
Have you tried setting Connect Timeout=3D500 or some such in the =
connection=20
string? Does that make any difference?
=20
--=20
=20
Ginny Caughey
Device Application Development MVP
=20
=20
I've written an application for inventory and price enquiry. The=20
application is written in c# using VS2008, .NetCF2.0 and SQLCE3.5. =
The=20
device where the application must run is a Symbol/Motorola MC1000 =
which=20
has very poor performance and very little memory.
Sometimes the connection doesn't open. It seems to me, that the =
device is=20
"swapping memory" and therefor needs longer than the sqlce-server =
aspects.
- Who can I workaround these problems?
- Why is the timeout-property of the connection read-only and =
defaults to=20
------=_NextPart_000_003A_01C8FD21.FC2E73F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16674" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Thanks for the tips.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>The solution was 2) Not enough memory. =
I've=20
installed an additional memory card and the application is also =
installed on the=20
memory card. Now the problem is solved.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But I'm still wondering why there isn't =
a useful=20
error message from the .NETCF or the SQLCE and why the error occured =
only=20
sometimes.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Laxmi Narsimha Rao Oruganti [MSFT]" <<A=20
=
href=3D"mailto:***@msnews.com">***@msnews.com</A>> =
schrieb=20
im Newsbeitrag <A=20
=
href=3D"news:eAD6nfI$***@TK2MSFTNGP03.phx.gbl">news:eAD6nfI$IHA.3756=
@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>There is no concept of ConnectTimeout =
and=20
QueryTimeout with SQL CE. If at all they are parsed, they are =
parsed and=20
ignored as these timeout business is when client has to wait for =
server's=20
response. In case of SQLCE, connecting and querying is just =
another=20
function call and so timeouts do not matter.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>So we have to rule out timeout =
possibility. =20
Now coming to on what and all could be the reason why a connectino =
could fail=20
are:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>1) Connection String information is =
wrong -=20
SqlCeException should contain the exact details of what is =
wrong</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2) Not enough memory to load all the =
engine in=20
memory. Please refer to blog articles: (<A=20
=
href=3D"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/trouble=
shooting-can-t-load-sqlce-dll.aspx">Link1</A>,=20
<A=20
=
href=3D"http://blogs.msdn.com/sqlservercompact/archive/2007/10/26/can-t-f=
ind-p-invoke-dll-sqlcemenn-dll.aspx">Link2</A>)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,<BR>Laxmi [Disclaimer: =
All postings=20
are as-is and confer no rights]<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>"Ginny Caughey MVP" <</FONT><A=20
href=3D"mailto:***@wasteworks.com"><FONT face=3DArial =
size=3D2>***@wasteworks.com</FONT></A><FONT =
face=3DArial=20
size=3D2>> wrote in message </FONT><A=20
href=3D"news:OHpsOK%23%***@TK2MSFTNGP06.phx.gbl"><FONT =
face=3DArial=20
=
size=3D2>news:OHpsOK%23%***@TK2MSFTNGP06.phx.gbl</FONT></A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
Have you tried=20
setting Connect Timeout=3D500 or some such in the connection <BR>> =
string?=20
Does that make any difference?<BR>> <BR>> -- <BR>> <BR>> =
Ginny=20
Caughey<BR>> Device Application Development MVP<BR>> <BR>> = <BR>>=20
"arnodieter" <</FONT><A href=3D"mailto:***@gmx.de"><FONT =
face=3DArial=20
size=3D2>***@gmx.de</FONT></A><FONT face=3DArial size=3D2>> =
wrote in=20
message <BR>> </FONT><A =
href=3D"news:g7h13j$isr$03$***@news.t-online.com"><FONT=20
face=3DArial =
size=3D2>news:g7h13j$isr$03$***@news.t-online.com</FONT></A><FONT=20
face=3DArial size=3D2>...<BR>>> I've written an application for =
inventory=20
and price enquiry. The <BR>>> application is written in c# using =
VS2008,=20
.NetCF2.0 and SQLCE3.5. The <BR>>> device where the application =
must run=20
is a Symbol/Motorola MC1000 which <BR>>> has very poor =
performance and=20
very little memory.<BR>>> Sometimes the connection doesn't open. =
It=20
seems to me, that the device is <BR>>> "swapping memory" and =
therefor=20
needs longer than the sqlce-server aspects.<BR>>> - Who can I =
workaround=20
these problems?<BR>>> - Why is the timeout-property of the =
connection=20
read-only and defaults to <BR>>> "0"?<BR>>><BR>>> =
Thanks in=20
advance<BR>>><BR>>> <BR>></FONT> =
</BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_003A_01C8FD21.FC2E73F0--
On Wednesday, August 13, 2008 2:55 AM
arnodieter wrote:
The question why there is a timeout property which is readonly and defaults to
The question why there is a timeout property which is readonly and defaults
to 0 is still not answered!?
Kind regards
"arnodieter" <***@gmx.de> schrieb im Newsbeitrag
On Wednesday, August 13, 2008 7:59 AM
Laxmi Narsimha Rao Oruganti [MSFT] wrote:
Oh well, I thought I answered it implicitly in my reply.
Oh well, I thought I answered it implicitly in my reply. Anyways, it is
there just for ADO.NET Compliance and nothing more. Since everyone derives
from Db* base classes and ConnectTimeout is abstract virtual, we had to
override to compile the code. We did it and also made sure to avoid
applications depending on it by returning zero. Let us not debate on why it
should not have been throwing an exception than zero.
Thanks,
Laxmi
"arnodieter" <***@gmx.de> wrote in message news:g7u0gh$gsg$03$***@news.t-online.com...
On Wednesday, August 13, 2008 10:16 AM
arnodieter wrote:
Ok that's an argument.Thanks."Laxmi Narsimha Rao Oruganti [MSFT]" <laxmi.
Ok that is an argument.
Thanks.
Submitted via EggHeadCafe - Software Developer Portal of Choice
.NET Remoting - Marshal Objects ByRef
http://www.eggheadcafe.com/tutorials/aspnet/8895ea1a-5606-4775-b030-2743e473b8ac/net-remoting--marshal-o.aspx