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

Tech-Archive recommends: Fix windows errors by optimizing your registry

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?
    ... 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: using Outlook on a home network
    ... with the PDA cradled). ... the cradle, and then Microsoft on the desktop and tried ... to change the accessed file on the laptop after each ... I still can't access this .pst file in Outlook ...
    (microsoft.public.outlook)