Yesterday when the Microsoft made the RTM version of Office 2010 available I downloaded and installed it.  I know – shocking news.

The question however is did I have any issues?  The short answer is yes, but none that were the fault of Office.

The first issue was that I decided to move to the 64-bit version of Office instead of the x86 version.  Unfortunately what I found was that the 64-bit installer won’t upgrade or automatically uninstall the 32-bit version of Office.  It gives you a warning that you can’t install until you manually uninstall your 32-bit Office applications – no side by side installation. 

No worries, I removed my 32-bit copies of the Beta as well as my hotmail connector (I use a Windows Live address my primary professional email address.)

Following the uninstall the install went fine.  No issues with getting the new 64-bit version installed.  I then opened Word and Excel – no problems.

Then I opened or should I say ‘tried to’ open, Outlook.  I got a notice that I needed a connector to correctly open my mailbox.  That’s it, with that message Outlook said ‘goodnight’. 

So off I went with Bing to get the Hotmail Connector for Outlook, which historically was 32-bit.  Bad news again, the 32-bit Outlook hotmail connector won’t install with 64-bit Outlook.  It gives a message that it’s only compatible with Office 2003 or 2007.

I sent a note off to some friends on the MVP list and described my issue and fortunately one of them was able to point me to the 64-bit version of the Hotmail connector for Outlook.  Its a Beta, but it installed and my mail is once again available.  The location of the 64-bit connector is:

http://www.microsoft.com/downloads/details.aspx?familyid=16BAB660-54D8-4129-91C3-D86FF0D996E9&displaylang=en

Hope this helps anyone else with a similar issue.

So in the process of setting up my demonstration virtual machine for VSLive I pulled down the materials from the CodePlex site for OBA Sales.  What I realized in the process was that the custom database wasn't included in the materials.  Fortunately as I noted in my earlier post a copy of the database was available from the Wrox site.

I was able this morning to get a new copy of the AdventureworksVSTO database uploaded.  It's a .bak backup file that you will need to restore and it was zipped before uploading.  The download is now significantly larger.

Next updating the current XML web service to be a full on WCF service to generate the documents.  I'll let you know when it's ready.

Thanks to those who attended my session on working with VSTO and SharePoint today at VS Live!  As a reminder all of the code associated with my session is available for download from CodePlex.  Keep in mind that you'll need to update the connection strings in each of the projects (excluding the OFR project which doesn't connect to the database) in order to run the code locally.

The sample database associated with the applications isn't currently part of the CodePlex project, however I will update a copy this weekend after I get back from San Francisco.  Currently you can get a copy of the baseline database from the Wrox site associated with the Professional Office Business Application Development: Using Microsoft Office SharePoint Server 2007 and VSTO book.

This is one of those 'hey look at me' posts that always make me feel like... well if you recognize the title of the movie that the quote which is the title of this movie comes from - that pretty much sums it up.

Anyway a few 'ads'. 

First off, I have a new article available over at SQL Magazine.  It's a very introductory article to LINQ for SQL so if you are looking for a good starting point for just getting started with LINQ, here's a short article that might be of assistance: http://www.sqlmag.com/Article/ArticleID/98205/sql_server_98205.html

The second item fits the post a bit better.  Back in the first Quarter I signed on to do another book - yes my wife is ready to kill me - which since she is pregnant get's the pregnancy multiplier (we're currently around 7 or 8 so the danger level is getting pretty high).  At any rate if you are interested it's still way out in the future - like October 2008 - if "we" (me) make "our" (my) final due date - here is the page: http://www.amazon.com/o/ASIN/0470377313/105-1544171-6096430

As you can note on that page this next book is an Office Business Applications book.  Of note, it will have both C# and VB samples (ok VB sample - but more on that later) and covers using WPF with Outlook Form Regions and Excel not to mention server side document generation.  That's the good news - the bad news - well I'm late on my chapters - of course that's pretty typical for me - the question is can I catch up in the next few weeks - especially given the increasing pregnancy multiplier...

Finally, I thought I should mention that my last book is finally getting read to be available.  At 1600 pages it pretty much is a phone book, and it should ship for the first week of May which apparently is fast approaching: http://www.amazon.com/Professional-Visual-Basic-2008-Evjen/dp/0470191368/ref=sr_1_1

 

So in the past I've written articles that talk about how the web as an application model is peaking for certain types of application models.  Specifically that while the 'reach' of web applications - ie. the way that even now I can be sitting in a Del Taco in Riverside (where it is 108 degrees farenheit) updating my blog just prior to heading over for a user group meeting, provide a powerful paradigm.  This isn't going to disappear and isn't to be discounted, but it isn't enough.  New technologies such as Silverlight and WPF will help extend the life of the web as a UI, but the reality is, web services allow me to use a rich client vs. a web site for editing my comments and then just submit the data to the server. 

Most enterprise  applications (as opposed to public facing) continue to be rich client applications. In the future there will still be many such applications which are written from the ground up, expecially those which are focused more on sizzle then steak.  But I feel that the new paradigm for actual business applications will be to leverage someone else's User Interface for much of the framework with a minimalist custom set of controls.  A couple years ago the common 'UI design pattern' we heard from smart client customers was for them to ask for a user interface based on Outlook.  This is still the case but things are shifting, you see instead of asking for a client based on Outlook - instead we are starting with Outlook as the client and just customizing it for the needs of the organization.

Visual Studio Tools for Office (VSTO) have been around since .NET 1.x but as I have been informed many times - haven't really taken off as some expect.  However, like so many things, until the rest of the infrastructure to support a technology is in place even a great tool gets only limited use.  In the past VSTO has primarily focused on the document.  Specifically it started as a replacement for VBA and the document centric customizations of VBA and Macros... but with Office 2007 and Visual Studio 2008 (Orcas) - well this isn't the same model.

An OBA is an Office Business Application, in short it is an architectural model which leverages the full Office System to implement custom business solutions.  The first key enabling technology is of course SharePoint aka Microsoft Office SharePoint Server 2007.  I'm not a big fan of SharePoint as a development platform, but as a host for documents and document templates it is unparalleled.  By marrying key document templates with a web site you gain the benefit of a web application with a rich client.  I'll post more in the future on some of the key enabling technologies which can then be built on this - think about Add-In's and custom message contents but the key is now that we have a solid server combined with a host of new tools the OBA model leveraging VSTO is a very viable solution framework.

Don't think so - well take a close look at Team System.  Team Explorer is in part an OBA, yes there is a 'custom' add in for Visual Studio which isn't part of Office - however, I know for a fact that when I start working with tasks, work items, bugs etc. in TFS I do it all with Excel.  Why because Team Explorer's custom interface pieces aren't natural to me, but the add-ins for Excel and the way that the forms are hosted on SharePoint and retrieve and update data from SQL Server provide me a user interface which is effective.  So when you are thinking about how to engineer that next big smart client application don't discount the value of being able to leverage the Office System as the plumbing for much of what you'll do.

Tonight I'll be presenting on a demo OBA solution which InterKnowlogy helped Microsoft develop to highlight some of the new features of VSTO 2008.  This is a powerful architecture and I'm expecting to do additional presentations similar to the one I'm doing tonight for the Inland Empire .NET User Group.  I grabbed a screen shot of their homepage describing tonight's presentation iedotnetug_org.JPG (172.5 KB) but feel free to visit their site (http://www.iedotnetug.org) or stop in for a meeting in the future. 

As you can tell I'm using this morning to really catch up on my blog posts.  I've been meaning to update them but things were busy and then I was sent on this assignment called 'vacation'.   Turns out I really enjoyed that assignment... I need to post a couple picks of my wonderful neice and nephew, but I'm all ready for a repeat. 

But for now I just wanted to send out a quick reference to a new technical book regarding Visual Studio Tools for Office(VSTO).  The book is being published in September, but I was fortunate enough to get an early look because InterKnowlogy has been doing alot of VSTO work lately and Tim Huckaby (our CEO) spoke at Tech Ed on this topic.  So after Tim took a look at the book so he could say what he thought of it he passed it to me and I put it to use.  The book covers not only VSTO but integration with Microsoft Office 2003 from .NET 2.0.  It talks about how to call office from your application and just as importantly how too build really powerfull VSTO apps.  More importantly it doesn't draw a line in the sand with Word and Excel, this book goes into customizing Outlook and Infopath.  This book covers stuff that some of our IK developers have had to learn the hard way.

The book will be released mid september but there is Addison-Wesley and a portion of Chapter 1 is posted here: http://www.awprofessional.com/title/0321334884

The version of Chapter One I previewed is noticably longer and the book comes with plenty of code samples.  Although it's written in C# instead of my preffered language of Visual Basic I definitely recommend it for anyone who is looking to leverage the power of Office 2003 in their custom application.  Converting samples from C# to VB just helps you really understand the code.