RAPI and SQL CE Server

[Boas Enkler]

Hi There

is it possible to realize selects inserts updates and deletes via RAPI?
Unfortunately i can't find any samples for this

can anyone help?

thx

 

[Ginny Caughey [MVP]]

Boas,

No it isn't, sorry. Use merge replication or RDA instead of Rapi to move
data to/from the device.

Ginny Caughey
..NET Compact Framework MVP

 

[Ilya Tumanov [MS]]

I suppose you can create custom native DLL to be called via CeRapiInvoke(),
but this is not trivial.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

 

[Boas Enkler]

Thanx for your answer

What would be the best way to synchronize a PDA with an PC ?
I've some data in Tables, XML etc.. which have to be synchronized with the
PDA Software

 

[Ilya Tumanov [MS]]

There's no "one fits all" solution. You should choose whatever's best suited
for your needs.

For example, if your data is stored in SQL Sever 2000 on the desktop side,
your best bet would be SQL CE replication.

If it's something else, you might use Web Service as a proxy between your
desktop database and devices.

Or, if you're dealing with small amount of data, you might be able to get
away with moving XML/CSV files around.


Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

 

[Alex Feinman [MVP]]

Take a look at the tools like this:
http://www.gui-innovations.com/html/remotesqlce.html
and this:
http://www.primeworks.pt/site/en/home_fs.htm

 

[João Paulo Figueira [eMVP]]

Hi Alex,
Nice to see someone I admire noting my work. Most of the products I wrote
actually use a RAPI server to remotely access SQL CE. The connecting
components at both ends are written in native code for a number of reasons:
- There is no way to write a RAPI server in .NET CF 1.0
- Native code allows to access the lower level OLE DB interfaces of SQL CE.
One of the benefits to reap are fast inserts. Another benefit is the access
to low-level schema info.

The nice thing about this is that you can actually use all of this from
managed code. The last product I wrote (SQL CE Console) is actually a .NET
desktop application that uses the RAPI (and TCP/IP) communication
infrastructure to access a SQL CE 2.0 database from the desktop. There is a
C# assembly that can be used (DesktopSqlCe) and I'm actually looking for
testing users. Contributions are paid with a free license. Anyone?

 

[info]

Hi There
sounds really intresting.
If it would be free for my software i'd love to test it. perhaps we
could mail about this

 

[João Paulo Figueira [eMVP]]

Mail me:
joao dot figueira at primeworks dot pt

--
João Paulo Figueira
Embedded MVP
http://nativemobile.blogspot.com/

Hi There
sounds really intresting.
If it would be free for my software i'd love to test it. perhaps we
could mail about this

 

[Sachin]

Thanks for your tips about various ways to synch PPC with PC. I have
Dbase as database on PC, so I probably need to rely on webservice
option.

What I want to know is that can I use webserive using a wi-fi
connection with PC or via activesync or both?

If I want to support both, is there any difference for me in setting up
webservice?

Thanks for your help.

 

[Arun]

No additional settings required to work with both WiFi and AS.

Cheers,
Arun.
www.innasite.com