Terian ID Creator v1.30 in Testing

For the past couple of weeks we have been testing some major changes to the underlying database access framework that Terian ID Creator uses.

Terian IDC version log

This is a considerable update and the information below may be subject to change.

Overhaul Driver:

The primary driver (pardon the pun) behind this change has been to migrate to FireDAC as it is intended to become the replacement for the venerable dbExpress (DBX) data access library which in time will most likely become deprecated. The secondary driver was the desire to remove the SQL Server 2008 R2 Native Client prerequisite, as having an almost 10 year old application installation as a prerequisite is not necessarily the best look when installing software.

So we have updated the native client prerequisite to SQL Server 2012 Native Client, which is the latest available from Microsoft with their future support moving towards the ODBC Driver which supports a more diverse set of operating systems.

Database Support:

The plan at this stage is for Terian ID Creator to support both the SQL Server 2012 Native Client and the newer Microsoft ODBC Driver 13 for SQL Server. This will provide support for the following versions of SQL Server:

  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

Officially Terian ID Creator will only support SQL Server 2012, 2014, and 2016. Other versions may work, however they will not be tested or supported.

Operating System Support:

The change to the data access drivers also in turn means support for versions of Windows prior to 7 have also been dropped. The following operating systems will be supported in v1.30:

  • Microsoft Windows 7
  • Microsoft Windows 7 SP1
  • Microsoft Windows 8
  • Microsoft Windows 8.1
  • Microsoft Windows 10

Similarly to the database server support, other versions of Windows may work, however they will not be tested or supported.

We are very early in the testing phase, and it is likely some additional changes will be made in turn leading to more testing, so we have no expected release date, however as we progress we will keep you updated.

Terian ID Creator v1.20 Released

Slightly sooner than I had anticipated in the previous post, I have just released v1.20 of Terian ID Creator. You can download it from the official website here

Terian IDC v1.20 Changelog

The primary focus of this update is the Camera Control functionality outlined here.

In addition to this, several bugs have been fixed as well as better support for OS Authentication mode in Database connections has been included.

The default folder structure has been adjusted slightly too, the new default structure is as follows…

%ProgramFiles(x86)%Sjones LimitedTerianTerianIDCDocs
%ProgramFiles(x86)%Sjones LimitedTerianTerianIDCSystem
 
%ProgramData%Sjones LimitedTerianTerianIDCDataDB
 
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCData
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataExports
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataForms
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataImports
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataLogs
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataPhoto CDS
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataPhotos
%PUBLIC%DocumentsSjones LimitedTerianTerianIDCDataReports

One small issue that remains is that while official support for SQL Server 2008 R2 has been dropped, there is still a requirement for the SQL Server 2008 R2 Native Client (this can be installed separately). Unfortunately removal of this requirement was going to delay testing significantly, so I am planning to have this requirement removed in a future version.