Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005

You Can Take it With You

Syndication

News

  • Don't miss the next Windows Mobile Webcast... Unit Testing for Mobile Devices: http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032382824&EventCategory=4&culture=en-US&CountryCode=US.

We had another great webcast yesterday – thank you to everyone who attended.

A couple of quick follow ups to the webcast.


First there was a question yesterday on just where to find the SQL Server 2005 Mobile Edition Server Tools (SQL Mobile Server Tools) installation file.

The Microsoft Installer package for SQL Mobile Server Tools is copied to your machine as part of the Visual Studio 2005 installation process. The installation package is named Sqlce30setupen.msi (The last 2 letters “en” in the filename, may be different if you’ve installed a non-English version of Visual Studio 2005)

Assuming you accepted the default Visual Studio 2005 installation path, you’ll find the Sqlce30setupen.msi file in the folder
C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0.

For detailed information on setting up and configuring SQL Mobile Server tools checkout the help file, setupsqlmobile.chm in that same folder.


The other thing I wanted to mention is that there’s a lab available on MSDN that closely parallels yesterday’s discussion.

If you want to get some hands-on time with the new SQL Server 2005/SQL Mobile Merge Replication facilities checkout Step by Step: Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005


While we're on the subject of data management, I hope to see everyone at next week's (14-Dec) webcast
Intelligent Data Synchronization in a Semi-Connected Environment


Posted Dec 08 2005, 02:52 PM by jim-wilson

Comments

shelley martin wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 12-11-2005 2:58 PM
getting debug and exception errors since Framework 1 installed.

Blowing out the system, what do I do? Can't get it off of the add/remove program...framework that is. PLS. HELP
Massimo Cristaldi wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 12-14-2005 11:28 AM
Great presentation and helpful hints. Looking forward to see the sample application here.
Massimo - m.cristaldi@i4es.it
Alquin D. Cook wrote Intelligent Data Synchronization in a Semi-Connected Environment
on 12-18-2005 8:21 AM
I just saw your webcast Intelligent Data Synchronization in a Semi-Connected Environment and is was great! I was wondering when will the demo code be availiable?
Carlson Tayong wrote Intelligent Data Synchronization in a Semi-Connected Environment
on 12-28-2005 7:57 AM
Great Presentation on Dec. 14 2005. I am unable to locate the source code on this webcast. Did you post it already? If so, please direct me on how to get this source code.

Did you use web service to perform data synchronization? I wasn't sure if this was the case. Hope to hear from you soon.

Email:carlson.tayong@getatuo.com

Thank you.
Carlson Tayong
James Edwards wrote re: Intelligent Data Synchronization in a Semi-Connected Environment
on 01-04-2006 2:33 AM
Excellent webcast, but I'd love to have the source code too. I wasn't able to see the URL's you pasted into the Q&A screens. Can you post these on your blog please?

James - james.edwards@theclancygroup.co.uk
LeMaris wrote How Do I Create or Develop Screens using SQL
on 01-20-2006 11:39 AM
Hey, I really need help with this project that I am doing. How do I create or develop screens using SQL? My email address is lemaris18@hotmail.com. Thank you!
Jim Wilson wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-20-2006 1:27 PM
LeMaris;

This step-by-step Hands-On-Lab demonstrates how to add a database table to a VS2005 project as a DataSource and then build a Form using the table columns:
http://msdn.microsoft.com/mobility/windowsmobile/howto/hols/default.aspx?pull=/library/en-us/dnppcgen/html/med201_msdn_netcf_app_vs2005rtf.asp

This webcast walks through many of those same steps:
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032282428
Randy Stich wrote Intelligent Data Synchronization in a Semi-Connected Environment
on 10-27-2006 10:27 AM
Where can I find the source code for the Semi-Connected web cast?
Ian wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 11-30-2006 1:31 PM
Where can I find the code files that go with this
HOL?
Rodney Bagley wrote re: Intelligent Data Synchronization in a Semi-Connected Environment
on 11-30-2006 7:24 PM
Terrific webcast very informative, I would like to watch it again and go through the code at the same time. I was unable to locate the code anywhere, please post on your blog? Thank you.
senthil wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 06-26-2007 4:53 AM
i want sample coding for how to send a message to mobile using sql server 2005
Jim Wilson wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 06-26-2007 5:20 AM
Senthil;

I'm sorry but I don't quite understand what you are looking for. Can you describe what you're trying to achieve.

Jim
David wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-01-2008 2:40 PM
I am looking for the sample files for Developing a SQL Mobile Application with Visual Studio 2005 and SQL Server 2005
Jim Wilson wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-02-2008 5:47 AM
David;

There's supposed to be a link on the Step-by-Step document to download those files but as you've already seen - it's not there. I'm guessing that the link got messed up when they did the MSDN to MSDN2 migration.

I'm pretty sure that I have copies of the files. Let me track them down. I'll send you a link where you can download them from my server shortly. I also try to get the Microsoft folks to fix the Step-by-Step page as well.

I'll be back shortly.
Jim
Jim Wilson wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-02-2008 6:34 AM
David;

Now I remember....

We've had trouble off-and-on with downloads for various labs being available so about a year ago I put together a blog post that makes the manuals and setup files for the more commonly requested labs available for download from my server.

Checkout this blog post, and I think you'll find what you're looking for... http://www.pluralsight.com/blogs/jimw/archive/2006/10/02/39398.aspx

Let me know either way if that works for you.

-Jim
David wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-03-2008 2:18 PM
Jim,
Thanks, those are the files I needed. I'm stepping through the lesson now. Thanks so much for the time you spend creating things like this so that others may learn from them.
Jim Wilson wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-03-2008 3:25 PM
David;

I'm happy to hear that we found what you needed.

It's my pleasure to provide any assistance that I reasonably can. Feel free to follow up with any questions that may come up.

Thanks,
Jim
David wrote re: Developing SQL Mobile Apps w/ Visual Studio and SQL Server 2005
on 01-03-2008 5:37 PM
Jim,

I ran into a few problems with my configuration but I was able to fix them. Now I got to the last part using a web service and it does not exist. Did I miss something?

Exercise 3 item 5: The Web service that appears is a simple service that was installed with the files for this HOL.

What did I miss?

Add a Comment

(required)  
(optional)
(required)  
Remember Me?