Automatic Sync Between SQLce And Access
Feb 21, 2007
Hi,
I am converting an old eVB application to CF.NET 2. It's a very simple setup.
1) An Access database sits on the host and has occasional edits applied to it.
2) An application on the PDA with a mirror copy of the Access database (filtered data) and also has occasional edits applied
3) When the user puts the PDA in the cradle the databases get automatically synchronized with each other.
Probably couldn't get much simpler than this. This used to be very easy to do with PocketAccess and ActiveSync. Unfortunately this is no longer supported. I decided to use the new SQLce database instead when porting to CF.NET. It's working like a charm except that I haven't found an easy way to synchronize with the desktop Access application.
Merge replication seems to be exactly what I need but it doesn't work with Access or SQL Server Express. I don't need (or want) a full version of SQL Server. The dataset is very small.
ADS seems to point in the right direction except it doesn't support automatic synchronization. It also doesn't support Vista in combination with PPC2003SE.
Sync Services seems to have the same problems as ADS.
I have seen some third party tools around but they all require the user to manually kick off synchronization which I'm desperatly trying to avoid.
I've been searching for days now and I'm not getting any closer to a solution. Any help would be greatly appreciated!
Cheers,
Thomas
View 7 Replies
ADVERTISEMENT
Mar 3, 2008
I'm using SQL'05, VS'08 SQLCE 3.5 building VB.NET applications.
I'm using LocalDataCache to sync SQLCE and SQL'05
When I write a new record to SQLCE the corresoponding record in SQL'05 shows both LastEditDate and CreationDate values.
When I update the recored in SQLCE the LastEditDate gets updated, but CreationDate gets set to NULL.
Ideas?
David L.
View 8 Replies
View Related
Jun 5, 2007
how can one ce database sync to two different server?
for example, i sync ce to server A, also i would like to sync to server B.
And the other case how can i re-sync ce data to same server if server has some data lost??
View 1 Replies
View Related
Jan 11, 2008
Hi
I am developing a Windows Service product and use SQLCE 3.1 as data store, I found problem, that, when I inserted a record to sqlce data store from within service, I got an hidden window, the name is ms_sqlce_se_notify_wndproc, Could anyone has idea of how to disable this hidden window? Because my product is running as Windows Service, so this hidden window would be a serious security hole.
Thanks a lot!
View 3 Replies
View Related
Mar 5, 2008
Hi guys!
I'm facing the following Problem.
My c# .net Application consists of a Desktop Part - and a Mobile Part (Win CE 5.0)
The Desktop uses a Ms Access Database, the Mobile a SQL Server Compact 3.0 Database.
The mobile Database is a kind of "light" version of the desktop
e.g
Desktop DB,...
Table Component
Attribute
Component ID
ComponentName
Quantity
Info1
Info2
Text1
Text2 ...
Mobile Database
Table Component
ComponentID
ComponentName
Quantity
changeflage
So as you see there are less information on the mobile Database.
But anyway, somehow i need to sync these tables...in both directions.
My first idea was to create an OleDB Connection to the Desktop Database, and Fill a OleDbDataadapter with the table Content.
Then run throuh the dataset.tables[0] row by row... and insert or update the Content in *.sdf database.
and vice versa
I also thought about to add an Attribute named "changeflag" to the mobile database, and if i change the Contant of a row i set the changeflag to 1, so i know i have to update this line in the Desktop Database
My question is now, is there a better or easier way to do a synchronisation, without running through a Dataset und inserting or updating the Mobile Database row by row?
with kind regards
Thomas
View 4 Replies
View Related
Oct 20, 2006
I am re-writing an application for Windows CE which was originally written for the Palm OS. The original application was written in VB6 using access databases. I will be re-writing it in VB.Net and was considering using SQL Everywhere as it seems to fit the criteria that i need.
There is also an application written for the desktop that synchronizes with the mobile application. This also is written in VB6 and uses Access Databases.
I found the Sync with access CTP which i thought was exactly what i will need for this project. However i have a few concerns about SQL and Access and would like to ask a few questions before i can continue with this project.
I read that this Sync with access will allow me to synchronize the data between my desktop application and the mobile device application.
What will happen when we re-write the desktop application to use SQL?
Will i be able to sync the data between the 2 applications without using SQL Server? i.e. sync using SQL Everywhere.
If not, is there any way around it without implementing SQL Server.
I thought of having an Access Database in between the 2 applications to utilize the Sync with access component. Does this sound feasible?
Also, is it possible to Remotely sync the data without using SQL Server?
Thanks.
View 6 Replies
View Related
Sep 29, 2006
Dear all,
I have a software written in C#, using RDA to sync access database from desktop. But it is tricky that some time during "Pull" data from SQL Server Agent, my PDA tell me "A request to send data to the computer running IIS has failed. For more information, see HRESULT".
This also happening when I try to unplug the ethernet cable from my desktop however the push and pull actions did not required to go through internet.
Here are part of my codes
m_intdb = new SqlCeRemoteDataAccess("http://desk01:1024", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inttemp.mdb; Jet OLEDB:System Database=C:\Documents and Settings\user\Application Data\Microsoft\Access\System.MDW");
m_intdb.InternetUrl = "http://desk01:1024";
m_intdb.LocalConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inttemp.mdb; Jet
OLEDB:System Database=C:\Documents and Settings\user\Application
Data\Microsoft\Access\System.MDW"";
m_intdb.Pull("pulltest", "SELECT * from pullTest", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inttemp.mdb; Jet
OLEDB:System Database=C:\Documents and Settings\user\Application
Data\Microsoft\Access\System.MDW", RdaTrackOption.TrackingOff, "Err_PullTest");
and the error message look like
A request to send data to the computer running IIS has failed. For more information, see HRESULT.
Please help me solve this problem
Best Regards
Tony Lam
View 4 Replies
View Related
Jan 11, 2005
Hi,
I wonder if anyone can help. I'm trying to create a new user/login to a sql server 2000 box which will automatically have access to all the user databases on the instance. The user can't be a SA or anything however. It seems this can be done as the application which uses all these database has created such a user, however I need another which I will then make read-only.
Any ideas?
Thanks in advance
future2000!
View 1 Replies
View Related
Jan 1, 2007
I finally added WinXP SP2 to my system yesterday (along with a lot of other security updates/patches through Automatic Updates) and now my backups and data exports are failing. Further, when I open my "Enterprise Manager" and try to export data ("All Tasks-Export-...") using the Import/Export Wizard, it won't let me select the "Export From" database.
View 1 Replies
View Related
Feb 6, 2006
Hi
I've big problems with my SQL Server 2005 Std. merge replication/snapshot share
I want to create a mobile application based on a ms sql 2005 mobile database running on a pocketpc 2003se.
for this task i installed iis, sql server 2005 std. and the sql server mobile tools.
i created a dedicated user for making snapshots in the new created and functionable publication, but when i start the web sync wizard, i alwas get the failurmessages
snapshot share "......" cannot be accessed, please specify a new share
the access permissions based on the share an based on the ntfs area are set right.
the user, i chose for the anonymus access (the same, as for creating snapshots), has enough rights on the folder. also when creating a new share, with different share name, and using another user for anonymus access (standard iusr_machine_name) i get the same message
do you have any suggestions for my problem??
please i need help as soon as possible
best regards
View 6 Replies
View Related
Feb 6, 2006
I am currently upgrading our ppc app (written in .net 2003) to .net 2005 and from sqlce 2.0 to 3.0. The new application runs out memory(storage) when handling lots of data transactions (both in case of using sqlcedatareader, and dataset ). There is no memory leak issue here, sqlce 3.0 simply uses a lot more (3 times more) memory than sqlce 2.0.
Our applicaton runs fine using sqlce 2.0 and .net 2003, but fail due to memory shortage
with the upgrades(which has the same code). Anyone can shed some lights on this issue?
View 3 Replies
View Related
Jun 9, 2006
Does anyone have any instructions on how to go about uprading a .sdf file
from sqlce 2.0 to sqlce 3.0?
I found this on an msdn website
(link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx) but
as you can see its very lacking on detail. (I included the link and content
referring to upgrading the database files so you won't have to go to the link
to see the part referring to upgrading the database.) I tried to run the upgrade.exe on my device but it doesn't explain how you're supposed to point it to the .sdf that you are trying to update. Here is the content on the above web page.
Upgrading Database Files
You can upgrade a database created with an earlier version of SQL Server CE
2.0 to a database created with SQL Server Mobile by using the SQL Server
Mobile Database Upgrade tool (upgrade.exe). The Database Upgrade tool runs on
a smart device.
When you run the SQL Server Mobile Database Upgrade tool, the new SQL Server
Mobile database is created on the smart device. The new database, with the
file name extension .sdf, contains all the data that was in the source
database. You need to reinitialize the upgraded database to continue using it
for replication.
Note: If you are using replication or remote data access (RDA) as a
connectivity solution before upgrading to SQL Server Mobile, you must
synchronize the source SQL Server CE database (subscription database) with
the SQL Server database (Publisher). The reason for synchronizing before
upgrading to SQL Server Mobile is to ensure that any changes that exist in
the tables on the SQL Server CE database are updated on the SQL Server
database, because after the upgrade you must resubscribe or repull using the
new database.
View 3 Replies
View Related
Oct 11, 2006
I presently run on my server SQL SERVER CE 2.0 and want to install, in addition on SQL Server 2.0, SQL Server Mobile 2005.
Is there a procedure to have both installed and running on a computer?
Thanks!
Marco
View 2 Replies
View Related
May 10, 2007
Hi,
i am working with windows mobile Cf 2.0 and desktop. i got problem when i were trying to synd mobile database and ms-access database.
my requirement is online i want to transfar data records from mobile to desktop vice versa.
but how? i dont knwo any body would like to guide me.
i am ready to accepting yours valuable views.
waiting
bye
Rajat.
View 9 Replies
View Related
May 16, 2007
It is possible to upgrade existing SqlCE to Sql 2k5 database? Or just import CE database to import data model structure and data?
View 1 Replies
View Related
Dec 12, 2007
My app is working on my local system with the vs2008 development server. It's an asp.net app and I added the line:
AppDomain.CurrentDomain.SetData("SQLServerCompactEditionUnderWebHosting", true);
So it works fine on my system. But I can't get it to work on shared hosting. I have uploaded all the sqlce 3.5 dlls to the bin directory. I am stuck at the error:
Access to the database file is not allowed. [ File name = ]
There actually is a file name in the connection string, and I set the permissions wide open on App_Data to test this.
What are the .net framework requirements for sqlce 3.5? I can't find this info anywhere.
I know sqlce 3.5 is not recommended for asp.net, but it is not the main site database but is used for a setup database utility to be installed for a windows app.
View 3 Replies
View Related
Jan 31, 2008
Hi,
We have over 1000 terminals running CE 4.2 on an x86 cpu currently using SQLCE 3.1.
We have just upgraded to VS 2008 and found the projects have been upgraded to reference SQL CE 3.5 - this is great, as we wish to use things like TOP etc.
However, all the distributable packages only include CAB files for CE 4.2 for the ARM Processor, or CE 5.0 for the x86. Is there a CAB package available for CE 4.2 for the x86 CPU? (please...)
Even just the relevant .DLL files would be fine as we repackage them ourselves anyway.
Thanks.
View 1 Replies
View Related
Mar 21, 2007
Hi,
Could some one in copying 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.
View 3 Replies
View Related
Apr 2, 2007
Hi i developed Wm5 PPC application with sqlce database. i Create Cab file when i install in my HP WM5 PPC that will showe the Message sqlcewm.dll missed. Please tell me 1)sqlce30.ppc.wce5.armv4i 2)sqlce30.wce5.armv4i 3)sqlce20.ppc.wce5.armv4i..Please Help me
View 1 Replies
View Related
Oct 23, 2007
In my homegrown data layer, I added the ability to do Order By Clauses.
I do one query with an Order By clause (all 6 records in the table retrieved).
Then I do a 2nd query without an Order By (36 of around 200 records in the table retrieved)
And I'm getting Native Exceptions.
ExceptionCode: 0xc00000000c (Null Pointer I believe)
ExceptionAddresss: 0x00c3703c (looks to be in sqlcese30.dll)
Reading: 0x00000005
I ran thru with the debugger, and am finding the error happening inside of a SQLDataReader.Read() call. It's trying to read the 14th of the 36 records that the query has found.
I am all but positive I'm not closing this database connection. The problem is happening while I'm looping off the reader data I just retrieved and in this query there was no ORDER BY clause.
I'm at a loss as to what to do about this. I'm not explicitly closing any database connections, and I'm getting the data right after performing the query.
View 1 Replies
View Related
Oct 4, 2007
Greetings,
I wrote a very simple C# console application which was designed to give us a rough idea on the performance and reliability of SQLCE (the source code without metrics has been posted to this group recently). What I've found is that there are major performance and reliability issues with SQLCE 3.0 as opposed to SQLCE 2.0. Whereas SQLCE 2.0 seems to be fairly consistent in terms of it's memory usage and the amount of time taken to insert rows into the table regardless of the size of the table (to a limit, after about 300,000 records it too has major performance issues), SQLCE 3.0 seems to slow down noticably and continually use more memory even after a few thousand records are inserted and actually crashes (consistently) after 25592 records are inserted!
What gives? Based on this it would seem that SQLCE 2.0 is far preferable for an unattended device that needs an uptime of over 30 days whilst constantly (several times per minute) inserting into the database.
Thanks for your thoughts on this...
View 6 Replies
View Related
Mar 20, 2007
Hi,
Could some one guide me hot copy tables/Data from SQL 2005 to Sql 2005 Compact Edition?
Thanks
View 3 Replies
View Related
Jan 3, 2007
Hello all,
I want to use SQLCE and WPF.
Can anyone direct me to some example code.
two way binding with a sqlceResultSet would be a great start.
(last inquiry was in Aug of 06)
Thanks
Mike (still trying to get the latest tech to work together) Greenway
View 6 Replies
View Related
Apr 13, 2007
Hi,
Does anybody know how to upgrade a SqlCE db(.sdf) file from Version 3.1 to 3.5?
And a URL where can I get related Info.
View 1 Replies
View Related
Nov 8, 2007
Last month , I have made a utility named sqlce viewer to help me manage sqlce 3.5 beta version databases .
The location is https://sourceforge.net/projects/sqlceviewer/
And now , I encounter a strange problem , need some help .
After user install this utility or run it standalone execute file .There has a error message poped before see the login in form . Even user has installed .net framework version 3.5 .
And if user has installed visual studio 2008 beta2 ,this problem will not existed .
This utility depend on these components :
1)WPF
2).net framework 3.5 beta
I don't know what's the reason clearly .
Anyone could give some advice are warm welcome.
View 2 Replies
View Related
May 31, 2007
can anyone tell me how to open/create a SQL Server 2005 Compact Edition database using SQL Server Management Studio Express?
cheers
View 5 Replies
View Related
Jul 30, 2007
I'm still having trouble deploying my Compact Edition application. The installation on other computers works, but if the program tries to start, i get the error message (translated from german):
"This Version of SQL Server 2005 Mobile Edition is not licencensed for productive use"
I always thought that there are no licence restriction with SQL Compact Edition.
Strangely the the programm works on some computers... as I think on all computers where Visual Studio is installed.
does that makes any sense to one of you?
thanks for any help,
Stefan
View 1 Replies
View Related
Jun 3, 2004
Problem encountered:
Error Code: -2147467259
Message: A call to SQL Server Reconciler failed. [,,,,,]
Minor Err. 29006
Source: Microsoft SQL Server 2000 Windows CE Edition
Any idea what could be the possible problem?
I have been trying to search thru the internet for a resolution but most of the guides are very brief about the configuration of the merge replication in mssql2000 server.
e.g. http://msdn.microsoft.com/msdnmag/issues/03/09/DataPoints/default.aspx
This link above its recommended by Microsoft, but still doesn't really helps.
Does anybody have a step-by-step guide on configuring the merge replication in mssql? With diagrams preferred.
-OR-
Is there anything wrong with these codes:
oRpl.Publisher = "HANBIN"; // HANBIN is my database server name
oRpl.PublisherLogin = "LHP";
oRpl.PublisherPassword = "<password>";
oRpl.InternetUrl = "http://hanbin/ssce/sscesa20.dll";
oRpl.InternetLogin = "IUSR_HANBIN";
oRpl.InternetPassword = ""; // do i need to put sth here?
oRpl.Subscriber = "CESubscriberTest"; // Any names will do?
oRpl.Publication = "testdbpub";
oRpl.PublisherDatabase = "testdb";
oRpl.Distributor = "HANBIN";
oRpl.DistributorLogin = "sa";
oRpl.DistributorPassword = "<password>";
Any help from any genious will greatly be appreciated.
Regards,
Hanbin
View 2 Replies
View Related
Apr 6, 2004
I’m using SQLCE and SQL Server2000 to replicate to a Pocket PC running PPC MS windows 2002. What I want to know is it possible to update my cab file on the PDA remotely?
Is it possible to install the cab file trough SQLCE?
View 1 Replies
View Related
Jan 17, 2008
Hi,
Can I use SqlCe v3.1 and SqlClient v2.0 in one .net application? (Note: I can't use RDA or replication. SqlClient read and write data in ON-LINE mode, SqlCe store and manipulate with data in OFF-LINE mode.)
View 4 Replies
View Related
Apr 20, 2007
MSDN has examples of deploying SQLCE privately for C# and VB.NET, but that doesn't seem to translate to C++. A .NET application just loads the assembly it needs from the local directory, but from what I can tell I need to use the OLE DB driver to use SQL CE in C++. The problem is that the OLE DB driver is a COM object that (presumably) needs to be registered.
Has anyone successfully used SQLCE from C++ without registering any COM objects? I'm thinking the only way to do that would be to call DllGetObject() on the DLL and get the object manually, but I've never done this so I'd hate to waste the time if there's an easier way, or if this won't work.
View 7 Replies
View Related
May 21, 2007
In the readme of v3.5, it mentions that if I use 3.5 to open a database file created by previous version, the version number will be updated to 3.5, so I opened it in c# and run some select statement, then I run the verify() command and here's what's returned:
Source : d:Dataceguardian.sdf
Destination : n/a
Verifying - verMajor: 3, verMinor: 0, verBuild: 5300, verPoint: 0
Time - 2007-21-05 14:42:39.847
it seems the database file did not get updated to v3.5. Unless it's returning original info.
Then, I take this same database file and try to access from another project with v3.5 runtime + Enterprise Library, and it generates this error:
An exception of type 'System.Data.SqlServerCe.SqlCeException' occurred in guardian.exe but was not handled in user code
Additional information: You are trying to access an older version of a SQL Server Compact Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later database, run Compact / Repair. [ Db version = 3505053,Requested version = 3004180,File name = D:Dataceguardian.sdf ]
I am confused. Shouldn't 3.5 opens it up regardless of what version it is?
WL
View 3 Replies
View Related
Jan 31, 2007
I am trying to soak in all this information regarding SQLCE and was hoping someone could set me off in the right direction.
Scenario:
I have an Windows Mobile 5.0 data collection application that I need to sync with a desktop database. I will need the ability to sync 1 or more Pocket PC's with a desktop database.
Questions:
1.) Assuming I need to sync the data, is using a SQLCE database on the device AND the desktop a viable solution?
2.) If not, would my only other option be to use SQL Server Express (SQL Server is not an option, $$$)?
3.) Keeping simplicity in mind, what would be my best choice of syncing technology? RDA? Merge Replication? Microsoft Synchronization Services for ADO.NET?
Generally speaking, I want to know if YOU were starting from scratch, what combination of technologies would you use?
Thanks!!!
Mike
View 7 Replies
View Related
