Archive for August, 2009

Good People

Fast paced and entertaining. The end is a bit of a mess. Characters seem plastic.

Good People

The Blade Itself

Started out with promise, but didn’t deliver.

The Blade Itself: A Novel

The Comedians

Strange and enjoyable book.

The Comedians (Penguin Classics)

MySql with .Net SqlDataSource on hosted server

I was getting an error saying the .Net provider could not be found when attempting to connect to a MySql db in hosted environment. If the MySql.Data.MySqlClient is not loaded in the GAC on the hosted server, you will need to add a reference in your web.config, if you want to use the SqlDataSource control.

  1.  
  2. web.config - make sure the version matches your MySqlClient version
  3.  
  4. <system.data>
  5. <DbProviderFactories>
  6. <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=5.2.7.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
  7. </DbProviderFactories>
  8. </system.data>
  9.  
  10. SqlDataSource reference
  11.  
  12. <asp:SqlDataSource ProviderName="MySql.Data.MySqlClient" ID="dsData" runat="server" ></asp:SqlDataSource>
  13.  

The Ministry of Fear

Bourne Identity meets Upstairs / Downstairs. A bit stilted in places, but not bad overall.

The Ministry of Fear: An Entertainment (Penguin Classics)

Long Time No See

Drags for bit, but soldiers on.

Long Time No See

Change column order in MySql

Too bad the MySql GUI can’t handle this, but it is what it is:

ALTER TABLE `clientpackage` MODIFY COLUMN `ParentPackageId` mediumint AFTER `PackageId`