Hi,
Today we are very pleased to announce the RTW release of Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer (ADS) for which many of you been waiting eagerly.
Access Database Synchronizer provides a way to synchronize data between Microsoft Access database on a desktop and Microsoft SQL Server 2005 Compact Edition database on a device.
The salient features of this solution are summarized below
? Provides a synchronization solution between SQL Mobile/SSCE and MS Access. Data conversion is done while synchronizing the data.
? Synchronization happens when there is an active ActiveSync connection between the device and the desktop.
? There is no update to SQL Mobile/SSCE on the device. The solution consists of only of desktop side component which works with the existing client agent on the device.
? The solution is based on existing RDA replication model. Programming model is exactly the same as RDA today.
? Device applications written today do not need to be updated if the solution is upsized from access to SQL Server.
? There is no conflict detection/resolution.
The setup installs the desktop component required for synchronizing Microsoft Access database with SQL Server Compact Edition database on the device. It also includes a readme file which has the documentation for the solution and a sample application. The readme file can be downloaded separately. The sample application shows how the solution works and how to write applications for this solution. The components installed on the desktop can be used by third party applications to provide data synchronization between Microsoft Access database on the desktop and SQL Server Compact/SQL Mobile database on the device.
On a desktop, the following operating systems will be supported:
? Microsoft Windows XP Professional SP2
? Microsoft Windows XP Home Edition SP2
? Microsoft Windows XP Media Center Edition 2005 with Windows XP MCE 2005 Update Rollup 2installed.
? Microsoft Windows XP Tablet PC Edition SP2
? Microsoft Windows Vista (Only Windows Mobile 6.0 devices are supported)
On devices, the following operating systems will be supported:
? Windows Mobile 2003 Second Edition
? Windows CE 4.2
? Windows CE 5.0
? Windows Mobile 5.0
? Windows Mobile 6.0
The following versions of Microsoft Access will be supported:
? Microsoft Access 2000 SP3 (Microsoft Office 2000)
? Microsoft Access 2002 SP3 (Microsoft Office 2002)
? Microsoft Office Access 2003 SP2 (Microsoft Office 2003)
? Microsoft Office Access 2007
This solution will work with all installations for SQL Server Mobile Edition/SQL Server Compact Edition on devices. The sample application provided is supported only on Windows Mobile 5.0 Pocket PC edition.
For more details on ADS please see the readme
ADS Readme
Feedback
We look forward to you providing us feedback about this solution. You can provide us feedback at
SQL Server Mobile Edition/SQL Server Compact Edition MSDN Forum
And
SQL Server Compact Edition Blog
Thanks,
Manish Agnihotri, Program Manager
I noticed that you specified that SSCE had to be running on a device. Does this mean that it cannot be used to sync an Access Database on a network drive to an instance of SSCE on an XP Pro laptop?
Thanks
|||Yes SQL Server CE on desktop can not use this solution. SQL Server CE on devices is the target platform for this solution. The supported device platforms are :
On devices, the following operating systems will be supported:
? Windows Mobile 2003 Second Edition
? Windows CE 4.2
? Windows CE 5.0
? Windows Mobile 5.0
? Windows Mobile 6.0
Thanks
Laxmi
|||Can you provide an example on how to use ADS to automatically synchronize when an ActiveSync connection is established?
|||I installed the ADS wizard on a windows mobile 5.0 pocket pc. That app is working but I can not connect to an mdb database I created on the desktop.
The desktop is actually a vista ultimate configuration. The activesync is working and I disabled the firewall on that pc.
Is the reason why I can not connect the following text in the readme.txt file : ? Microsoft Windows Vista (Only Windows Mobile 6.0 devices are supported) ?
Why are only windows mobile 6.0 devices supported for vista. Is there no way to make it work on an older version ?
Thanks,
Edwin
|||Hi,
Could you please guide me how to copy data from Oracle to MS SQLCe, I have the entire table structure on SQLCe.
I want to do it progamatically, if there is tool which will do this activity I am also fine with that.
Thanks in advance.
|||
I was looking to forward to this after I lost the database sync capabilities going to a Mobile 5 device. Fortunately, with a workaround I was still able to do a database sync with WM5, only to lose it again after I upgraded to Vista.
Now there is a sync out, but it doesn't support WM5 under Vista. Why not? Is everybody expected to buy new devices? They are far to expensive for that. It's bad enough that the device center doesn't sync WM2002 devices any more. They are still out there, and for people just needing their addresses they will be still fine.
Back to the sync: because of the missing sync, I have two programs syncing right now with their own sync providers, just because of the missing sync. I can't wait for the day when I plug in my device and half a dozen programs will start up just so that each one can do their own syncing. Really great.
And what about my programs? I have to try to create my own syncing now again?
Let's take an example - I wrote an application in Embedded Visual Basic that used the Active Sync database sync.
I can't import the evb file to Visual Studio - that means I have to re-create the user interface, re-write the code and then also write new data access code. And now I have to write my own sync provider? And I thought that the bad import of VB6 projects into VS2005 was a hassle.
It really seems that Microsoft is trying really hard to make the life of programmers that have existing projects as miserable as possible. This is really a very big disappointment.
It may be feasible for large corporations that have the resources to hire hundreds of programmers to re-write every single application that they need over and over and over, but as a part-time programmer that just tries to keep his programs running on new platforms, it is a nightmare.
|||There are many people not happy with no Vista support for ADS. I just wanted to update you all the Microsoft is working on providing Vista support for ADS and we should be out with it soon.
Manish Agnihotri
Program Manager
SQL Server Compact
|||You can see the folowing post on the Sql Server Compact blog for this information
http://blogs.msdn.com/sqlservercompact/archive/2007/02/22/ads-automatically-starting-the-synchronization-between-device-and-desktop.aspx
|||I was so excited to see this.... except I don't have a mobile 5.0 device to use the sample app.
Not sure if this synchronizer will be of any use now.|||
Do you need to install IIS or a HTTP server in order for this to work? I am trying to use this on my desktop machine but I can't seem to connect to my Access database. Please advise. Thanks. Rodan 
Hi,
Is it necessary to have MS Access installed on the Desktop to use this tool?
Thanks in advance,
David Del Signore, IT Consultant
|||I have the same problem as Rodan. I am not able to connect the accesdatabase using the ADS sample. When I'm trying to connect Access database the following messagge appears"A request to send data to the computer running IIS has failed. For more information see HRESULT"
" Error connecting database"
Someone knows what could be the problem? It is neccesary install IISS. Thanks
|||
No you do not require IIS to be running. Maybe your firewall is not setup correctly. Please go through the readme and set the firewall settings accordingly
Regards
Manish Agnihotri
Program Manager, SQL Server Compact
|||You can create a PPC 2003 project and copy paste the code in new project. It should work with your older devices as well. The application provided is just a sample application which work on PPC 2005 devices. ADS is a solution around which you can build you applications dependig on specific requirements
Regards
Manish Agnihotri
Program Manager, SQL Server Compact
No comments:
Post a Comment