The SIMEK Facilities Management (FM) Project Blog

This post is another post compiled from SIMEK techblog for consolidation.

If you want check where is your database for sybase is located in your localhost, you can check inside c:\program files\afm15\projects\hlb or c:\afm15\projects\hlb (this location you have been set on which drive when you install the ARCHIBUS/FM V15)

When the database is running, there will be a small SQL icon on your taskbar :

Here are the details single-user database is working properly. Now you can access all the database inside ARCHIBUS/FM V15.

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.