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

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?
    ... PDA with problem, it works again. ... SQL Server 2005. ... 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: MS ActiveSync and Delphi
    ... What I would like to do is use a Delphi app to read the records of the SQL ... CE database and look for changed records and new ones. ... > I don't think you'll find RAPI will be useful for database synchronisation ... > as such, it will enable you to run PDA applications, test whether PDA apps ...
    (borland.public.delphi.non-technical)
Loading