Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer

Has anyone used the Microsoft SQL Server 2005 Compact Edition Access Database Synchronizer with any success. I dl and installed this tool from Microsoft, but have yet to get it to connect.

I am using WinXP Pro and Access 2000 SP3 on my desktop, and Windows Ce 5.0 with CF2.0 and SqlCe on my mobile device.

I cannot find the Sample Wizard for starters, so I could not connect using Iexplorer with PC name at port 1024 (http://pcname:1024/. I even disabled the firewall and AV, still no luck. The service seems to start when it syncs the PDA, but no ability to PUSH or PULL data from Access db into SqlCe.

The files were installed here:

Code:

---

C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access

---

It says the sample app can be loaded onto the PDA, but the file sqlce.access.sample.PPC.wce5.armv4i.CAB says it is not a valid WindowsCe executable... ***!

When I try and run the Sample C# app included source, VS 2005 says it cannot open the DataStore... ***!

Other than the info available on Microsoft's website, I have found little information on success stories or troubleshooting tips.

I need Access support until the conversion of the desktop app is completed to .NET and Sql Server. But that is at least 6 months away.

Can someone offer some hope for this tool, or suggest a resonable workaround to get my handheld Sqlce data back into my desktop Access db?

This is totally insane. Microsoft could have done better IMHO.

Please help.... :mad:

I guess nobody uses this POS syn tool. I am kind of stuck. I can store info on my handheld, but I need to pull about 1000 records from my Desktop app with Access db, update them on handheld, then Push them back into the Desktop Access db. The tool says it can do this, but I cannot figure it out.

I will be glad when the whole application is converted to .NET and Sql server...

For now, I looking for a temp workaround. Maybe I could use a CSV text file to exported from my desktop app, then load them into SqlCe on the handheld. Seem kind of crapy solution, but it can be done fairly easy... I think.

Any ideas.... thanks everyone :o

Hi,
there are a few answers on the MS forum - http://forums.microsoft.com/MSDN/Sho...D=152&SiteID=1

People appear to have got it running ok

HTH

Pete

I had read that info earlier today, just didn't seem to be helping. I went back and looked again, this time doing a search on MSDN for ADS only, and found info that seems to be a little more useful.

They claim:

Code:

---

If you have installed ADS at the default installation path, you will find the ADS wizard at the following path

C:\Program Files\Microsoft SQL Server Everywhere Edition\Access\Sample\AccessSync

---

While I did install ADS, and the path does not exist on my machine, so that would be the start of my issues.

The sample wizard is not installed, but the source code is installed here:

Code:

---

C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\Sync\Access\Sample\AccessSync

---

Something is wrong, whatever I am doing. I dig around the site some more and see if I can find where I went wrong.

Thanks.

FYI, this is the same problems I am having, still no resolution.

http://forums.microsoft.com/MSDN/Sho...96216&SiteID=1

This is still not working for me.... seems some files did not install. I have tried port 1024 and firewalls, etc....

The data I am trying to sync in not that much, I think I could just transfer a CSV file and import/export the data just using my app and ActiveSync.

Ok, I can Import/Export the needed data to a delimited text file. I can also transfer these file to the handheld and open them.

I can't use a "SELECT * FROM Data.csv" to load the data in a DataTable because it would require OLEDB and if I had that I would not need load Access Sync tool.

But CF20 does support Imports System.IO namespace and the StreamReader/StreamWriter Classes among some others.

So I could in theory use the StreamReader to read in line by line, loading each field into a DataTable, then save it using SqlCe on my handheld app.

Then I could export the modified data using StreamWriter to export back to desktop file....

All the needed tools are supported directly in CF20 and would no longer need Access or the sync tool.

If so, what are the limits in how many lines CF20 will parse... RAM available of course.

Is this a do-able workaround?
.