Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Reference Guide
Main menu
Connect to Database
Connecting to databases directly without client libraries installed
Connecting to an Oracle database
Connecting to a DB2 database
Options
General options
Thumbnail options
Hex view
The work area
SQL editor
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Post-processing Office files
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data
DICOM images
Hidden Excel worksheets

Version history

Version 7.4 (23 January 2018)

· Added command line option to register product during installation.  


Version 7.3 (23 September 2017)

· Added option to turn off low memory warnings.  
· Added support to identify SQL Server 2017 instances.  
· Reduced low memory warning CPU utilization.  


Version 7.2 (6 February 2017)

· Fixed bug with binary export not recognising tags in the folder value.  
· Improved license activation messages.  
· Added support to export non-standard jpeg images stored by Cashwise.  


Version 7.1 (28 July 2016)

· Improved speed in displaying large images.  
· Improved detection of bitmap images in OLE Object fields.  
· Query results now display file name of OLE Object package.  
· Improved query results display performance.  
· Improved support for embedded Acrobat documents.  
· Improved detection of dicom images.  
· Fixed display of photoshop (psd) images.  


Version 7.0 (6 May 2016)

· Improved support for embedded Access OLE items.  


Version 6.9 (7 April 2016)

· Added support for svg, swf, webm, mp4, m4a, m4v, mkv, flv, mov, and 3gp files.  
· Fixed bug with some OpenOffice and Microsoft Office files wrongly identified as zip files.  


Version 6.8 (23 March 2016)

· Added support for OpenOffice Writer, Calc, and Impress files (odt, ods, and odp).  
· Added support for ePub files.  
· Fixed bug with wrongly identifying Microsoft Office files as zip files.  


Version 6.7 (17 Decenber 2015)

· Added filter to results in Export Progress window.  
· Fixed text highlighting issue in Export Progress window.  


Version 6.6 (23 October 2015)

· Added support for Outlook message files.  
· Added option to run a query to retrieve only the column metadata for use in the Export Wizard.  
· Fixed issue with false low memory conditions alerts.  
· Miscellaneous GUI improvements and speed-ups.  
· Fixed error when saving SQL editor layout.  


Version 6.5 (29 May 2015)

· Added option to change SQL editor font and font size.  
· Added support to export decimal/numeric values to spreadsheets/text files.  
· Fixed bug when saving scripts containing non-standard ASCII characters.  


Version 6.4 (22 January 2015)

· Improved support for extracting bitmap images stored as OLE data.  


Version 6.3 (27 May 2014)

· Fixed issue with command line interface when script file is stored in a protected system folder.  
· Fixed bug with image effects window on Windows Vista and newer.  


Version 6.2 (14 May 2014)

· Added support for Access databases.  
· Added support for FILENAME format specifier for text columns. This allows you to extract only the file name portion from a fully qualified file name value.  
· Fixed issue with using the command line interface to run SQL Image Viewer scripts.  
· Fixed issue with using '{ts' values in SQL Server scripts.  
· Fixed some GUI inconsistencies with large fonts.  


Version 6.1 (20 March 2014)

· Tables can be dragged from the database objects browser onto the SQL editor to quickly form SQL commands.  
· Image results window no longer displays memo fields.  
· Fixed bug with naming duplicate files contained in OLE containers.  
· Fixed bug with extracting files from OLE containers.  
· Fixed bug with extracting images from OLE containers.  
· Fixed bug with exporting large result sets.  


Version 6.0 (16 March 2014)

· Added direct PostgreSQL access option. PostgreSQL ODBC drivers are no longer required.  
· Added support for direct MySQL and Oracle access.  
· Added support for SQL Server Compact databases.  
· Result sets now display details about binary data and size.  
· Improved GUI, now supports Windows Vista and Windows 7 themes.  


Version 5.5 (6 February 2014)

· Fixed memory warning bug on 64-bit systems.  
· Added option to export images in TIFF format.  


Version 5.4 (12 September 2013)

· Fixed bug with validating Excel file names in Export Wizard.  


Version 5.4 (24 July 2013)

· Added option to export rich text format (RTF) files.  
· Added option to scan character columns for HTML, RTF and XML content and export them to files.  
· Added option to export data from character columns.  


Version 5.3 (19 April 2013)

· Improved identification of Word and Powerpoint files created by Open Office.  


Version 5.2 (23 November 2012)

· Added support to export data to tab-delimited or comma-delimited text files.  


Version 5.1 (8 November 2012)

· Added support to extract files from OLE Structured Storage/Microsoft Compound Document data.  
· Fixed bug with exporting files embedded in Access-OLE data.  
· Fixed bug with exporting data to Excel spreadsheets where the text length exceeds 32767 characters.  


Version 5.0 (8 October 2012)

· Added option to run extenal applications to process exported files in the Export Wizard.  


Version 4.9 (3 July 2012)

· Now exports 'text' type fields to Excel worksheets.  
· Added option to create multiple Excel worksheets or multiple Excel files, to reduce size of created Excel files.  


Version 4.8 (8 May 2012)

· Fixed issue with number formatting when preceded by a date/time column in naming of files.  
· Fixed bug when exporting unicode characters to the Excel spreadsheet.  
· Fixed formatting of dynamically generated names when preceded by a datetime field.  
· Added support for export of large integer fields to Excel spreadsheets.  
· Stop reporting skipped binary data as errors.  


Version 4.7 (5 April 2012)

· Fixed default SQL Server instance name for named instances.  


Version 4.6 (17 March 2012)

· Fixed display of tables containing image/binary data for SQL Server 2005 instances and newer.  


Version 4.5 (6 February 2012)

· Show PostgreSQL help topic when error on data length is encountered.  
· Export process will now create new sub-directories when required.  


Version 4.4 (12 January 2012)

· Improved identification of OLE structured storage data.  
· Improved extraction of images from OLE data.  


Version 4.3 (31 October 2011)

· Fixed error in Excel result set export function in trial mode.  
· Fixed miscellaneous GUI errors.  


Version 4.2 (16 September 2011)

· Added option to export result set to an Excel spreadsheet, with hyperlinks to exported images/binary data.  


Version 4.1 (8 June 2011)

· Fixed various GUI errors when running on Windows 7 with medium sized fonts.  
· Fixed error when results text is selected but no results are available.  
· Fixed error where the results page is displayed when a connection is first opened.  


Version 4.0 (7 January 2011)

· Added option to resize images during export.  
· Automated exports via the command line interface now supports image processing functions.  


Version 3.7 (9 December 2010)

· Improve support for Oracle 11g 64-bit versions.  
· Added post-processing options to exported Microsoft Excel files:  
- unhide workbook  
- protect workbook with password  
 
· Added post-processing options to exported Microsoft Word files:  
- protect document with password  


Version 3.6 (3 September 2010)

· Export now supports using tags in the export folder.  
· Improved support to extract Microsoft Office documents from Microsoft Access OLE fields.  
· Improved support to extract packages from Microsoft FoxPro OLE fields.  


Version 3.5 (5 August 2010)

· Added limited support to display DICOM images.  


Version 3.4 (11 June 2010)

· Added support to identify Microsoft Access OLE fields.  
· Added support to extract Microsoft Office, Acrobat and images stored in Microsoft Access OLE fields.  
· Last used ODBC parameters are now saved for use in subsequent sessions.  


Version 3.3.0.83 (30 April 2010)

· Command line interface to support automated exports now supports the following database servers:  
- Firebird  
- MySQL  
- Oracle  
- SQL Server using both SQL authentication (in addition to Windows authentication added in 3.0.0.75)  
- SQLite 
· Database error messages are now reported in the logs when running automated exports.  
· Bug fix: SQLite queries sometimes wrongly returned empty results.  
 

Version 3.2.0.81 (16 April 2010)

· Bug fix: single image view sometimes started in magnifier mode.  


Version 3.2.0.80 (28 February 2010)

· Added CROP option to command line interface.  
· Added option to not create default log files (NODEFAULTLOG) for command line interface.  
· Added option to delete old log files (KEEPLOG) for command line interface.  
· Added option to skip appending file extensions.  
· Added option to display only failed items in the 'Export Progress' window.  
· Bug fix: empty or null columns are now skipped during the export process.  


Version 3.0.0.75 (21 December 2009)

· Added command line interface to support automated exports.  
· Added option to generate unique file names when the naming convention results in duplicate names.  
· File extensions are no longer repeated when the generated file names already contain the correct extension.  
· Bug fix: export process was hanging on damaged zip files.  


Version 2.5.0.142 (20 November 2009)

· Added option to compress images exported in PDF format.  


Version 2.5.0.140 (13 November 2009)

· Added support to export images to PDF format.  
· Bug fix: random errors when the mouse pointer was over the retrieved images while the SQL statement was running.  


Version 2.5.0.138 (5 November 2009)

· Bug fix: random SetFocus errors when editor is inactive.  


Version 2.5.0.134 (6 September 2009)

· Added support to recognise unprotected Microsoft Word, Excel and Powerpoint 2007 files.  
· Double clicking on an unsupported binary type now automatically opens the hex viewer.  
· Bug fix: access violations sometimes occurred during painting of images  
· Bug fix: files were sometimes wrongly identified as mp3 files.  


Version 2.4.0.132 (3 August 2009)

· Added support to use date time fields in the file naming convention.  
· Added support for datetime format specifiers.  
· Added option to treat strings as UTF8 encoded strings for Firebird databases.  
· Bug fix: integrated update caused SQL Image Viewer to be opened twice after the update process.  


Version 2.3.0.119 (5 July 2009)

· When exported images use the same file name, the repeated file names are listed at the end of the export process.  
· Added option to display results in text mode.  
· Bug fix: in certain cases, application takes a while (2 to 10 seconds) to close.  


Version 2.2.0.113 (18 April 2009)

· Bug fix: application wrongly displayed Images window when a new connection was made.  


Version 2.2.0.112 (10 April 2009)

· Added option in popup menu to expand or collapse all grouped images.  
· Added option to copy individual values from query results to clipboard.  
· Hex viewer now uses the last view settings of the current session.  


Version 2.2.0.110 (1 March 2009)

· Bug fix: valid licenses were not recognised after the trial expiry date.  
· Bug fix: image description columns which contained null values caused an exception.  
· Bug fix: rows with a mix of image and binary data columns sometimes caused an exception when matching the selected image to the relevant data row.  


Version 2.2.0.109 (20 February 2009)

· Changed cursor to hour glass when saving images running time consuming transformations, for better visual feedback.  
· Bug fix: images were allowed to be saved without a proper file name entered.  


Version 2.2.0.108 (12 January 2009)

· Added magnifier mode in image viewer.  
· Added option to strip all image metadata from jpeg images during export, including EXIF data and EXIF thumbnails. In most cases, this can reduce the final size of the image.  
· Added drop-down list to allow quick navigation between the editor, results window, and any other open windows.  
· Added support for identifying HTML and XML files.  
· Bug fix: when an image was opened using both the image viewer and hex viewer, the wrong window was sometimes wrongly selected.  


Version 2.1.0.98 (12 December 2008)

· Added ability to export binary data using the Export Items wizard.  
· Improved time taken to open Export Items wizard when only binary data is present.  
· Allow copying of table names in browser to clipboard.  
· Bug fix: export progress dialog was displaying clickable links for non-existent files.  
· Bug fix: export button was enabled only when 'Results' tab was selected.  
· Bug fix: repeatedly saving individual binary files did not use a sensible file extension for the given file type.  


Version 2.0.0.88 (1 December 2008)

· Added support for Oracle 10g.  
· Added support for ODBC drivers.  
· Added highlighting support for PostgreSQL and DB2 databases connected via ODBC.  
· Added browser that lists all tables containing binary/blob data, for DB2, MySQL 5, PostgreSQL, Oracle, SQL Server and SQLite databases.  
· Added support for identifying binary data of the following file types: pdf, zip, rar, 7z, bzip2, gz, wav and mp3.  
· Added experimental support for identifying binary data of the following file types: doc, ppt, xls.  
· Added support to save unidentified binary data.  
· Added hex viewer to display binary data.  
· Allow large integer fields to be used in file naming convention.  
· Bug fix: application exception when result set contained mandatory fields and field type was not supported.  
· Bug fix: results grid does not scroll to the right when selection is made with the keyboard.  


Version 1.5.0.22 (8 November 2008)

· Added support for MySQL 4.1.22 and 5.0.67.  
· Allow contents of memo fields shorter than 256 characters to be displayed.  
· Allow memo fields to be used in file naming convention.  
· Allow unicode fields to be used in file naming convention.  
· MRU list now includes newly saved files.  
· Bug fix: memo fields were wrongly identified as containing image data.  
· Bug fix: SQL Server unicode field names were wrongly displayed.  
· Bug fix: controls were disappearing in Windows Vista when ALT key was pressed.  


Version 1.1.0.19 (13 August 2008)

· Bug fix: Application was always saving connection list to 'c:\temp\sqlist.txt'.  


Version 1.1.0.18 (7 August 2008)

· Most recently used (MRU) file list functionality implemented.  
· Reduced memory usage when storing JPEG image thumbnails.  
· Bug fix: Error when query does not return any textual columns.  
· Bug fix: Users could not enter license details when trial period has expired.  


Version 1.1.0.15 (23 May 2008)

· Image export now allows one or more image processing functions to be applied.  
· Miscellaneous bug fixes.  


Version 1.0.0.8 (11 April 2008)

· Initial release of SQL Image Viewer.