MSDE / SQL express as travel database

In this article

    Prerequisites

    Client computers must install either MSDE or SQL Express depending on what kind of central database. Run it, reboot, and observe the small SQL Server icon with a small green triangle in the taskbar.

    MSDE is NOT supported as a travel database if your central SuperOffice database is running on MS SQL Server 2005.

    SQL Express as a travel database with MS SQL Server 2005 centrally is supported from 6.2. If you're not running 6.2 or higher you have to use the default Built-in database engine or Sybase Adaptive Server Anywhere as your travel database. See how to choose the correct travel database

    Automatic setup

    As long as the central database have set up MSDE as the Local datatype, everything is automatically set up for the user who have been assigned travel rights in SOAdmin. The central SuperOffice.ini file have the information so SOLoader.exe sets up the local datasource and adds the ProtoServerPath and ProtoClientPath to the local SuperOffice.ini.

    As long as an update prototype has been generated, the user may now perform a local update by clicking the travel icon in the navigator:  
    As long as you're logging in to the local database on travel, the icon will look like this:

    Manual setup

    Default paths set up automatically are:

    local_archivepath=c:\Documents and Settings\\Local Settings\Application Data\SuperOffice\SO_LOCAL
    Local_Datapath=ODBC:SuperOfficeLocal

    If you want to change the location of the local document archive, you need to edit the users SuperOffice.ini file. You may change the name of the datasource as long as you also change the Local_Datapath=ODBC:XXX where XXX need to be the new name of the local datasource.

    MSDE (both MSDE and SQL Express) require ProtoClientPath (and ProtoServerPath) set. If the client is not going to make a prototype you only need to add ProtoClientPath= under the [SuperOffice] section in SuperOffice.ini