SQL Server 2005 Compact Edition Access Database Synchronizer Released

AdSense control for ASP.NET 2.0 [Via: help.net ] MOSS 2007 Best Practices Analyzer [Via: mikewalker...

cool!

Can anybody get the wizard working? It's supposed to be in all programs, but I can't find it.

Michael;

Have you installed the sqlce.access.sample.PPC.wce5.armv4i.CAB onto your device/emulator. Once you install the CAB, you should be able to find the Wizard on the device/emulator by selecting Start | Programs on your device/emulator.

The CAB file is located in %Program Files%\Microsoft SQL Server Compact Edition\v3.1\sync\Access.

The Readme.doc talks a little about this in the section entitled "2.0 Obtaining Access Database Synchronizer".

I hope that helps.
- Jim

Can you please help tell me hoe to configure or use the wizard to configure a simple access db with device SQL CE database.

govindaraj at gmail dot com

Govindaraj;

There are some pretty good resources included with the product install - they're just hard to find.

Sample source code for setting up a sync app is located in %Program Files%\Microsoft SQL Server Compact Edition\v3.1\sync\Access\Sample.

The CAB file that allows you to install the sample sync app onto a device/emulator is located at %Program Files%\Microsoft SQL Server Compact Edition\v3.1\sync\Access\sqlce.access.sample.PPC.wce5.armv4i.CAB

I find that the sample sync app along with the Readme.doc file located in %Program Files%\Microsoft SQL Server Compact Edition\v3.1\sync\Access to be one's best bet at getting information on how to set things up properly.

I hope that helps.
-Jim

Can this sample be converted for Windows CE 5.0 device? Also is there VB version instead of listed C# veesion?

Reply will be greatly appreciated.

Vijay

Vijay;

I'm not aware of a VB version of the sample. Although it's not an ideal solution, you can use the free utility Reflector to open the project's assembly and view the fully expanded class definitions in VB (including all property and method implementations).

Using this technique, you can create a VB project and copy the VB code from Reflector into the VB project. You can also use Reflector to save the image files to disk so that they can be included in your new project as well.

As I said, it's certainly not ideal but it's something that can be knocked out fairly quickly and you'd have a working VB sample.

Regarding Support for a Windows CE device... I've only used it on Windows Mobile devices and therefore don't have any direct experience on non-Windows Mobile Windows CE devices. However, I checked out the Readme.doc that comes with the Access DB Synchronizer and it specifically says that Windows CE is supported. You should checkout out the Readme.doc file located in %Program Files%\Microsoft SQL Server Compact Edition\v3.1\sync\Access for more information.

Hope that helps,
- Jim

Specify path to System.mdw There is NO mention of this in the read docs.

It is set to
c:\documents and settings\***\application data\microsoft\access\system.mdw

Do I need to change this or set it?

Change c:\documents and settings\***\application data\microsoft\access\system.mdw to be for the user that is logged in. For instance, if user1 is the username of the person logged into the machine, then c:\documents and settings\user1\application data\microsoft\access\system.mdw is what you'll need.

I copied sqlce.access.sample.PPC.wce5.armv4i.CAB file to my device and clicked on it (on Symbol MC50 device WM2003SE) I get an error message that the file is not a valid Windows CE Setup File. Can anyone help me?

The problem is that the sample's CAB file is for WCE5-based versions of Windows Mobile which are Windows Mobile 5.0, 6, and 6.1. PPC2003SE is WCE4.2-based.

I don't believe tha a pre-Windows Mobile 5.0 version of the sample is available but you should double check.

To use the sample in CAB file you mention, your best bet is to install it onto one of the Windows Mobile 5.0, 6, or 6.1 emulators and run it from there. Once you craddle the emulator using the Device Emulator Manager, the emulator will behave just as your device will when connected via ActiveSync. The emulator should provide you with what you need to check out the sample.

Hope that helps.

-Jim

Thanks for the quick reply. I thought the file might be for WM5. I'll try the sample using the emulator.

Can you tell me how to connect to the Device Emulator Manager and how to add a fiel to the emulator? I have not used the emulator for development because it has been so slow.
Thanks

PS Do you have any knowledge of a solution that would allow two SQL CE databases to sync? It seems that syncing a desktop CE db with a device SQLCE db would make development for the device much more worhtwhile. I have been waiting years for an easy way to sync a desktop app with a device. If I use a SQL Express db on the desktop and try to setup sync with a SQLCE db on devices I wind up with a nightmare trying to setup and deploy the desktop app because of SQL Server setup.
Thanks again