3 Converting from SuperOffice 4.0 C-tree to Microsoft SQL Server

Converting from SuperOffice 4.0 C-tree to SuperOffice 4.0 on Microsoft SQL Server is done in these steps:

  • Install the SQL Server
  • Configure the SQL Server
  • Install the ODBC client
  • Reinstall SuperOffice 4.0 for Microsoft SQL Server
  • User administration

All steps have to be done in this order, or the installation will fail.

3.1 Install the Microsoft SQL Server
See Appendix A.

3.2 Configure the SQL Server
See Appendix B.

3.3 Install the ODBC client
See Appendix C.

3.4 Reinstall SuperOffice 4.0 for Microsoft SQL Server
In order to get all SQL Server specific files into your program directory you have to reinstall SuperOffice 4.02. Do not perform an upgrade - do a new installation.

  1. From one of the client computers that are going to run SuperOffice 4.0, insert the SuperOffice CD or disk 1 and run setup.exe from the root directory. Select installation language
  2. Select Multi-User installation.
  3. Apply information in this dialog.



  4. The most important information is which ODBC-Database you are going to install on. Select the one you created when you installed ODBC for SQL-Server.
    When prompted do NOT overwrite any files, except AREA.DB. This file may be overwritten.
  5. When the installation is done, do NOT start SuperOffice. Open the file SOSETUP.INI located in your new SuperOffice network program-directory. Change the following settings:

    From:

    [General]
    Version=4.0
    Action=Register

    To:

    [General]
    Version=4.0
    Action=Rebuild
    Datapath=S:\SO_ARC\DATA\SUPEROF4.DAT *
    Datapath2=ODBC:SuperOffice

    *Must be adjusted to your location of superof4.dat
  6. Save the file and start SOSETUP.EXE from your SuperOffice network program-directory. Enter a user-id and password for a user with userlevel 0 in your c-tree database. When prompted for a DBA-user in the SQL Server database, enter this user.

    Username: sa
    Password: **** (whatever password the sa user has on your SQL Server, default is blank)

    SuperOffice will now complete the conversion of the database and when this is done, you can start SuperOffice 4.02 on your new platform.

3.5 User administration
See Appendix E.