473,837 Members | 1,407 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Mobile Solution with SQL Server 2005 Express edition and smartphone

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).

Which would be the best way to exchange the data between mobile device
and pc? I learned that there is a SQL Server Compact Edition for the
mobile device and that rda would be a way to exchange data - but then
i would need internet information system and this does not run on xp
home edition.

Which alternatives would you suggest me?

Thanx in advance

Wolfgang

May 4 '07 #1
4 4104
Hi,

I noticed nobody responding to my posting. Might this be the wrong
place for this topic?

Kind regards

Wolfgang

May 7 '07 #2
I know very little about SQL Server CE and RDA but it seems the alternative
out-of-the-box solution is merge replication. However, SQL Express can only
be a subscriber so you would then need then need SQL Server Workgroup
Edition instead, which doesn't run on XP Home Edition either. If Windows XP
Pro (or Windows Vista Business/Ultimate) is not an option, I think you'll
need to develop your own merge/sync solution.
--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" <wo*******@free net.dewrote in message
news:11******** **************@ l77g2000hsb.goo glegroups.com.. .
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).

Which would be the best way to exchange the data between mobile device
and pc? I learned that there is a SQL Server Compact Edition for the
mobile device and that rda would be a way to exchange data - but then
i would need internet information system and this does not run on xp
home edition.

Which alternatives would you suggest me?

Thanx in advance

Wolfgang
May 7 '07 #3
A more appropriate group for SQL Server CE questions is
microsoft.publi c.sqlserver.ce.
--
Hope this helps.

Dan Guzman
SQL Server MVP

"Wolfgang Kraus" <wo*******@free net.dewrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.com.. .
Hi,

I noticed nobody responding to my posting. Might this be the wrong
place for this topic?

Kind regards

Wolfgang
May 7 '07 #4
The two main methods for synchronizing data between SQL Server Compact
Edition and other editions are RDA and merge replication. However, I believe
both require IIS in order to work.

Two alternatives:

- Using the ADO.NET Sync Framework (still in CTP). Here are a few links with
info on that:
http://oakleafblog.blogspot.com/2006...asionally.html
http://blogs.msdn.com/stevelasker/ar...available.aspx
http://www.microsoft.com/downloads/d...displaylang=en

- Develop your own synchronization process. Depending on your requirements
it could be an easy or difficult task. For example, I had a system where
mobile users could change data in only two tables (plus data had some level
of segmentation between users). It was a pretty straight forward process to
compare and synchronize data.

You may get more help and ideas posting in microsoft.publi c.sqlserver.ce.

HTH,

Plamen Ratchev
http://www.SQLStudio.com
May 7 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1122
by: Harry | last post by:
Is it possible to write Smartphone applications using Visual C# Express 2005 Beta 2... It is not listed on the Installed templates.. Could you please let me have the download address to be able to create a Smartphone Application. Thanks Guys
3
1567
by: vul | last post by:
I've got a request from my boss to give some users the ability to connect to SQL Server database while they are on the road. I'm VB6 and VB.Net (beginner) developer. Mobile devices were not bought yet. So it depends on my research what to buy. I decided to start a simple application in VB 2005. There are 3 options for Smart Device applications: Pocket PC 2003, Smartphone PC 2003, Windows CE 5.0
8
1479
by: JJ | last post by:
My potential shared hosting platform uses SQL server 2005. I am developing on the Express version. In order to make sure I am not going to cause myself any problems when I move my ASP .net 2.0 sites (developed in Vis Studio 2005) to the host, should I be using my developers version of SQL 2005? If so, can I install it and keep my current instance of the SQL Server Express edition? Or will installing the dev version upgrade that...
2
1679
by: farseer | last post by:
Hi, I have SQL Server 2005 installed on my dev system. I am working on an app that i would like to distribute SQL Server with. SQL Server EXpress edition seem to be ideal for this. My questions are: -If i installed Express Edition, Can both SQL Server 2005 and Express Edition coincide peacefully on the same PC? -Which one will Visual Studio see? (currently i created by database using VS, which i assumed created a SQL Server 2005...
14
3050
by: Developer | last post by:
Hello All, i have recently installed VS2005 and was trying to install SQL sever 2000. I have Win XP' SP2. But when I tried installing, it only installed client tools and not the database. Can anyone please help me with this as I want to install SQL server and also wouold be grateful, if you can suggest me any workaround to dealwith this problem.(Like should I install any new OS etc). Any help would be appreciated.
2
2110
by: kress1963nov22 | last post by:
I recently purchased a good MS book ("Build a Web Site Now") by Jim Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on CD and also MS SQL Server 2005 Express Edition on the CD. A couple of questions for this newbie: Can MS SQL Server 2005 Express Edition be used in place of the older MSDE product for backend database work? I also have Visual Studio .NET (VB) 2003 (Standard Edition). How compatible are all these products...
3
6448
by: Steve | last post by:
Hi All I downloaded Sql server 2005 express SP2 and attempted to modify the Bootstrapper package files as I did with SP1 When i try to install SQL server as part of my VS 2005 deployment app I get an error at the end of the SQL server install phase 'Invalid endpoint'. (Note SQL server express gets installed OK) If I run SQL server express SP2 setup directly it I don't get the error
4
2482
by: Pratheep | last post by:
Hi, Can I compile code for mobile devices (Window Mobile 2005) using C# Express or do I need the full version of C# for mobile devices? thanks, Pratheep
2
4968
by: samadams_2006 | last post by:
Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express Edition" via the link on: http://msdn2.microsoft.com/en-us/express/bb410792.aspx
0
9843
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9682
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10875
Oralloy
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...
0
10566
jinu1996
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...
1
7806
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7001
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5848
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4474
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
3
3124
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.