I want to synchronize my database on Pocket PC / The Emulator that use WM5 and SQLCE3, but the synchronize is doesn't use IIS as the bridge, but i want to use ActiveSync as the synchronizer bridge. The rule like this.
1. Have database on Pocket PC.
2. Have application on Desktop PC.
3. When device or emulater placed on cradle, then the database automaticaly synchronized with database server on desktop pc.
Why I want to use ActiveSync as synchronizer.
1. I have the Pocket PC cradle. So my device can synchronized using ActiveSync.
2. I have internet connection on Desktop PC. So why i must pay more for GPRS if i only need to synchronize my device with my desktop pc.
Thanks.
Synchronize SQL Mobile 2005 using ActiveSync
Hot Topic
- Oracle replication failed
- Transactional replication can not complete distributing and retry from first again
- writing planned values back to the cube
- SQL Server 2005 Remote Connection Problem... Big Time.
- Moving DB one server to another with Broker Enabled
- Get Minimum day in a continuous series
- Bug? No WSDL information fo a WEBMETHOD that points to a table-value function
- Feedback Requested - What Content Do You Want to see for SQL Server Express?
- Maximum Size of OPENXML IN SP
- No support for SQL Server Authentication and SSIS !!!!
SQL Server
- SQL 2000 Merge Replication Error
- calculate maximum value of childrecords in a trigger?
- Viewing the edited and original measure values in a write enabled cube
- Database Mirroring is not working at all in RTM
- SQL 2000 stops to increment @cpu_busy value, sp_monitor does not work anymore
- Question Regarding Job Schedules
- Str() not locale aware
- new column from user defined function
- How to retrieve data from query and link the data to a data number?
- Script Component task, values such as "000-00-00" to smalldatetime field
Synchronize SQL Mobile 2005 using ActiveSync
Jim Palik
Ok I hope I now got your point. You can configure your device to communicate over Active Sync for accessing internet rather than through GPRS. For this you need to do the following on the device,
1) Start Menu ==> Settings ==> Connections Tab/Pane
2) Click Connections icon, switch to 'Advanced' tab/pane
3) Choose Select Networks...
4) Check for "Programs that automatically connect to the Internet should connect using:" label, and choose 'My Work Network' in the drop-down box. Click OK.
Let me know if you need further information.
Please also note in this case also that you are choosing a different medium to communicate to internet, you still need IIS to use Merge Replication/RDA or synchronization.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
BrianT
Well we know that we can set the syncing on desktop by set something on IIS. So if we want to syncing the database from Pocket PC to Desktop we must use internet as connector because we only set configuration for IIS.
If your suggest for me is to create an application that plugged on ActiveSync, where I can find reference for doing this
Thanks.
paulienyse
I have try this way, and I can synchronize my database everytime I want. For me, synchronization I need only a handphone, connect the handphone make private LAN, then finish. I think you not lose any money when connect the phone into Desktop PC, because the packet not go outside, the handphone only need to show up Desktop PC IP for IIS.
That's all I can give for you, I hope its helpfull.
ScubaSteve20001
erwrwer
I am really sorry that I got confused with your question. The only question you are aksing here seems to be about why pay for GPRS when syncing with Desktop. I dont know how this is related to SQL CE3. And as per my understanding you are having your own sync application that is plugged into Active Sync and do a sync. Then where is the question of pay to GPRS coming in to picture.
Thanks,
Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation
YAMEEN
does anyone have any solution easier and more simple than this or
can anyone provide with a simple example application for this case and step by step on how-to
i'll really appreciate for ur help.
thanks
thompson.
brixel
dear Daramayuda,
ur post is very helpful for me. i just have a problem at step 8. after i close the connection on computer, my pocket pc can't connect to IIS anymore.
do u know why is there anyway to make it work
i use the following connection settings, because other doens't work .
activesync >"Automatic"
pocket pc > "worknetwork"
thanks.
8. Close the internet connection on computer, then try to access
"http://<computer_name>/" on the PDA where the computer name is the
computer that have IIS and the cradle put on. If you see the page
same on the step 2 then the PDA is successfull connected to the
computer that have IIS. Make sure again that GPRS is inactive.
Because the purpose this steps it how
to make synchronization without using any money cost.
saigopal
Steps how to enable SQL Mobile 2005 synchronize with SQL Server 2005 SE/ENT
using the PDA cradle:
1. Install IIS service, and set the "Default Web Site" default. (Just
set what is needed.
2. Set the computer name correctly.
3. Test the IIS using browser and type "http://<computer_name>/" if
using Windows 2003 you will see that the page is under contruction,
other will show the IIS default page. If not show any page or error
"Page not found" like that then consult the IIS problems.
4. Install ActiveSync 4.1, point to menu File->Connection Setting,
After "Connection Settings" Window see the "This computer is
connected to:" and select "The Internet". This purposed that the PDA
when put on cradle and want to access a website address will use
this computer as ISP. You can see that we will access website when
create a subscription for SQL Mobile Database, See the step how to
make SQL Mobile Application at the SQL Server Bookonline.
5. At the PDA set the internet connection into "My Work Network" or
something else that make the internet connected without GPRS or Else
connection. So the PDA that want to access internet will direct to
the computer that the ActiveSync have been setup like above.
6. Create internet communication on the selected computer, make sure the
connection active, and try access some page, e.g
"http://www.google.com" (I think this website is magnifician because
it very fast to load).
7. Now put the PDA at cradle, and wait to sync. After synced then try
to access a website using PDA. Make sure the GPRS or Else connection
is inactive so that we not use GPRS connection to access web (And we
not out of money next we synchronize). If not success, consult how
to make internet connection for PDA in other forum.
8. Close the internet connection on computer, then try to access
"http://<computer_name>/" on the PDA where the computer name is the
computer that have IIS and the cradle put on. If you see the page
same on the step 2 then the PDA is successfull connected to the
computer that have IIS. Make sure again that GPRS is inactive.
Because the purpose this steps it how
to make synchronization without using any money cost.
9. Then see the SQL Server bookonline to see how to make SQL Mobile
Application, and do that steps. I have some problem with this help
and have the result but still on research, if completed I will
inform you all.
Thats all how to make synchronization between SQL Server Mobile 2005 and
SQL Server 2005 SE/ENT without make any cost. I hope this helpfull.
Regrads,
Ariston Daramayuda.