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
Folders and files
Reference Guide
Main menu
Connect to Database
Connecting to Firebird databases
Connecting to MySQL databases
Connecting to Oracle databases
Connecting to SQLite databases
Connecting to SQL Server databases
Connecting using ODBC
Connecting to a DB2 database
Connecting to a PostgreSQL database
Options
General options
Editor options
Thumbnail options
Image view
Check for updates
About
The work area
SQL editor
Table browser
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Exporting Microsoft Access OLE data
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

Version history

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.