Install Windows client

In this article

    MSI Installer

    Contains SuperOffice Windows client, Mail Link, Ribbons, Travel Gateway, Mail Gateway.

    Performs: Copies installation files, adds registry settings and program shortcuts.

    Install Windows Client

    All installation tasks are performed by the installer found in the folder SuperOffice Server\Client

    To install the client run the MSI Installer SuperOffice8.exe found in the SuperOffice Server\Client folder.

    Note: If you want to use Oracle you need to install the Oracle client drivers on each client first. Oracle 10g may run on the Microsoft version of the Oracle driver. 

    It will default install to C:\Program Files (x86)\SuperOffice. Default location for SuperOffice temp (SoTemp) is Local

    If you choose Customize you may choose where you want to install it and also choose to install additional programs.

     

     

    Advanced installation will give you option to select additional features and will display installation wizard for each component.

    Both Mail Link and Windows client Advanced installation have Typical and Custom installation types. Custom installation for Windows client allows you to select which languages and additional features will be installed.

     

     

    After the installation is completed both Mail Link and Windows Client are installed.

    The following must be prepared for computers running the win client

    For Microsoft SQL Server: Make sure the ODBC driver you want to use is installed on the client.

    For Oracle: Make sure the the 32 bit version of Oracle Client is installed. Note - we require the Runtime installation. You also need to set up the Local Net Service Name from the Oracle Net Configuration Assistant.

    The client installer will install all prerequisites, the .Net framework is a web download so the client needs access to the internet when installed.

     

    ODBC and ADO.NET connections

    Most parts of SuperOffice product family use ADO.NET connection. There are some exceptions which for historical reasons use ODBC connection.

    Win client

    Win client uses a mix of ODBC and ADO.NET connections. The new parts (e.g. selections, quote, bulk update, guide, archives) use ADO.NET, some parts like e.g. Diary are ODBC based.

    Win Admin client uses a mix of ODBC and ADO.NET connections. E.g. Prototype generation uses ADO.NET, Import use ODBC. 

    Import in Win Admin is the only place which can benefit from SQL Native client driver with bulk copy capabilities. In other parts using ODBC the difference in performance between SQL Native Client and Microsoft ODBC Driver is insignificant.
    On SQL Server we are using the .NET version of the bulk copy functionality which is just as fast as the ODBC.
    SORT.exe, SORTS.exe, SoTrvGate.exe, Reporter Studio - these use ODBC.

     

    DBSetup

    DBSetup uses a mix of ODBC and ADO.NET connections. ODBC in DBsetup is mainly for historical reasons and is not actually used for database setup, upgrade, export and import; those have all been rewritten to C# and use ADO.net.

     

    Web client / Netserver

    Netserver use ADO.NET connection only. Web client doesn't have its own database connection and uses Netserver to connect to a database and so_arc. The only part of a Web client which has its own connection is Web Reporter and it uses ODBC connection.

     

    Service

    Service uses both ODBC and Netserver connection.

     

    Migration Tool

    Migration Tool uses ADO.NET to connect to the database. It also uses Win client to read some information from SuperOffice database. If Win client is not installed a user will get the following dialog and will have to type in the answers manually.

    Migration Tool

    These are our current tested operating systems for win client

    Currently tested client operating systems if running SuperOffice Onsite (for our Mac users this means only the web client).

    Want to know if a newly released OS is compatible? Check your compatibility reports.

    WIN Operating system 8.0 8.1 8.2 8.3 R01 - R03 8.3 R04 8.4 8.5
    Windows 10*
    Windows 8.1
    Windows 8
    Windows 7 x64 (SP2)**
    Windows 7 x86 (SP2)**

    * Windows 10 is supported from Windows 10 Anniversary Update (version 1607)

    ** Windows 7 SP1 and SP2 has reached end of support 14th January 2020

     

    MAC Operating system* 8.0 /
    SR1 / SR2
    8.0 SR3 - SR6 8.1 8.2 8.3 8.4 8.5
    Mac OS Catalina
    Mac OS Mojave
    Mac OS High Sierra
    Mac OS Sierra 
    Mac OS X El Capitan
    Mac OS X Yosemite
    Max OS X Mavericks

    * Mac users - the biggest source of incompatibility is our Web Tools, so for the Mac OS versions not part of our tested configurations this is the most likely part of the product that will not work.

    These are our current tested browsers for win client (web panels)

    Tested browsers to run both Win and Web applications.

     Want to know if a newly released browser is compatible? Check your compatibility reports.

    Browsers 8.0 8.1 8.2 8.3 8.4 8.5
    Edge
    Internet Explorer 11
    Internet Explorer 10
    Chrome Win
    FireFox Win
    Chrome Mac
    FireFox Mac
    Safari Mac

     

    Be especially aware of the different versions of the ODBC drivers.

    SuperOffice CRM has officially been tested on MS SQL Server 2012, 2014, 2016, 2017 and 2019. 

    SQL Server 2019

    Name Version
    SQL Server 2019 15.0.2000.5

    ODBC drivers

    Name Version
    ODBC Driver 17 for SQL Server  17.4.2.1

     

    SQL Server 2017

    Name Version
    SQL Server 2017 14.0.1000.169

    ODBC drivers

    Name Version
    ODBC Driver 17 for SQL Server 2017.171.00.01

     

    SQL Server 2014, 2016

    Name Version
    SQL Server 2016 13.0.1601.5
    SQL Server 2014 12.0.2000.8

    ODBC drivers

    Name Version
    ODBC Driver 13 for SQL Server 2015.131.811.168

     

    SQL Server 2012 (Enterprise or Standard edition*)

    Name Version
    SQL Server 2012 11.0.2100.60

    ODBC drivers

    Name Version File
    SQL Native Client 11.0 2011.110.1750.32 SQLNCLI11.DLL

     * Our compability tests have been performed on both Enterprise and Standard edition of SQL server 2012. When looking at the specification for the different version, the other versions of SQL Server 2012 should also work. The only funcitonallity we "may" use (not required), is "Full-text and semantic search". So when choosing your SQL Server 2012 version, make sure it covers your needs. Be especially aware of the different versions of the ODBC drivers. This has turned out to be greatest source of incompatibility.

    Be especially aware of the different versions of the ODBC drivers.

    SuperOffice CRM has been officially tested on Oracle 11g, 12c and 18c.

    Oracle 18c*

    Server

    Name Version
    Oracle 18c  18.3.0.0.0

     

    Client

    Name Version
    Oracle 18c Client 18.3.0.0.0

     * See below Oracle 18c compatibility info

     

    Oracle 12c

    Server

    Name Version
    Oracle 12c  12.1.0.1.0

     

    Client

    Name Version
    Oracle 12c Client 12.1.0.1.0

     

    ODBC drivers

    Name Version File
    Oracle in OraClient 12home 12.01.00.01 SQORA32.DLL

     

    Oracle 11g

    Server

    Name Version
    Oracle 11g Release 2 11.2.0.1.0
    Oracle 11g Release 1 11.1.0.7.0
    Oracle 11g Release 1 11.1.0.6.0

     

    Client

    Name Version
    Oracle 11g Client 11.2.0.1.0
    Oracle 11g Client 11.1.0.7.0
    Oracle 11g Client 11.1.0.6.0

     

    ODBC drivers

    Name Version File
    Oracle in Orahome11 11.2.0.3.0 SQORA32.DLL
    Oracle in Orahome11 11.2.0.1.0 SQORA32.DLL
    Oracle in Orahome11 11.1.0.7.0 SQORA32.DLL
    Oracle in Orahome11 11.1.0.6.0 SQORA32.DLL