The SIMEK Facilities Management (FM) Project Blog » How To Create A Default Database In ARCHIBUS/FM V15

02.11.07

How To Create A Default Database In ARCHIBUS/FM V15

Posted in ARCHIBUS/FM Software at 2:28 pm by Admin

This post was originally written on one of our technical blog. We decided to consolidate into this blog since this blog receives more web traffic.

1. Open ARCHIBUS/FM Application on the desktop.

2. Select File -> Project -> New..

3. Fill the table with some information about the project.(make sure to select a single user)

4. Then select ‘Create Project’.

5. This project only can run in single user.If you want to run with multi-user, you need to have a Sybase licensed.

Here some information about Adaptive Server Anywhere :-
ARCHIBUS/FM 15 works with Adaptive Server Anywhere 7.0.2 , 8 or 9.0 Adaptive Server Anywhere (ASA) comes in the following versions :

Single-User

  • The single-user is a personal server that you install in a single-user configuration. This is a “runtime” version of the Sybase server, which allows full access to your database data.This version is appropriate for most single-user configurations of ARCHIBUS/FM for Sybase.
  • The single-user server ships on the ARCHIBUS/FM CD with all copies of ARCHIBUS/FM. The ARCHIBUS/FM Setup program installs this server in the \Afm15\Wsql directory.Since it is a standard component, the installation of the Single-User server is covered in Readme.doc.

Single-User/Authoring Server

The Single-User/Authoring server is also a personal server. However, it provides the following additional features that make it appropriate for sites that are making changes to their schema or that are creating a new schema:

  • It supports the use of the ALTER TABLE and CREATE TABLE SQL statements so that you can create new SQL tables. As such, the ARCHIBUS/FM Update Schema command is enabled when you use the Single-User/Authoring server.
  • It supports the use of stored procedures and triggers. Several ARCHIBUS/FM features, like archiving work orders and work requests, operate slightly differently in the Single-User version of ARCHIBUS/FM in order to avoid using the stored procedures and triggers allowed by the Single-User/Authoring and Multi-User versions of Sybase.
  • You purchase the Single-User/Authoring server separately from the ARCHIBUS/FM
    program. It comes on its own CD and you install it using its own Setup program.
    For installation instructions for the Single-User/Authoring server, see /Afm15/Doc/Advanced Installation Techniques.pdf.

Multi-User Server

  • The Multi-User server has all of the features of the Single-User/Authoring server, but it also allows multiple users to access databases simultaneously. Sites that have multi-user versions of ARCHIBUS/FM use this server.
  • The Multi-User database server program includes the customization features found with the Single-User/Authoring server. However, ARCHIBUS, Inc. suggests that you use the Single-User/Authoring version of the server to make any schema modifications because:
  • Adaptive Server Anywhere running under some types of network software uses a great deal of system resources when you perform schema modifications.
  • You will always want to test your changes locally before posting them to your multi-user production environment.
  • A copy of the Single-User/Authoring server is included with each multi-user version of Adaptive Server Anywhere.

You purchase the Multi-User server separately from the ARCHIBUS/FM program. It comes on its own CD and you install it using its own Setup program.

Leave a Comment

You must be logged in to post a comment.