Issue:
Using SQL 2012 with the ESOPT Tool.
Basis:
ESOPT 6.2.12 is not officially certified to use with MS SQL 2012.
Determination:
Caution: MS SQL 2012 has not been tested.
MS SQL 2012 can be used by making a modification to the esopt.ini file.
The first section, AppSettings defines the type of SQL database
[AppSettings]
DBType=SQLExpress
The second section contains the version of SQL.
Provider=SQLNCLI1X defines the version of SQL Native Client
SQLNCLI0 is SQL 2008
SQLNCLI1 is SQL 2012
[SQLExpress]
Provider=SQLNCLI10
DBName=ESOPT
DBPath=C:\Program Files\ESOPT\Data
SQLServerName=.\SQLExpress
DBDescription=ESOPT Local Database
UserPath=DEFAULT
ImportExportPath=DEFAULT
ConnectionTimeout = 30
CommandTimeout = 3000