exeGesIS Spatial Data Management


exeGesIS knowledgebase

The exeGesIS knowledgebase supplements our product manuals and training materials with notes and tips from our development team and product consultants.

Using cloudscribe with Identity Server 4 with a SQL Server store on .Net Core 2 MVC securing APIs 

Posted by James Perrins 03 November 2017 Categories: .Net Core API Cloudscribe Identity Server 4 Security SQL Server Visual Studio
Well that’s a bit of a mouthful of a title – but it does describe what I was trying to do, and I didn’t find it easy. It’s not that complicated when you know how, but there are an awful lot of... read more

How to link SQL Server / RDBMS tables into MS Access without a DSN 

Posted by Crispin Flower 30 March 2017 Categories: MS Access SQL Server
Linking tables from RDBMS like SQL Server into an Access front end doesn't need an ODBC DSN to be configured, it can be done with a one-liner. I’m just posting this here because I keep having to look ... read more

Opening ESRI Personal Geodatabases in QGIS 

Posted by Steve Ellwood 01 March 2017 Categories: ArcGIS GIS (general) Quantum GIS (QGIS)
In the more recent 64-bit versions of QGIS it is no longer possible to open ESRI personal geodatabases using the 'Add vector layer' functionality. However, it is possible to enable access to personal ... read more

GeoServer WFS fails on SQL Server tables/views with GUID data type 

Posted by Crispin Flower 11 January 2017 Categories: GeoServer OGR/GDAL SQL Server WFS
Just a quick note that might be useful to some. The problem... If you publish a SQL Server (in this case 2014) table or view with a GUID field using GeoServer (version 2.10), it will fail to... read more

A regular expression for numbers from 0 to 100 

Posted by Crispin Flower 29 July 2016 Categories: ASP.Net Regular expressions
I've been creating a web questionnaire (using the Forms Wizard module for mojoPortal CMS) that includes some questions where the answers were to be expressed as integer percentages. How to validate... read more

How to change the port for GeoServer on Windows with Jetty 

Posted by Crispin Flower 19 April 2015 Categories: GeoServer IIS Windows Server 2008
Faced with the task of upgrading a production GeoServer under heavy constant use, I decided to install the newer version alongside first, migrate the content, then make the switch when I was happy... read more

Troubleshooting issues with VSS from backup chain and SQL Server 

Posted by James Perrins 12 March 2015 Categories: SQL Server
Symptoms: BackupChain fails almost as soon as it starts when backing up SQL Server VM SQL server VM Application log is riddled with errors Diagnostics: Use VSSDiag You can start by using the VssDiag... read more

How to do a typeahead incremental search control in Microsoft Access 

Posted by Crispin Flower 11 January 2015 Categories: MS Access UXD VBA
When a user needs to find an existing record or value by typing something in a box, it is well recognized that a "typeahead" or incremental search is a powerful and user-friendly solution. Of... read more

Confusion when renaming SQL Server views 

Posted by Timothy Derbyshire 05 December 2014 Categories: SQL Server

Renaming views in SQL Server Management Studio can lead to unforseen consquences later, such as views failing to recompile or having their structure changed without warning. This post explains the causes of these problems and some potential solutions.

... read more

WMS/WFS down when a GeoServer store is disabled after Windows updates 

Posted by Crispin Flower 13 November 2014 Categories: GeoServer PostgreSQL/PostGIS SQL Server
Last night some of our servers restarted after scheduled updates, and we awoke to warning emails that some of our GIS web services were down. The affected WMS/WFS services were from GeoServer, so we... read more
Page 1 of 13 1 2 3 4 5 6 7 8 9 10 > >>