We’ve developed some resources to help you work effectively from home during COVID-19 Click to learn more

Prepare Win client computer

In this article

    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