My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
RonCreate 2 file in the same director with setup.exe
1. Setup.bat
setup.exe /settings Settings.ini /L*v C:/MSDELog.log
2. Settings.ini
[Options]
SAPWD=YourPassword
DISABLENETWORKPROTOCOLS=0
SECURITYMODE=SQL
DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"
Run the setup.bat|||I have tried your code and other code like that and in each case it fails. I keep getting this error message that says:
"The instance name specified is not valid."
Note that your code didn't even use the instance name.
In your code you use:
DATADIR="C:\MSDE"
TARGETDIR="C:\MSDE"
Actually on my C drive the folder is called MSDERela. I tried changing your code to indicate that and it still doesn't work. Same error message.
Any other suggestions? Thanks!|||I added the INSTANCENAME and added quote marks to some of the code and it seems to have worked. It produced a folder on my C drive wtih a number of files in it.
Now can someone tell me how to launch MSDE?
Now you know why I call myself SQL_Dummy!sql
Showing posts with label release. Show all posts
Showing posts with label release. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
Microsoft Releases Synchronization Services CTP
The Microsoft Synchronization Services for ADO.NET v1.0 CTP release appeared without fanfare on January 22, 2006. The release contains "v1.0 early CTP" bits for the sync framework and SQL Server 2005 Compact Edition (SSCE) v3.5, the Orcas successor to the SSCE v3.1 RTM bits, which Microsoft released on January 11, 2006. The current code name for Sync Services is OCS (for Occasionally Connected Systems).
Seems to me to resemble a "stealth release."
For more, see http://oakleafblog.blogspot.com/2007/01/microsoft-releases-synchronization.html.
Oops. Make that January 11, 2007!
--rj
Monday, March 19, 2012
Microsoft Access Database Synchronizer (ADS) RTW
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
Microsoft Access Database Synchronizer (ADS) RTW
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
Microsoft Access Database Synchronizer (ADS) RTW
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
Microsoft Access Database Synchronizer (ADS) RTW
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
|||I cannot open the project.Error retrieving information from user datastore. Platform not found.
Does anyone know what the problem is?
I can create projects for Pocket PC 2003 and Windows CE 5.0
I need to create a project for a Windows CE 5.0
Already many thanks,
Peter
Microsoft Access Database Synchronizer (ADS) RTW
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
Microsoft Access Database Synchronizer (ADS) RTW
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
Microsoft Access Database Synchronizer (ADS) RTW
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
Microsoft Access Database Synchronizer (ADS) RTW
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
Subscribe to:
Posts (Atom)