I was helping a client upgrade their existing SharePoint Services 2 infrastructure to a shiny new 64 bit MOSS farm this week. In the process we came across a couple of problems, one trivial and one not so trivial. I've done many MOSS installs on 32 bit but this was my first 64 bit install.

Starting the installer gave the familiar response that ASP.NET wasn't enabled on IIS, please go away and fix it first. Now I am quite used to finding on a new server build that the ASP.NET v2.0.50727 extensions aren't enabled or registered on the IIS server, usually becuase the server admin has fervently applied all the updates from microsoft and hence the .NET framework has been installed before IIS. Anyhow, I opened a command prompt and issued my normal command:

only to get this answer:

The solution is that on a 64 bit server there is a second framework folder in the Windows folder called framework64. Simple, eh? So correct command on 64 bit server is:

So that was fairly easy after a short google.

The second was a little more difficult to solve. Our client had some web parts that were in use in the WSS2 sites that they wanted to use in the upgraded sites, and when we installed them although the installer completed things didn't seem to run as they should. It transpires that the web parts are written on .Net 1.1 which didn't seem to be a problem in itself they should work under WSS3 and indeed we could find people with them running ok, but the difference was again the fact that we were running IIS on 64 bit Windows 2003. So by default IIS is running in 64 bit mode and as noted in the KB article below in order for IIS to use .net 1.1 you have to run it in 32 bit mode. At this point we took the decision to leave the webparts out of the final solution and keep IIS in 64 bit mode!

From KB Article ID 894435 

IIS 6.0 supports both the 32-bit mode and the 64-bit mode. However IIS 6.0 does not support running both modes at the same time on a 64-bit version of Windows. ASP.NET 1.1 runs only in 32-bit mode. ASP.NET 2.0 runs in 32-bit mode or in 64-bit mode. Therefore, if you want to run ASP.NET 1.1 and ASP.NET 2.0 at the same time, you must run IIS in 32-bit mode.

Nowadays we all know that HTML tables are generally a bad idea for  formatting web based layouts, they bloat the source and reduce  accessibility, particularly hindering screen readers. 
 
They should be used sparingly and only really for data tabular in nature which would otherwise be  difficult to successfully replace with css alone.
 
Things get complicated when Content Management Systems come into play, to accommodate a large variety of possible content they frequently spit out a nested nightmare of table based layout.
 
Recently a few frameworks have been published which aim to provide better support for grid based layouts without resorting to tables, most noteworthy are Yahoo's yui grids, blueprint and tripoli.
 
Tripoli is not really a css grid framework as such, but aims to reduce cross browser css issues and provide a clean starting point by resetting all browsers to a common base line.
 
Blueprint goes a little further, offering full grid support, although the grid dimensions must be manually adjusted if the default settings prove unsuitable, Blueprint also includes css reset and more cross browser tweaks similar to tripoli.
 
Yahoo's yui grids is a fully comprehensive css grid framework catering for nearly all the screen resolution / grid combinations you are likely to need and like the others includes reset / cross browser fixes, it is a much heavier offering as a result but comes with plenty of examples and documentation plus a great online builder utility to generate the starting point html.
 
It can be argued that using these frameworks does force the inclusion of some non semantic html (a few extra divs), however we found this acceptable and a considerable improvement over even simple table based layouts.
 
Future follow ups to this article will examine  each framework in turn, with examples and comparisons to the normal tables based solutions.

For anybody involved in ASP.net based software development you may have noticed a suite of resources available on www.asp.net called starter kits.  I wonder though how many people have actually delved into these (I know many software companies who weren't aware of them)?

As the name suggests these starter kits are great starting point for a number of type of projects whether they are content managed websites, community websites, blogs, classified websites and so on.  We've used these as the basis for a number of developments - for example, a website that we recently developed for a property agency called Property Clever utilised the classifieds starter kit.  We did have to undertake quite a bit of customisation but I think we could reasonably estimate that the kit saved us in the region of a 3rd of the overall development timescale.  And I don't care to imagine how much time we've saved by utilising and customising the DotNetNuke CMS starter kit.

On other projects we have used components from these starter kits e.g. content manager web parts, e-commerce modules and so on.

Who says open source & Microsoft are mutually exclusive! 

A problem I recently encountered, I couldn't open any projects from Visual SourceSafe after installing Visual Studio 2008.

The answer - there is an update to VSS2005 that needs to be applied. The update fixes a number of other minor bugs also.

Download from http://support.microsoft.com/kb/943847

We have been evaluating a number of code generation tools recently & the one we like the best is a tool called SubSonic. 

Subsonic is an open source object-relational mapper for the Microsoft .NET Framework that can really speed up the development of any software project using a database for storage.

Within minutes of completion a database design Subsonic will generate all the code for your Data Access Layer (DAL) using the ActiveRecord pattern.  In addition methods to call all Stored Procedures are generated (with a single line of code). Read only objects are also created for all defined Views.  In addition, Ruby-on-Rails like Scaffolds are generated giving you an instant web interface to enter test data into your database.

Subsonic also includes some time saving web controls, the most useful of which are:

QuickTable  - a quick and easy way to instantly show data from a table in a read only, sortable, pageable (server paging for performance)  but lightweight control (no massive viewstate here).

DropDown – in instant dropdown from any database table, no additional code required.

An intuitive query model enhances productivity and reduce even quite complex queries down to a line or two of code:

Changes to your database can easily be incorporated via a web or command line based generator or for smaller sites the automatic build provider gets the job done.

The included code generation templates can easily be customised (they are simple asp.net like syntax) to cover any more specialised needs.

Having used SubSonic on a recent project (which had extremely tight deadlines) we found it an invaluable resource - reducing not only our development time, but code complexity too.  We did find the odd buglet thrown in for good measure (which you may expect from a relatively new open source project) but these were quite easy to overcome & the time savings certainly outweighed these.