Timothy Walters, Ben Laan and I will be the speakers at tomorrow’s Adelaide SQL User Group meeting.
We’ll be sharing some of our experiences using SQL Server 2008, including:
- Change Tracking
- Integrating with legacy SQL 2000 databases that have no referential integrity worth speaking of
Register if you’d like to come along – hope to see you there!
I finally decided on a new TV for the home theatre, after my attempts at getting the 1970’s era CRT to work failed.
I chose a Kogan 1080P-32 – a Full-HD LCD TV. Importantly, it supports HDMI input and as the name suggests can display full high definition – 1080 Progressive. Kogan are an online store, so it did mean that I had to order something sight-unseen – a bit scary when you’re spending a reasonable amount of money. Happily, the TV was couriered quickly and safely and I haven’t had any problems with stuck pixels.
I then had to connect the screen to the home theatre box. Some retails sell HDMI cables for more than $100, but instead I bought a 5m cable from MSY for $10.
It seems to work quite well with Media Center. The only issue I’ve had is that when you close Media Center and do other stuff in Vista, the display is a bit blurry. I’m not sure if that’s a problem with the graphics card or something else. Not a huge problem but it would be nice to sort it out.
I then hired a Blu-Ray DVD to try out. This also worked ok, once I realised I hadn’t installed all the PowerDVD bits. For some reason, PowerDVD doesn’t integrate with Media Center, so you either have to manually swap over to PowerDVD, or install another player like ArcSoft's TotalMedia Theatre. This is a bit better, though it still isn’t completely integrated as the stop/play buttons on the remote control didn’t work properly.
The net result is that everything is working well. The monitor that we were using for the TV is now back on my home computer, and we’re now looking around furniture shops for a nice home entertainment unit to put it all in.
One sad note – A couple of weeks ago we were watching TV when the machine started locking up (always in the most crucial part of the TV program!). I eventually discovered that my 1Tb WD disk had developed a bad case of badsectoritis. It was just over 1/2 full and had been fine up until now, so I can only guess that maybe there were a bunch of bad sectors in the second half of the disk that we started to hit, or some kind of electronic malfunction. In any case it will need to be sent back under warranty to get sorted out. In the meantime we can survive on the other disk.
For those who like to read in a more linear fashion, the PDF of the June 2008 release of Composite Application Guidance for WPF is now available.
The application we are developing will be installed at different locations and consequently will need to connect to a local SQL Server instance.
Rather than build separate configurations and installers for every site, we’re planning to store this information centrally. The application then uses a web service to retrieve the appropriate configuration information for its site.
As we are using NHibernate/ActiveRecord with the database configuration being loaded though the Castle ActiveRecord Integration Facility, the database name is indicated through naming a connection string (by specifying the config key ‘hibernate.connection.connection_string_name’). The difficulty is that this appears to be loaded the first time Windsor loads the config file. What we need is a way of replacing the connection string that was read from the app.config file with one that we’ve retrieved from the web service.
The main problem that needed to be overcome is that .NET doesn’t allow you to change the connection strings after they are read from the app.config file. If you try to do it, it will throw a ConfigurationErrorsException with the message “The configuration is read only”. The following code illustrates this:
var settings = ConfigurationManager.ConnectionStrings;
settings.ConnectionString = "blah";
Steve Michelotti describes how you can override ConnectionStringsSection’s IsReadOnly method, which would be fine for custom configuration sections but doesn’t work in this case as the class is sealed.
Dmitry suggests another approach, though at the time it was just an untested idea. ConnectionStringSection inherits from the abstract class ConfigurationElement. Using Reflector you can see that the default implementation of IsReadOnly just returns the value of a private field _bReadOnly, which is set to true.
We use reflection to locate the private field _bReadOnly and then force it to be false. eg.
var settings = ConfigurationManager.ConnectionStrings[ 0 ];
var fi = typeof( ConfigurationElement ).GetField( "_bReadOnly", BindingFlags.Instance | BindingFlags.NonPublic );
settings.ConnectionString = "Data Source=Something";
This is a bit of a hack and obviously would fail should Microsoft choose to change the name of this private field in the future, but as long as we do this before the container loads the configuration, it means that in the example above, any reference to the first connection string will return our new value.
An alternate approach might be to implement a custom NHibernate configuration provider, but I’ll leave that exercise to the reader :-)
Our CruiseControl.NET build server is running Windows 2008. Today I added a WiX project to generate an MSI for one of the projects. This ran fine on my local machine.
I followed the instructions from the WiX 3.0 help file on “Integrating WiX Projects Into Daily Builds” with one exception - Step 2 adds a new section to the .wixproj file, but I had to remove the $(WixToolPath) prefix from the WixTasksPath element. eg.
I then checked this in and watched the build die with the following error:
light.exe (,): errorLGHT0217: Error executing ICE action 'ICE01'. The most common cause of this kind of ICE failure is an incorrectly registered scripting engine. See http://wix.sourceforge.net/faq.html#Error217 for details and how to solve this problem. The following string format was not expected by the external UI message logger: "The Windows Installer Service could not be accessed. This can occur if the Windows Installer is not correctly installed. Contact your support personnel for assistance.".
Others have had similar problems, and the solution seems to be to make sure that the account the build process runs as is a member of the local Administrators group.