- What is project Meno?- Something new to pique our interest from Microsoft
- Windows Phone 7 based upon a hybrid Win CE build?- All I can say is that when I query it programmatically, it gives up 7.x as the OS version
- Amit Chopra blogs about uninstall issues with the MIX CTP Drop- Wish I had this before went on an uninstall adventure last week.
- Install SQL Server Compact using the MultiCAB pattern
Tag Archives: SQL Compact
Speaking at devLink 2009
I will be speaking at devLink 2009! If you are not familiar with devLink, take a look at what great technical content you get over three days for only $75. Here is my speaker bio, and my sessions will be:
Windows Mobile Development*
Do you want to learn how to develop applications for Windows Mobile that are useful in your personal life, or in the enterprise? Had enough drag-and-drop demos where you build boring-looking applications? This session will include an introduction to the Windows Mobile platform, .NET Compact Framework, Windows Mobile SDKs, SQL Server Compact Edition, and frameworks from Microsoft and third-parties. The latter half of the session will discuss and demonstrate creating advanced user interfaces with .NET CF as well as tools and techniques for testing, debugging, and tuning your applications. This session expects no Windows Mobile or .NET CF experience, but will presume some Visual Studio and .NET experience.
Compact and Capable!**
SQL Server Compact Edition is an in-process database for use in applications that extend data storage capabilities to the desktop and to mobile devices. It is ideal for distributed and embedded applications and delivers essential relational database functionality in a small footprint while providing the familiar programming and management interfaces of SQL Server. This session will explore how you can leverage SQL Compact as a local data store for Smart Client and Smart Device applications. Also covered will be Visual Studio support, deployment options, ADO.NET interfaces, and synchronization options. Leave this session empowered with knowledge how to make your applications work anywhere the users are.
My sincere thanks and appreciation to the devLink speaker selection committee for selecting my abstracts. Register today and come join me in Nashville, TN from August 13 – 15, 2009.
* The WM Dev session is an in-depth session which will be a multi-hour session.
** Yes, I stole the tagline of the SQL CE team for my talk title (and think it quite apropos for the product).
Speaking at CODoDN 2008
I am delighted to announce that two of the abstracts I submitted for the Central Ohio Day of .NET 2008 have been accepted! Go to http://cinnug.org/cododn/default.aspx for details, session list, and event registration (even though the event is FREE, please do register as it helps with planning for facilities, swag, and refreshments). I hope to see you there on April 19, 2008! My sessions are:
A Quick Tour of the Windows Mobile Development in Visual Studio 2008 (Level 200)
This session will give attendees a quick tour of Windows Mobile Development in Visual Studio 2008, primarily focusing on developing with the .NET Compact Framework 3.5 against the Windows Mobile API and SQL CE 3.5. See what features are in VS2008 to enable development of Windows Mobile applications for both the hobbyist and the enterprise. This session will also discuss and demonstrate use of Windows Mobile APIs including GPS, Outlook Mobile, SNAPI, and WISP as well as SQL CE 3.5
Access to Your Data Anytime and Anywhere With the Microsoft Sync Framework (Level 300)
The Microsoft Sync Framework (MSF) is a comprehensive synchronization platform that enables synchronization, offline, and collaborative scenarios for services, applications, and devices. This session will discuss MSF, its architecture (including the default providers (Sync Services for ADO.NET, Sync Services for File Systems, and Sync Services for FeedSync)), and the mechanisms by which MSF can be extended. Demonstrations of MSF usage and building a custom provider will also be featured in this presentation
I am very excited about the Sync presentation as I can also now talk about ADO.NET Sync Services for Devices which just released CTP1!
The Mobile Minute 171
- Strong rumors abound on the news of T-Mobile USA finally rolling out 3G (UMTS) on May 1 in NYC. Here’s the scoop at TmoNews and BGR. Of course, Cincinnati is not in the top 25 markets (Birmingham ranks higher – really?), so I’ll have to wait, but hopefully not too much longer. Follow up questions: How much and will you screw us for tethering?
- Richard gives us a time saving tip about Label Vista and Zebra BT printers.
- Jim is going to be pretty busy in short order with webcasts, webcasts, and webcasts. Did I mention Jim is going to do some webcasts? The first one is Wednesday (April 30) on SQL Compact Tips and Tricks.
- From Loke (via Twitter, no less), a link to free Windows Mobile remote control software
The Mobile Minute 168
No blogging last week on account of the MVP Summit, but we’re back at it this week…
- Jon Box lists reasons for running WM 6 and WM 6.1
- Carlo Longino’s well-written piece about the mobile web, in response to the Mowser situation.
- Dan blogs about an issue with CF 3.5
- Erik EJ gives us a sample of importing SQL Compact data into Excel
- Raffael gives us four gems: A three part series on GPS Programming Tips for WM, and a post on debugging Connection Manager code.
- Pavel gives us one way to simulate a Windows service on Windows Mobile using managed code
The Mobile Minute 174
- Capacitive or Resistive (which are you?) Brandon Miniman at PocketNow discusses the different approaches to touch screens on Windows Mobile and iPhone.
- Engadget Mobile has the ever-popular HTC Touch Diamond vs iPhone comparison. Also, an unboxing of the HTC Touch Diamond from SlashPhone.
- Steve Lasker gives an overview of the now public SQL Server Compact 3.5 SP1 beta ..Compact just keeps getting better..kudos to Steve & team.
- Kevin at jkOnTheRun posts on the new Aliph Jawbone Too bad they *still* don’t use mini-USB…
- The LiveSide blog brings us news of Live Search 3.0 for Windows Mobile Contact mapping, web searching, weather, viewing Virtual Earth collections, and expanded traffic support (hey, they have Cincinnati now!). Have a previous version installed already? Launch it, then Menu > Client Update Available (should be enabled). Don’t have it yet? Point IE Mobile to http://wls.live.com
- Blackberry Thunder – BB goes touch from Electronista
- Thumbreport – Mobile news 160 characters at a time.
- Raffael has an excellent post discussing the issue of a LAP hanging a device at startup
- MobileStance discusses the possibility of Linux having success in mobile (unlike it has on the desktop). I’m apt to agree here. Although OHA will have serious competition from the LiMo Foundation now that Verizon and Mozilla are backing.
The Mobile Minute 173
- Mobile Developer Group team blog, launched by Amit Chopra. The VSD team has grown to include Silverlight for mobile and .NET CF.
- SQL Server Compact query performance – Pragya has a good post on basic query tuning.
- The VSD Team lists the excellent line up of mobile dev sessions at Tech-Ed Developers in two weeks.
- Raffael posts on languages natively supported on Windows Mobile Definitely pull down the WM6 Product reference guide.
- Jose Gallardo posts about the Clarius Orientation Aware Control June 2008 Release Candidate Go download it (and give them your feedback!). The OAC was one of the good parts of MCSF..glad to see Clarius still moving it forward.
- Steven Pratschner posts a summary of his CLRProfiler / .NET CF series. Must-read posts…
- Orb + iPhone
SQL Server 2005 Compact Edition Official Release!
Microsoft has now RTW’d (release[d] to the web) the final bits for SQL Server Compact Edition (SQLce) 2005 (aka SQLce 3.1):
- Microsoft SQL Server 2005 Compact Edition
- Microsoft SQL Server 2005 Compact Edition Server Tools
- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1
- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit
- Microsoft SQL Server 2005 Compact Edition Books Online
Go get the bits and be certain to read the associated KB articles.
The Mobile Minute 142
Software / Hardware
- NewsGator Mobile is now in public beta. Check it out. Thanks to Neil Cowburn for the link.
- Jason Fuller of the Windows Mobile team gives us some guidelines for setting up GPS on WM5
Development
- SQL Server 2005 Everywhere Edition is now in CTP (via Steve Lasker) and from the SQL Server Everywhere blog. Download here. BOL is here. Here’s one piece of the functionality that I love: “Full support for all of the Sql Mobile features, including the SqlCeResultSet and RDA”. Sweet.
- P&P’s Mobile Client Software Factory (MCSF) is has reached CTP stage.
- Alex Yahknin shares how to make a .NET CF label control transparent. …and how to use MSXML2 in .NET CF 2.0
- John Kennedy tells us about Adapt Your App – a collection of items to help you make sure that your app adapts to the latest screen resolutions and orientations. Here’s a list (nicely organized by OS and resolution) of emulator images for Device Emulator 1.0 Speaking of.. here is a Standalone Device Emulator 1.0 that contains WM5.0 images with MSFP
- Also from John Kennedy is a link to the MobileDeveloper wiki that gives us some guidelines for writing Ajax apps targeted to Windows Mobile devices.
- Check out the Windows Mobile Starter Kits And don’t forget to check out the eHow-Tos – see John Kennedy and Jenny Kays (they’re swell!) and other folks and learn a thing or two!
- Neil Cowburn welcomes us to the new OpenNETCF
- Peter Foot tells us how to disable the touch screen
In Other News . . .
- … Since I last blogged, Scoble has left Microsoft. Good Grief!
Installing SQLce 2005 Tools for VS2005 SP1
Last week, I attempted to install the SQL Server 2005 Compact Edition Tools for Visual Studio 2005 Service Pack 1 and received the following error message:
The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.
How did I work through this issue? I did a repair on my Visual Studio 2005 [Team Suite] installation and then re-installed Visual Studio 2005 Service Pack 1. After this, I attempted the SQLce VS tools install (SSCE31VSTools-ENU.exe) again. Success!
Of course, performing a repair install on Visual Studio is something we would all rather avoid (and the SP1 re-install). By the time I went to perform the install on a second dev box, I found a better way:
From the original Visual Studio installation media, locate the \WCU folder and install SQL Mobile from there. After that is complete, retry the SQLce 2005 VS tools install. (credit to Amit Chopra from the Visual Studio for Devices team for the tip). For more, check out this thread from the sqlce newsgroup in which fellow MVP Ginny Caughey answers questions.
If you want the download links for all the SQL Server Compact Edition 2005 bits, check out my prior blog post where I list all the downloads.
