Re: Is RAPI the only way for sync data in my situation?

I am using VS 2003 and the file is under
C:\Program Files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows CE\wce400\armv4

What is the SQLException's message? Can you post here?

Sometime I got the SQLException with "General network error. Check your
network documentation". But my other 2 PDA work fine. I soft reset the
PDA with problem, it works again.

goodluck
-rockdale
dotnetfellow@xxxxxxxxx wrote:
Hi Ginny,

I am suffering from similar problem. Only, I can't find a file on my
computer called sql.wce4.armv4.CAB.

I have Intermec 751g Barcode Scanner with Windows CE 4.2, and .NET 2.0
Compact Framework SP1 and patch

Computer is Visual Studio 2005, SQL Server 2005. The error is
SqlException and error occurred on ConnectionOpen operation.

Any ideas? Thanks.




Sincerely, Dotnet Fellow


Ginny Caughey [MVP] wrote:
Visual Studio should deploy the dependent DLLs you need, so I'm not sure why
that didn't happen.

It should work the way you want now, but test, test, test to be sure.

--
Ginny Caughey
Device Application Development MVP


"rockdale" <rockdale.green@xxxxxxxxx> wrote in message
news:1155654859.572985.103810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Oh, how stupid am I.

It turns out that I have to copy sql.wce4.armv4.CAB and
sqlce.wce4.armv4.CAB to the pda and click to install them. Now I have
no missingmethodexception problems. Should not it auto-installed if I
include System.data.sqlserverCe and system.data.sqlclient in my project
and deploy it? I did not remember I copied those files for my working
PDA, maybe it was long time ago and I can not remember.

Now it is works and as you are saying that as long as there is an valid
ip address I should always connection to the SQL database on the
laptop, right, then I will keep working on read/write SQL directly
through Cradle.

Thanks for your help
-Rockdale






Ginny Caughey [MVP] wrote:
I'm not sure why your non-working PDA doesn't have the right DLLs, but I
think it would give you the same (or different) problems no matter which
approach you use. I'd suggest trying to manually get it to the right
version
of the Compact Framework - apparently a service pack difference.
Generally
you want to use the newest version of the Compact Framework that the
hardware will support.

--
Ginny Caughey
Device Application Development MVP


"rockdale" <rockdale.green@xxxxxxxxx> wrote in message
news:1155652721.237524.112840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I included in my code System.Data.SqlClient. When I deploy the
application I also see this dll get copied (But I cannot find out where
it is copied to).
Also this whole application is running perfect on my another PDA.

I just found out that I got missingmethodexception error on my SQLCE
Connection also. looks like this PDA misses all the dll. The .NET
compact Framework is [1.0.4292.00] on this mot-working PDA. The .NET
compact Framework on the working PDA is lower [1.0.2268.00]

Did I miss something before I deployee the application? Looks like it
does not find the correct dll or something.

Thanks a lot

I need to make the decision between connecting to SQL or using RAPI
from laptop to invoke pda to export data and load into SQL.
-rockdale



Ginny Caughey [MVP] wrote:
Yes it sounds like you didn't include a reference to
System.Data.SqlClient.

--
Ginny Caughey
Device Application Development MVP


"rockdale" <rockdale.green@xxxxxxxxx> wrote in message
news:1155649209.008074.277200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi, Ginny

Thanks for your reply.
Further debug on the not working PDA shows that
MissingMethodException
is catched when try to open SQLConnection to my laptop.

SqlConnection dbConn = new SqlConnection();

try{
dbConn.ConnectionString = ConnectionString;
dbConn.Open();
}
catch(ArgumentException ae)
{
MessageBox.Show (ae.Message ,"ArgumentException" );
}
catch(InvalidOperationException ioe)
{
MessageBox.Show (ioe.Message ,"InvalidOperationException");
}
catch(SqlException se)
{
MessageBox.Show (se.Message ,"SQLException");
}
catch(MissingMethodException mme)
{
MessageBox.Show (mme.Message ,"MissingMethodException");
}

Did I miss a DLL or something?


Ginny Caughey [MVP] wrote:
As long as you have the valid IP address, you should be able to use
SqlClient from the device to connect to SQL Server on the desktop.
Where
this becomes unreliable is in situations where the IP address might
not
always be there - which is often the case in industrial settings.
If
your
device will be in the cradle I don't see why that shouldn't be a
usable
solution, but of course it's always a good idea to do a little test
to
make
sure it will work as you want.

--
Ginny Caughey
Device Application Development MVP


"rockdale" <rockdale.green@xxxxxxxxx> wrote in message
news:1155588789.670168.187940@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

We have an PDA Application which does data collection and store
in
SQL
CE. Also, We have another application which runs on laptop
against
sql
database. We need to sync data between these two database,
basically,
download lookup information from laptop SQL and upload data
collected
by PDA to laptop SQL.

The laptop has a verizon wireless connection but it is blocked to
access internet.
PDA connected to laptop through cradle.
PDA cannot connect to laptop through WI-FI connection. (Maybe
because
WI-FI is different from Verizon Wireless? I am not so sure why)

web service is out because they block the laptop for accessing
internet
I was using read/write tolaptop SQL database directly but some
PDA
model can not connect to the SQL database. (I was using HP iPAQ
h4150
(windows CE 4.20) which works fine, but HP iPAQ hx2790b(Windows
CE
5.0)
cannot connect to the database, ) End user may use Palm Treo
700w
or
something else also.

I kind like the idea of read /write SQL Database on laptop from
PDA.
It
is clean and it is less work. But given that it is not stable, I
think
I need another approace to achieve this data sync function.

Does somebody knows why certain model cannot connect to SQL
database
on
a laptop, I know that as long as the laptop has an valid IP
address,
the PDA should be able to connect to its database. I had this
post
<a href=
http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_thread/thread/cf9785dfe427d787/f308aea8cc2a8232?lnk=gst&q=rockdale&rnum=1#f308aea8cc2a8232>Exchange
Data between SQLCE and SQL database on laptop?

</a>
a long time ago and Ginny clearified my question. If the
unstability
is
unavoidable, it RAPI my only choice?

Thanks in advance





.

Relevant Pages

  • Re: Is RAPI the only way for sync data in my situation?
    ... SQL Server 2005. ... PDA, maybe it was long time ago and I can not remember. ... from laptop to invoke pda to export data and load into SQL. ... I was using read/write tolaptop SQL database directly but some ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Is RAPI the only way for sync data in my situation?
    ... PDA, maybe it was long time ago and I can not remember. ... laptop, right, then I will keep working on read/write SQL directly ... from laptop to invoke pda to export data and load into SQL. ... I was using read/write tolaptop SQL database directly but some ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Is RAPI the only way for sync data in my situation?
    ... Also this whole application is running perfect on my another PDA. ... I need to make the decision between connecting to SQL or using RAPI ... from laptop to invoke pda to export data and load into SQL. ... I was using read/write tolaptop SQL database directly but some PDA ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Is RAPI the only way for sync data in my situation?
    ... Further debug on the not working PDA shows that MissingMethodException ... Ginny Caughey wrote: ... We have another application which runs on laptop against sql ... I was using read/write tolaptop SQL database directly but some PDA ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Is RAPI the only way for sync data in my situation?
    ... I'm not sure why your non-working PDA doesn't have the right DLLs, ... I need to make the decision between connecting to SQL or using RAPI ... from laptop to invoke pda to export data and load into SQL. ... I was using read/write tolaptop SQL database directly but some PDA ...
    (microsoft.public.dotnet.framework.compactframework)
Loading