Post List - Exegesis Spatial Data Management

Setting up ODBC data sources on 64-bit Windows Server 2008 / Windows 7

Posted by Crispin Flower 30 December 2009 Categories: MS Access

Windows Server 2008 x64 and Windows 7 x64 have both 32 bit ODBC data sources and 64 bit ODBC data sources. They are managed separately. Setting up a 32 bit ODBC connection in Windows Server 2008 x64. ... read more

Comments(0)

PostgreSQL simple backup and restore

Posted by Crispin Flower 18 December 2009 Categories: PostgreSQL/PostGIS

To backup in verbose text format (from Windows/DOS command line): pg_dump -C -f backupfile.sql -h localhost -p 5433 -U postgres databasename To restore backup in verbose text format (from... read more

Comments(0)

HBSMR/PACS reports fail if no default printer present

Posted by Crispin Flower 06 February 2008 Categories: HBSMR PACS

If trying to print a report in HBSMR or PACS (or any other MS Access application) gives an error message along the lines of "cannot find report or form MonFullRpt", even though this report does... read more

Comments(0)

Setting Microsoft Access Macro Security Settings using the registry

Posted by Crispin Flower 27 February 2007 Categories: HBSMR PACS

If the Macro Security setting cannot be changed through the Access application (can be disabled in the installation), this registry setting can help. To set the security to... read more

Comments(0)

How to run Mapbasic code whenever a .tab file is opened

Posted by Crispin Flower 31 October 2006 Categories: MapInfo Professional

Mapbasic code can be run whenever a .tab file is opened by inserting code in the .tab file just after the header. e.g. ... !charset WindowsLatin1 Run Application... read more

Comments(0)

How to check what geometry types are present in a MapInfo table

Posted by Crispin Flower 16 May 2006 Categories: MapInfo Professional

How to check what geometry types are present in a MapInfo table In MapInfo Pro, the following query will summarize the contents of a layer by geometry type: (type this into the... read more

Comments(0)

How to setup new file types in LibraryLink/ThumbsPlus

Posted by Crispin Flower 26 April 2006 Categories: LibraryLink ThumbsPlus

To register a new file type in LibraryLink/ThumbsPlus do the following (example: ".mdb" files): Open ThumbsPlus Go to "Options=>Preferences" and activate the "File... read more

Comments(0)

How to recompile all views in SQL Server

Posted by Crispin Flower 21 April 2006 Categories: SQL Server

DECLARE @viewname varchar(128) DECLARE @viewname_header varchar(128) DECLARE vnames_cursor CURSOR FOR SELECT name FROM sysobjects WHERE type = 'v' OPEN vnames_cursor FETCH NEXT FROM... read more

Comments(0)

Categories

Archives