Post List - Exegesis Spatial Data Management

Creating bootable usb vhd

Posted by 17 June 2012

You can create a vhd which is entirelt bootable from a USB stick. Notes: Only works with Win7 Ultimate or Server 2008 R2 (or later) The vhd will be dependent on the hardware of the machine it was... read more

Comments(0)

Revealed: the Identity of the ApplicationPoolIdentity

Posted by Crispin Flower 08 June 2012 Categories: IIS mojoPortal

While setting up a new mojoPortal site I tried our running the application pool with the identity “ApplicationPoolIdentity”. Previously we have tended to create a specific user account for each site... read more

Comments(1)

ArcGIS: Table of Contents problems with dual monitors

Posted by Steve Ellwood 06 June 2012 Categories: ArcGIS

Basically the user was complaining that they could not turn layers on and off in the Table of Contents (the left hand pane) but they could go in to the properties of the layer and turn... read more

Comments(0)

Inspecting web service requests from Quantum GIS with Fiddler

Posted by Crispin Flower 04 June 2012 Categories: Fiddler MapServer Quantum GIS (QGIS) WMS

When connecting to any mapping web service, such as a WMS of WFS, just occasionally things don’t work first time (or is that just me…?). When this happens it is useful to be able to inspect the HTTP... read more

Comments(0)

Multiple SQL Server log-in failures caused by connection string error - HBSMRv3

Posted by 23 April 2012 Categories: HBSMR SQL Server

A SQL Server DBA reported many login failures in his SQL logs. These failures were not apparent to system users. The connection string included the clause <Trusted_Connections=Yes>, this should have been <Trusted_Connection=Yes>. Once the connection string had been corrected the log-in failures stopped.

Comments(0)

Accessing SQL Server 2008 Express (on Win 7 OS) over the network

Posted by Laine Skinner 21 March 2012 Categories: SQL Server

I hit a problem where I needed to enable network access to SQL Server 2008 Express R2 which was on a Win7 64bit OS. the solution was previously posted at:... read more

Comments(0)

Calculating the extent of the geometry in a SQL Server table

Posted by Crispin Flower 20 March 2012 Categories: GIS (general) SQL Server

Andy Brewer passed me this, adapted from http://barendgehrels.blogspot.co.uk/2011/04/extent-of-sql-server-spatial-table.html This is a useful script, using CTEs (common table expressions) to... read more

Comments(0)

HBSMR v3.x MIDAS XML export: bad schema reference

Posted by Crispin Flower 01 March 2012 Categories: HBSMR XSLT

The MIDAS xml export from the HBSMR Monument Index form includes an out-of-date URL link for the MIDAS xml schema. This means that anybody trying to import the data into a database or other... read more

Comments(0)

Tilecache: how to stop tilecache_seed.py bailing out with HTTP 502 errors

Posted by Crispin Flower 24 February 2012 Categories: MapServer Python Tilecache

We are using TileCache http://tilecache.org/ to create caches of Ordnance Survey data of various flavours, for use in high demand web sites. We are tending to pre-seed the caches, then access them... read more

Comments(0)

How to fix orphaned SQL Server users

Posted by Crispin Flower 17 February 2012 Categories: SQL Server

When you restore a Microsoft SQL Server database on a different machine, you cannot access the database until you fix the permissions. The solution is of course common knowledge now, but I can... read more

Comments(1)

Categories

Archives