Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server 2005
(mobile and express).
I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application when
the PDA is connected to the desktop??
- How can I connect to the PDA DB from the Desktop application?? (ie. do I
just use a connection string from the Desktop machine, but which connects to
the PDA DB??)
- Once I have this connected, I presume I will be able to compare the
data on the desktop machine, against the data on the PDA, and update each
accordingly?
Any examples of this being done, or details of best practices for this would
be much appreciated
Thanks 7 2188
Paul,
Before writing a single line of code, I'd look at the products here: www.primeworks.pt
I don't know if he has support for SQL Mobile yet, but this would be the
very easiest approach and for a very reasonable price.
--
Ginny Caughey
..NET Compact Framework MVP
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message
news:YD******** **********@fe1. news.blueyonder .co.uk... Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express).
I believe that I will need to write my own synchronization application, in order to update the data across the machines. My questions are: - Is there a way of picking up an event that will notify my application when the PDA is connected to the desktop?? - How can I connect to the PDA DB from the Desktop application?? (ie. do I just use a connection string from the Desktop machine, but which connects to the PDA DB??) - Once I have this connected, I presume I will be able to compare the data on the desktop machine, against the data on the PDA, and update each accordingly?
Any examples of this being done, or details of best practices for this would be much appreciated
Thanks
As far as I understand you intend to put the locus control on the desktop
machine.
In other words you will have a running application on the desktop machine,
which should "sense" a connected PDA and eventually start a sync process,
right?
If this is not a kind of a requirement and there are not other forces, which
I do not know, you may evaluate other approaches as well, which may be more
beneficial in terms of development effort and even scalability.
What I am talking about is transferring locus control into the PDA- e.g.
writing PDA application which should "sense" connection and initiate the
sync process.
Some of the synchronization approaches you may use are: RDA, Merge
replication and even Xml Web Services if the 2 previous methods does not fit
your requirements...
--
Ruslan Trifonov
blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message
news:YD******** **********@fe1. news.blueyonder .co.uk... Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express).
I believe that I will need to write my own synchronization application, in order to update the data across the machines. My questions are: - Is there a way of picking up an event that will notify my application when the PDA is connected to the desktop?? - How can I connect to the PDA DB from the Desktop application?? (ie. do I just use a connection string from the Desktop machine, but which connects to the PDA DB??) - Once I have this connected, I presume I will be able to compare the data on the desktop machine, against the data on the PDA, and update each accordingly?
Any examples of this being done, or details of best practices for this would be much appreciated
Thanks
you cannot use RDA or merge replication between SQL Mobile and
SQL Express.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation www.connectedinnovation.com
"Ruslan Trifonov" <ru************ *@ritsoftware.c om> wrote in message
news:eu******** *****@TK2MSFTNG P15.phx.gbl... As far as I understand you intend to put the locus control on the desktop machine. In other words you will have a running application on the desktop machine, which should "sense" a connected PDA and eventually start a sync process, right? If this is not a kind of a requirement and there are not other forces, which I do not know, you may evaluate other approaches as well, which may be more beneficial in terms of development effort and even scalability. What I am talking about is transferring locus control into the PDA- e.g. writing PDA application which should "sense" connection and initiate the sync process. Some of the synchronization approaches you may use are: RDA, Merge replication and even Xml Web Services if the 2 previous methods does not fit your requirements...
-- Ruslan Trifonov blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message news:YD******** **********@fe1. news.blueyonder .co.uk... Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express).
I believe that I will need to write my own synchronization application, in order to update the data across the machines. My questions are: - Is there a way of picking up an event that will notify my application when the PDA is connected to the desktop?? - How can I connect to the PDA DB from the Desktop application?? (ie. do I just use a connection string from the Desktop machine, but which connects to the PDA DB??) - Once I have this connected, I presume I will be able to compare the data on the desktop machine, against the data on the PDA, and update each accordingly?
Any examples of this being done, or details of best practices for this would be much appreciated
Thanks
In my opinion it should be the PDA initiating the sync and making a request
to the machine to get its data, not the other way around.
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message
news:YD******** **********@fe1. news.blueyonder .co.uk... Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express).
I believe that I will need to write my own synchronization application, in order to update the data across the machines. My questions are: - Is there a way of picking up an event that will notify my application when the PDA is connected to the desktop?? - How can I connect to the PDA DB from the Desktop application?? (ie. do I just use a connection string from the Desktop machine, but which connects to the PDA DB??) - Once I have this connected, I presume I will be able to compare the data on the desktop machine, against the data on the PDA, and update each accordingly?
Any examples of this being done, or details of best practices for this would be much appreciated
Thanks
Thanks to all that replied.
It looks like RDA, Merge Replication and Web services are all out (I don't
want to use IIS).
Does anyone know of an example of how to do this??
All pointers to articles / code samples / discussions welcomed.
Thanks
"Darren Shaffer" <da***********@ discussions.mic rosoft.com> wrote in message
news:e7******** *****@TK2MSFTNG P15.phx.gbl... you cannot use RDA or merge replication between SQL Mobile and SQL Express. -- Darren Shaffer .NET Compact Framework MVP Principal Architect Connected Innovation www.connectedinnovation.com
"Ruslan Trifonov" <ru************ *@ritsoftware.c om> wrote in message news:eu******** *****@TK2MSFTNG P15.phx.gbl... As far as I understand you intend to put the locus control on the desktop machine. In other words you will have a running application on the desktop machine, which should "sense" a connected PDA and eventually start a sync process, right? If this is not a kind of a requirement and there are not other forces, which I do not know, you may evaluate other approaches as well, which may be more beneficial in terms of development effort and even scalability. What I am talking about is transferring locus control into the PDA- e.g. writing PDA application which should "sense" connection and initiate the sync process. Some of the synchronization approaches you may use are: RDA, Merge replication and even Xml Web Services if the 2 previous methods does not fit your requirements...
-- Ruslan Trifonov blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message news:YD******** **********@fe1. news.blueyonder .co.uk... Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express).
I believe that I will need to write my own synchronization application, in order to update the data across the machines. My questions are: - Is there a way of picking up an event that will notify my application when the PDA is connected to the desktop?? - How can I connect to the PDA DB from the Desktop application?? (ie. do I just use a connection string from the Desktop machine, but which connects to the PDA DB??) - Once I have this connected, I presume I will be able to compare the data on the desktop machine, against the data on the PDA, and update each accordingly?
Any examples of this being done, or details of best practices for this would be much appreciated
Thanks
Paul - with all due respect, you're effectively taking everything off the
table. Technically speaking, you don't *need* IIS to create or consume a
web service right?
I think the only two avenues left are transferring data through sockets or
writing to some file and moving it around. But that's such a pain in the
butt and there are a ton of issues here as well. Replication is tried and
tested over and over and is probably the most reliable way your going to
come across. Next is web services but you're going to have to roll your own
checks all over the place if you do this. I've done it and it's a real
pain. Not impossible, not even hard in real terms, but monotonous, boring
and painful.
Ok but to answer your question I need to know one more thing - are you
using ActiveSync ? Is that a possibility
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message
news:pH******** ************@fe 3.news.blueyond er.co.uk... Thanks to all that replied.
It looks like RDA, Merge Replication and Web services are all out (I don't want to use IIS).
Does anyone know of an example of how to do this?? All pointers to articles / code samples / discussions welcomed.
Thanks
"Darren Shaffer" <da***********@ discussions.mic rosoft.com> wrote in message news:e7******** *****@TK2MSFTNG P15.phx.gbl... you cannot use RDA or merge replication between SQL Mobile and SQL Express. -- Darren Shaffer .NET Compact Framework MVP Principal Architect Connected Innovation www.connectedinnovation.com
"Ruslan Trifonov" <ru************ *@ritsoftware.c om> wrote in message news:eu******** *****@TK2MSFTNG P15.phx.gbl... As far as I understand you intend to put the locus control on the desktop machine. In other words you will have a running application on the desktop machine, which should "sense" a connected PDA and eventually start a sync process, right? If this is not a kind of a requirement and there are not other forces, which I do not know, you may evaluate other approaches as well, which may be more beneficial in terms of development effort and even scalability. What I am talking about is transferring locus control into the PDA- e.g. writing PDA application which should "sense" connection and initiate the sync process. Some of the synchronization approaches you may use are: RDA, Merge replication and even Xml Web Services if the 2 previous methods does not fit your requirements...
-- Ruslan Trifonov blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message news:YD******** **********@fe1. news.blueyonder .co.uk... Hi I have an application which runs on a desktop. I want to synchronise the DB with a PDA app, which also uses SQL Server 2005 (mobile and express).
I believe that I will need to write my own synchronization application, in order to update the data across the machines. My questions are: - Is there a way of picking up an event that will notify my application when the PDA is connected to the desktop?? - How can I connect to the PDA DB from the Desktop application?? (ie. do I just use a connection string from the Desktop machine, but which connects to the PDA DB??) - Once I have this connected, I presume I will be able to compare the data on the desktop machine, against the data on the PDA, and update each accordingly?
Any examples of this being done, or details of best practices for this would be much appreciated
Thanks
I'm trying to achieve something like Pocket Money...
It basically has a DB on the Desktop, and syncs with the PDA.
I want to write an app which has similar functionality. This should be
possible, I just need to know how...
IIS and SQL replication are not required in this scenario.
ActiveSync is a possibility, but... how?
Thanks
"W.G. Ryan - MVP" <Wi*********@no spam.gmail.com> wrote in message
news:OO******** ******@TK2MSFTN GP10.phx.gbl... Paul - with all due respect, you're effectively taking everything off the table. Technically speaking, you don't *need* IIS to create or consume a web service right?
I think the only two avenues left are transferring data through sockets or writing to some file and moving it around. But that's such a pain in the butt and there are a ton of issues here as well. Replication is tried and tested over and over and is probably the most reliable way your going to come across. Next is web services but you're going to have to roll your own checks all over the place if you do this. I've done it and it's a real pain. Not impossible, not even hard in real terms, but monotonous, boring and painful.
Ok but to answer your question I need to know one more thing - are you using ActiveSync ? Is that a possibility "Paul Aspinall" <pa**@aspy.co.u k> wrote in message news:pH******** ************@fe 3.news.blueyond er.co.uk... Thanks to all that replied.
It looks like RDA, Merge Replication and Web services are all out (I don't want to use IIS).
Does anyone know of an example of how to do this?? All pointers to articles / code samples / discussions welcomed.
Thanks
"Darren Shaffer" <da***********@ discussions.mic rosoft.com> wrote in message news:e7******** *****@TK2MSFTNG P15.phx.gbl... you cannot use RDA or merge replication between SQL Mobile and SQL Express. -- Darren Shaffer .NET Compact Framework MVP Principal Architect Connected Innovation www.connectedinnovation.com
"Ruslan Trifonov" <ru************ *@ritsoftware.c om> wrote in message news:eu******** *****@TK2MSFTNG P15.phx.gbl... As far as I understand you intend to put the locus control on the desktop machine. In other words you will have a running application on the desktop machine, which should "sense" a connected PDA and eventually start a sync process, right? If this is not a kind of a requirement and there are not other forces, which I do not know, you may evaluate other approaches as well, which may be more beneficial in terms of development effort and even scalability. What I am talking about is transferring locus control into the PDA- e.g. writing PDA application which should "sense" connection and initiate the sync process. Some of the synchronization approaches you may use are: RDA, Merge replication and even Xml Web Services if the 2 previous methods does not fit your requirements...
-- Ruslan Trifonov blog: http://xman892.blogspot.com
"Paul Aspinall" <pa**@aspy.co.u k> wrote in message news:YD******** **********@fe1. news.blueyonder .co.uk... > Hi > I have an application which runs on a desktop. > I want to synchronise the DB with a PDA app, which also uses SQL > Server 2005 (mobile and express). > > I believe that I will need to write my own synchronization > application, in order to update the data across the machines. > My questions are: > - Is there a way of picking up an event that will notify my > application when the PDA is connected to the desktop?? > - How can I connect to the PDA DB from the Desktop application?? (ie. > do I just use a connection string from the Desktop machine, but which > connects to the PDA DB??) > - Once I have this connected, I presume I will be able to compare > the data on the desktop machine, against the data on the PDA, and > update each accordingly? > > Any examples of this being done, or details of best practices for this > would be much appreciated > > Thanks >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: NetIdiot |
last post by:
I have had to install and uninstall VS.NET 2005 a couple of times because of
some errors. The SQL Server express refuses to install ... and hence I can't
most things I want to work on. I even tried installing an evaluation version
of SQL 2000.
It seems I haven't uninstalled in the right sequnce ... causing all the
problems.
Help please !!!!
|
by: Zorba.GR |
last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64
bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite
Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express
Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM
Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other
IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
|
by: Paul Aspinall |
last post by:
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server 2005
(mobile and express).
I believe that I will need to write my own synchronization application, in
order to update the data across the machines.
My questions are:
- Is there a way of picking up an event that will notify my application when
the PDA is connected to the desktop??
|
by: Paul Aspinall |
last post by:
Hi
I have an application which runs on a desktop.
I want to synchronise the DB with a PDA app, which also uses SQL Server 2005
(mobile and express).
How can I connect to the Desktop DB, from the PDA, in order to check if I
should transfer data, in my manual syncronization routine.
Any examples of this being done, or details of best practices for this would
be much appreciated
|
by: John |
last post by:
Hi
We have an internal ms access database which we need to synchronise with our
website with sql server 2005 backend which is hosted on a public host. My
question is; is there a way to keep the two databases synchronised using the
technologies built in sql server 2005 and/or access? We also have the
possibility of an in-house sql server 2000. Can this be used in anyway to
help, perhaps by moving data from in house access to in house sql...
| |
by: Peter |
last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server
2005 Express, but get the following error in the error log.
Please could someone help me....
Microsoft SQL Server 2005 Express Edition x86:
Component Microsoft SQL Server 2005 Express Edition x86 returned an
unexpected value.
***EndOfSession***? Microsoft SQL Server 2005 Express
Edition x86: Component Microsoft SQL Server 2005 Express Edition x86
returned an...
|
by: Dan Bass |
last post by:
-- Installed --
Visual Studio 2005 (.Net 2.0)
Sql Server 2005 Express
Sql Server 2005 Mobile SDK
I'm trying to add a "SQL Mobile Database" component to my Smart Device
project through Visual Studio 2005.
On one machine this works no problem (my laptop), but on my development
|
by: Wolfgang Kraus |
last post by:
Hi,
i want to create a solution which shall consist of a sql server 2005 -
data base (express edition if the following features are available by
express edition) and a mobile windows application (running on a
smartphone under windows mobile 5.0).
The sql server shall be installed on a ordinary laptop using windows
xp (not professionall edition).
|
by: jhf |
last post by:
Hi, I have developed some VB software that enables a pocket pc under Windows Mobile 2003 OS to communicate with an MS SQL Server 2005 Express database on a PC under XP, using active sync 4.2. I set the TCP/IP and ports through the MS firewall as standard and it worked. However, when I migrated the system over to a Toshiba Satellite L30 10X laptop under Visa OS., this time keeping the firewall open, I got...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |