Pull/Push data using either OracleLlite(Wireless Technology Edition) or SQL Server CE

[AKSIVAKUMAR]

Hi All, Any one is developing application using oracle lite(wireless editon) or Sql Server CE? If so,please guide me. I wanted to create always connected application using oracle light. Since it's a always connected thin client I want to push/pull data without using active sync mechanism while user on the move.. Is it psossible to develop application for pocket pc which supports GSM/GPRS connectivity? If so please provide more information in detail. Thanks in advance, Siva

[Joao Paulo Figueira]

:eek: You do understand that this is no small request? It envolves a lot of stuff that cannot be dealt with in a single reply. AKSIVAKUMAR wrote: Is it psossible to develop application for pocket pc which supports GSM/GPRS connectivity? Yes. First, you have to set up the connection in the system (bluetooth, IRDA or other). After being set up, you have to use the RAS interface. This will set up a TCP/IP connection over which you can run the sync processes. I did this with SQL CE 1.1 and it worked perfectly.

[AKSIVAKUMAR]

Hi, Yes I understood that its very hard to discuss all these stuff in a single reply. I want to send and receive data packet via RAS. I don't know how to deal with this ? Can you please give details about this?If you have any sample application please let me know and will be helpful for me. Thanks in advance. Siva

[Joao Paulo Figueira]

Siva, You don't send anything explicitly through RAS. Instead, you use RAS to set up a TCP/IP connection over which your data packects will be sent and received. Think of RAS as connecting your PDA to a TCP/IP network. When your RAS connection is active, you can use HTTP, FTP or other protocol to exchange data. Handling RAS itself is not very complex, and involves the use of the RAS* APIs and the WM_RASDIALEVENT message. This message is used as a notifier to a specific window to help monitor RAS dialing events. If you are using MFC, handle it like this:

LRESULT CDlgRas::WindowProc(UINT message, WPARAM wParam, LPARAM lParam)
{
//
// Special check for WM_RASDIALEVENT message
//
if(message == WM_RASDIALEVENT)
{
return OnRasDialEvent(wParam, lParam);
}
return CDialog::WindowProc(message, wParam, lParam);
}

Here is an outline of the sequence to dial through a RAS connection: RasEnumConnections checks if there are any open RAS connections (you can only have one). If there is a connection open, check if it is the one you want with RasGetConnectStatus. To open the RAS connection, use RasGetDialParams, followed by RasDial. In this API, use the window that will receive the WM_RASDIALEVENT messages. To close the RAS connection, use RasHangUp. If you want to read some serious discussion on how RAS works under Windows CE 3.0, read "Windows CE 3.0 Application Programming" by Nick Grattan and Marshall Brain, from Prentice Hall. Good luck!