Setting up ODBC data sources on 64-bit Windows Server 2008 / Windows 7 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 Posted by Crispin Flower 30 December 2009 Categories: MS Access Comments(0)
PostgreSQL simple backup and restore 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 Posted by Crispin Flower 18 December 2009 Categories: PostgreSQL/PostGIS Comments(0)
HBSMR/PACS reports fail if no default printer present 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 Posted by Crispin Flower 06 February 2008 Categories: HBSMR PACS Comments(0)
Setting Microsoft Access Macro Security Settings using the registry 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 Posted by Crispin Flower 27 February 2007 Categories: HBSMR PACS Comments(0)
How to run Mapbasic code whenever a .tab file is opened 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 Posted by Crispin Flower 31 October 2006 Categories: MapInfo Professional Comments(0)
How to check what geometry types are present in a MapInfo table 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 Posted by Crispin Flower 16 May 2006 Categories: MapInfo Professional Comments(0)
How to setup new file types in 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 Posted by Crispin Flower 26 April 2006 Categories: LibraryLink ThumbsPlus Comments(0)
How to recompile all views in 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 Posted by Crispin Flower 21 April 2006 Categories: SQL Server Comments(0)